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.
BenefitsWhile 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 InformationThe 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.
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
