Data Analytics and Insights Engineer

Primary Purpose:

Supports CHEST's growing data ecosystem by supporting and monitoring high-quality data pipelines, performing advanced analytics, and supporting our enterprise AI analytics platform. This role works closely with stakeholders across the organization to deliver accurate insights, maintain reliable data systems, and support key strategic initiatives such as Customer 360 and leadership-level analytics.  This position is located in Glenivew, IL.

Essential Functions/Responsibilities:

Demonstrates a passion for crushing lung disease and embodies CHEST values: honor the team, lead with integrity, leverage passion, cultivate innovation, and have serious fun. 

CHEST Data Analytics and Engineering:

• Provide SQL and data support to the Analytics team. 
• Conduct exploratory analysis and validate analytical models. 
• Support Customer 360 segmentation and data products. 
• Develop and maintain SQL queries and data models using Snowflake. 
• Maintain and support ETL/ELT data pipelines and curated datasets. 
• Integrate CHEST proprietary data with third-party sources. 
• Monitor data jobs and troubleshoot workflow issues in support of Data Architecture & Engineering Team. 

Analytics Platform Support:

• Work with leadership and users to understand deep-dive questions. 
• Validate AI-generated results and ensure data accuracy. 
• Maintain curated datasets and support platform improvements. 
• Provide documentation and training to help users get the most value from the platform. 

Project and Agile Support:

• Translate business needs into user stories and Jira tasks. 
• Participate in Agile/SCRUM ceremonies and maintain project notes. 
• Communicate status updates, risks, and findings to stakeholders. 

Collaboration:

• Align with cross-functional teams to support organizational goals. 
• Share best practices for SQL, data modeling, and analytics. 

Requirements

Required Qualifications:

• 5 years of related experience 
• Strong SQL skills (Snowflake, MS SQL preferred) 
• Experience with data modeling 
• Analytical experience with dataset exploration and model validation 
• Strong communication skills to support both technical and non-technical users 
• Familiarity with Agile/SCRUM and Jira 

Preferred Qualifications:

• Experience with AI analytics platforms or prompt-driven insights tools 
• Customer 360 or identity-resolution experience 
• Python or dbt experience is a plus
• MS SQL and/or Snowflake monitoring, troubleshooting, and resolution of job failures. 
• CRM Support in NetFORUM for job creation and maintenance. 

Benefits

While we offer benefits that you'd expect from any forward-thinking, progressive organization, we offer a lot of extras too, including the standardization of a hybrid working environment. From tuition reimbursement to parental leave, we offer the benefits that you want most.

• Health and Wellness: Medical, dental, and vision insurance*; flexible spending