Engineer Jobs in Darien, IL

1 job found

Include remote jobs

1mo ago

Data Engineer

American Academy of Sleep Medicine Darien, IL

Darien, IL

1mo ago Closed

$100k - $110k/yr Full time Analytics Api Integration Azure

This position is no longer accepting applications (closed Jun 20, 2026).

Job Description

Data Engineer role at the American Academy of Sleep Medicine in Darien, IL (hybrid) focusing on building scalable data pipelines and analytics-ready datasets.

Responsibilities

Create and maintain scalable data pipelines to ingest, transform, and load data into a centralized data warehouse.
Incorporate data from APIs and SaaS platforms, building automated ingestion workflows with proper controls such as authentication, pagination, rate limiting, and incremental loads.
Design and optimize ELT processes in SQL Server to deliver strong performance, reliability, and scalability.
Develop and sustain data models using star and snowflake schemas to enable robust reporting and analytics.
Work with business and technical stakeholders to convert requirements into effective data solutions.
Ensure data quality and consistency by implementing automated validation checks and resolving pipeline issues promptly.
Document data systems and processes, support governance standards, enable BI integration ( Power BI ), and promote self‑service analytics.

Requirements

Bachelor’s degree in a related field or equivalent experience
Minimum of three years in data engineering or ELT development
Strong SQL Server capabilities for ELT and data transformation, with experience in BI tools (Power BI) and data warehouse best practices
Expertise in data modeling (star and snowflake) and data architectures, including data lakes and lakehouse environments
Proven ability to design, optimize, and scale data pipelines for performance and reliability
Proficiency in Python (or similar) for data manipulation and automation, plus knowledge of API standards (REST, OAuth) for secure integrations
Experience implementing automated data pipeline testing, including validation, quality checks, and regression testing
Strong communication skills for collaboration with technical and business stakeholders

Technologies

T‑SQL, SQL Server
Power BI
Python
REST
OAuth
Azure
AWS
Microsoft Fabric
Snowflake
Databricks

Compensation

Salary: $100,000 – $110,000 per year

Location

Darien, IL (Hybrid – Local candidates only)

Travel

Minimal travel required, up to 5% of time

Benefits

401(k)
Dental insurance
Employee assistance program
Flexible schedule
Flexible spending account
Health insurance
Health savings account
Life insurance
Paid time off
Parental leave
Professional development assistance
Referral program
Tuition reimbursement
Vision insurance
Affordable medical and dental coverage for you and your family
Free life and disability insurance
3 weeks of PTO plus paid company holidays
8 weeks paid parental leave
Flex-time hours
Business casual environment
Flexible spending and dependent care accounts
Pet insurance
Theft ID coverage
Discounted fitness membership
DoorDash meal perks
Service recognition and peer-to-peer platform
Weekly Wellness Wednesdays
Twice daily plank breaks
Seasonal staff events

View full job page →

Get Engineer Jobs in Darien, IL alerts

New Engineer Jobs in Darien, IL, daily.