Data Engineer

Data Engineer (Mid-level)|Information Technology

Location: Darien, IL (Hybrid –Local Candidates Only)

Salary Range: $100,000 - $110,000 base salary + annual incentive bonus

Travel: Minimal (up to 5%)

The American 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. We represent more than 11,000 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 is committed 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 reports are required to be onsite on 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 considered, requiring onsite presence.

AASM is looking for a Data Engineer who enjoys building well-designed pipelines and turning raw source data into something people can actually use. This role calls for strong T-SQL and SQL Server expertise, 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 function, you’ll partner with stakeholders, deliver practical solutions, and play a meaningful role in how the organization works with its data.

• Design, build, and maintain scalable data pipelines to ingest, transform, and load data into a centralized data warehouse.
• Integrate data from APIs and SaaS platforms, developing automated ingestion workflows with appropriate controls (e.g., authentication, pagination, rate limiting, incremental loads).
• Implement and optimize ELT processes in SQL Server to ensure performance, reliability, and scalability.
• Develop and maintain data 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.

• Bachelor’s degree in a related field or equivalent experience
• 3+ years of data engineering or ELT experience
• Strong SQL Server proficiency for 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 data architectures, including data lakes and lakehouse environments.
• Ability to design, optimize, and scale data pipelines for performance and reliability.
• Proficiency in 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 communication skills to collaborate with technical and business stakeholders.

• Experience with cloud platforms (Azure, AWS)
• Familiarity with tools like Microsoft Fabric, Snowflake, or Databricks
• Knowledge of API integrations (REST, OAuth)
• Experience with data testing and quality validation
• Understanding of data lake/lakehouse concepts
• Relevant certifications in data or cloud technologies

The AASM is proud to be an…