Data Engineer

Data Engineer (Mid-level)Information Technology

Location: Darien IL (Hybrid Local Candidates Only)

Salary Range:$100000 - $110000base salary annual incentive bonus

Travel: Minimal (up to 5%)

Company Overview

TheAmerican Academy of Sleep Medicine(AASM) is the only professional society in the U.S. dedicated exclusively to the medical subspecialty of sleep medicine. Founded in 1975 and based in Darien IL AASM advances sleep care and improves lives through education advocacy research and accreditation. Werepresentmore than 11000 accredited member sleep centers and individual members nationwide.

In pursuit of improving sleep health and promoting high-quality patient-centered care for all people the AASM is dedicated to fostering a culture that iscommitted to excellence inclusive flexible collaborative appreciative supportive and innovative. Our staff connects to these team values in many ways and we are looking for others who would like to experience the same.

We support work-life balance through a hybrid work environment and encourage employees to work in the office two days per week with Wednesday as an anchor day to promote connection and collaboration. Managers with direct reportsare required tobeonsiteon Wednesdays. All employees report onsite twice per year for two consecutive days for all-staff meetings and functions.Due to these requirements only local candidates will be consideredrequiring onsite presence.

PositionOverview

AASM is looking for a Data Engineer who enjoys building well-designed pipelines and turning raw source data into something people canactually use. This role calls for strong T-SQL and SQL Serverexpertise hands-on experience with ELT development and dimensional modeling (star schema and snowflake) and the ability to create analytics-ready datasets that power better reporting and decision-making. As part of a growing BI functionyoullpartner with stakeholders deliver practical solutions and play a meaningful role in how the organization works with its data.

WhatYoullDo

• Design build andmaintainscalable data pipelines to ingest transform and load data into a centralized data warehouse.
• Integrate data from APIs and SaaS platforms developing automated ingestion workflows withappropriate controls(e.g. authentication pagination rate limiting incrementalloads).
• Implement andoptimizeELT processes in SQL Server to ensure performance reliability and scalability.
• Develop andmaintaindata models (e.g. star and snowflake schemas) to support reporting and analytics.
• Partner with business and technical stakeholders to translate requirements into effective data solutions.
• Ensure data quality and consistency by implementing automated validation checks and resolving pipeline issues.
• Document data systems and processes support governance standards enable BI integration (e.g. Power BI) and advance self-service analytics.

WhatWereLooking For

• Bachelors degree in a related field or equivalent experience
• 3 years of data engineering or ELT experience
• Strong SQL Serverproficiencyfor ELT and data transformation with experience in BI tools (e.g. Power BI) and data warehousing best practices.
• Advanced knowledge of data modeling (e.g. star and snowflake schemas) and dataarchitectures including data lakes andlakehouseenvironments.
• Ability to designoptimize and scale data pipelines for performance and reliability.
• Proficiencyin Python (or similar) for data manipulation and automation with knowledge of API standards (e.g. REST OAuth) for secure integration.
• Experience implementing automated data pipeline testing including validation quality checks and regression testing.
• Strong communicationskills to collaborate with technical and business stakeholders.

Preferred Qualifications

• Experience with cloud platforms (Azure AWS)
• Familiarity with tools like MicrosoftFabricSnowflakeorDatabricks
• Knowledge of API integrations (REST OAuth)
• Experience with data testing and quality validation
• Understanding of data lake/lakehouseconcepts
• Relevant certifications in data or cloud technologies

Our Culture and Benefits
The AASM is proud to be anEqual Employment Opportunityemployer and a recipient of the2025 Best Workplaces in Illinois award. We celebrate diversity and are committed to creating an inclusive environment for all employees. Aside from thegreat jobopportunity we offer a collaborative and fun work culture with amazing Working at AASM for a glimpse of AASM work life.

• Affordable medical & dental coverage for you and your family
• Free life & disability insurance
• 3 weeks of PTO plus paid company holidays
• 8 weeksPAID parental leave
• Flex-time hours
• Business casual environment
• Generous 401(k) plan
• Flexible spending & dependent care accounts
• Health savings account with generous employer contributions
• Professional development(association membership tuition reimbursement certificationLinkedIn Learning)
• Pet insurance
• Theft ID coverage
• Discounted fitness membership
• Door Dash meal perks
• Service recognition and peer-to-peer platform
• Weekly Wellness Wednesdays
• Twice daily plank breaks
• Seasonal staff events