American College of Chest Physicians Logo

American College of Chest Physicians

Data Analytics and Insights Engineer

Posted 7 Days Ago
In-Office
Glenview, IL, USA
105K-115K Annually
Senior level
In-Office
Glenview, IL, USA
105K-115K Annually
Senior level
Support and monitor data pipelines and curated datasets, perform exploratory analysis and model validation, develop SQL data models in Snowflake, troubleshoot ETL/ELT jobs, integrate proprietary and third-party data, validate AI-generated insights, and collaborate with stakeholders to deliver Customer 360 and leadership analytics.
The summary above was generated by AI

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 

Similar Jobs

4 Minutes Ago
Hybrid
Chicago, IL, USA
110K-110K Annually
Senior level
110K-110K Annually
Senior level
Information Technology • Professional Services • Financial Services
Lead and maintain high-availability production and non-production databases (primarily SQL Server) supporting clearing operations. Responsibilities include performance tuning, capacity planning, HA/DR design and runbooks, upgrades, automation for monitoring and maintenance, incident escalation, vendor interaction, and participation in on-call rotation and cross-region handoffs.
Top Skills: Always On Availability GroupsCommvaultExadataJIRAKanbanLog ShippingOraclePgbackrestPostgresReplicationServicenowSQL ServerT-SqlTransparent Data Encryption (Tde)Windows ServerWindows Server Failover Clustering (Wsfc)
5 Minutes Ago
Hybrid
Chicago, IL, USA
75K-95K Annually
Junior
75K-95K Annually
Junior
Information Technology • Professional Services • Financial Services
Support firm-wide compliance by managing employee registration/licensing (FINRA/NFA), maintaining compliance databases, tracking attestations and filings, assisting exams and training, coordinating cross-departmental compliance matters, and documenting projects and follow-up actions.
Top Skills: Finra CrdMS OfficeNfa BasicServicenowSharepoint
19 Minutes Ago
In-Office or Remote
United States
43K-58K Annually
Mid level
43K-58K Annually
Mid level
Big Data • Information Technology • Software • Analytics • Energy
Handle incoming owner relations inquiries about revenue, land, division orders, JIB, A/R, and A&P. Log and follow up cases in a tracking system, build trusting client relationships, manage difficult situations calmly, provide accurate timely responses, and participate in cross-training.
Top Skills: MS Office

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account