Data Engineer

Data Engineer (Mid-level)|Information Technology Location: Darien, IL (Hybrid –Local Candidates Only) Salary Range: $100,000 - $110,000base 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. Werepresentmore 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 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 considered,requiring onsite presence. PositionOverview 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. WhatYou’llDo 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 with appropriate 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. WhatWe’reLooking For Bachelor’s 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 design,optimize, 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 MicrosoftFabric,Snowflake,orDatabricks 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 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 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, 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 #J-18808-Ljbffr