Data Engineer

The American Academy of Sleep Medicine (AASM) is looking for a Data Engineer to design, build, and maintain scalable data pipelines to ingest, transform, and load data into a centralized data warehouse. The ideal candidate will have strong T-SQL and SQL Server expertise, hands-on experience with ELT development and dimensional modeling, and the ability to create analytics-ready datasets that power better reporting and decision-making.

Requirements

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

Benefits

• 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