Data Engineer
American Academy of Sleep Medicine•Darien, IL
•$100,000 - $110,000•Hybrid
About The Position
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.
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.
Nice To Haves
- 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
Responsibilities
- 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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
