Data Analytics and Insights Engineer

American College of Chest Physicians•Glenview, IL

3d•$105,000 - $115,000•Hybrid

About The Position

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. Essential Functions/Responsibilities: Demonstrate a passion for crushing lung disease and embody 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

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

Nice To Haves

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.

Responsibilities

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.
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.
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.
Align with cross-functional teams to support organizational goals.
Share best practices for SQL, data modeling, and analytics.