Hybrid Data Engineering Lead: AWS Data Platform

Coates Group; Chicago (IL); Hybrid; USD 145,000 - 165,000; Full time

Benefits offered by this job

Annual bonus program

Thrive Program

Flexible work options

Wellbeing days

Give Back Day

Job summary

Coates Group seeks a Data Platform Engineer in Chicago to lead the evolution of our enterprise AWS data platform and enable analytics, BI, and future AI capabilities. You will design scalable pipelines and governance while guiding a growing team of data engineers.

You will split time between in-office collaboration in the West Loop (3 days) and remote work (2 days), contributing to a fast-paced global tech environment.

Qualifications

• 5+ years of experience in data engineering with scalable system design.
• Proven experience modernizing or evolving enterprise data platforms.
• Deep hands-on AWS data ecosystem experience (S3, Glue, Spark, Athena, Redshift).
• Strong Python and SQL for production-grade data pipelines and transformation workflows.
• Experience implementing workflow orchestration solutions, preferably Airflow.
• Experience with infrastructure-as-code and automated deployment practices using Terraform or AWS CDK.
• Familiarity with modern data warehousing and lakehouse concepts, including Snowflake, Redshift, or Databricks.
• This role will be 3 days in office in the West Loop and 2 days remote.

Responsibilities

• Architect and evolve scalable, cost-efficient AWS data platform for analytics and future AI capabilities
• Design and implement reliable, production-grade data pipelines for batch and near real-time data
• Define enterprise standards for data architecture, modeling, observability, reliability, and platform performance
• Lead foundational technical decisions across tooling, infrastructure, data design, scalability, and operational efficiency
• Implement and maintain infrastructure-as-code, CI/CD pipelines, and automated deployment practices across the data platform
• Enable high-quality, accessible, and governed data products through scalable semantic layers, curated datasets, and transformation standards
• Provide hands-on technical leadership, mentoring, and architectural direction for a growing team of data engineers and cross-functional stakeholders

Skills

Data engineering

AWS

Python

SQL

Airflow

Terraform

AWS CDK

Snowflake

Redshift

Databricks

Tools

dbt

Kafka

Kinesis

Job description

Coates Group seeks a Data Platform Engineer in Chicago to lead the evolution of our enterprise AWS data platform and enable analytics, BI, and future AI capabilities. You will design scalable pipelines and governance while guiding a growing team of data engineers.

You will split time between in-office collaboration in the West Loop (3 days) and remote work (2 days), contributing to a fast-paced global tech environment.