Data Engineer

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