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%)

Company Overview 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.

Position Overview

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.

What You'll Do

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

What We're Looking For

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

Preferred Qualifications

• 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

Our Culture and Benefits

The AASM is proud to be an Equal Employment Opportunity employer and a recipient of the 2025 Best Workplaces in Illinois award. We celebrate diversity and are committed to creating an inclusive environment for all employees. Aside from the great job opportunity, we offer a collaborative and fun work culture with amazing benefits. Visit "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 weeks PAID 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, certification, LinkedIn 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