Data Analytics and Insights Engineer

American-College-of-Chest-Physicians; Glenview (IL); Hybrid; USD 105,000 - 115,000; Full time

Benefits offered by this job

Health insurance

Dental and vision insurance

Hybrid work environment

Tuition reimbursement

Paid time off

Paid holidays

Job summary

American College of Chest Physicians is seeking a data analytics professional to support and monitor high-quality data pipelines and analytics platforms. You will collaborate with stakeholders to deliver accurate insights, maintain data systems, and support initiatives like Customer 360 and leadership analytics.

Key responsibilities include SQL development with Snowflake and MS SQL, data modeling, ETL/ELT pipelines, and AI-analytics validation.

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 for technical and non-technical users
• Familiarity with Agile/SCRUM and Jira
• Ability to accommodate periodic travel
• Hybrid work schedule: 2 days WFH, 3 onsite at Glenview HQ (Tue/Wed anchor days)

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.
• 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.

Skills

SQL

Snowflake

MS SQL

Data modeling

Analytical skills

Agile/SCRUM

Jira

Travel readiness

Tools

Snowflake

MS SQL

NetFORUM

Job description

Description

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:

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
• Ability to accommodate periodic travel.
• Ability to adhere to CHEST's hybrid work schedule, which includes 2 days per week work-from-home, and 3 days per week onsite at CHEST headquarters in Glenview. Tuesday and Wednesday are CHEST's anchor days, and a 3rd onsite will be decided between employee and supervisor.

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 account*; long- term and short-term disability insurance; life/AD&D insurance
• Work/life Balance: 37.5-hour work week with flexible start times; Paid Time Off; Paid parental leave; Hybrid work environment; Paid holidays
• Giving and sharing: 401(k) with matching contribution from CHEST*; Health club and fitness reimbursement; Employee counseling program; Reimbursement for professional memberships; Tuition Reimbursement
• Office perks: Lunch & Learns; Annual Health Fair; Professional development courses; Volunteering opportunities; Annual Holiday Party; In-office "Busy Breaks"

Additional Information

The annual base salary range for this position is USD $105,000 to USD $115,000. This pay range represents base pay only and excludes any additional items such as incentives, bonuses, or other items. CHEST considers factors such as, but not limited to, the scope and responsibilities of the position, the candidate's work experience, education/training, key skills, internal peer equity, and market and organizational considerations when extending an offer. CHEST is proud to be an equal opportunity employer and does not discriminate on the basis of race, color, national origin, sex, gender identity, religion, sexual orientation, age, disability, parental status, veteran status, or any other protected status under applicable laws.

At CHEST, our employees come from different backgrounds with various lived experiences and dynamic strengths. We strive to continuously improve our way of working to reflect our commitment to inclusion and equity and build a workforce that reflects the communities that we serve. And that means we need you! Your experiences may only perfectly align with some qualifications listed in the job description. But if you are excited by this position, we highly encourage you to consider still applying. You may be just the right candidate to help us with our mission to improve patient care.

This description was designed as a convenience to acquaint employees and managers with the essential elements of the position. It is solely to summarize basic duties, and it is not intended to be a contract or guarantee of employment or any specific terms or conditions of employment.

*Participation is voluntary