AWS Lead Data Engineer - R01557641

Brillio • Chicago, IL

13d • $93,100 - $133,000

About The Position

We are seeking a Lead Data Engineer to design and implement scalable, secure, and high-performance data platforms on AWS . The role focuses on building data pipelines, managing data lakes and databases (Redshift, Lake Formation, Aurora), and exposing curated data for React-based dashboards and analytical applications.

Requirements

• 7+ years of experience in data engineering and AWS data architecture .
• Must have: Python, SQL/PLSQL, AWS, Postgresql, S3, Glue

Nice To Haves

• Good to have: CDK, GitHub

Responsibilities

• Design, build, and optimize data pipelines using AWS Glue , Lambda , and Step Functions for ingestion, transformation, and curation.
• Develop and maintain data lakes (S3 + Lake Formation) and data warehouses (Redshift) to support analytics and visualization.
• Integrate Aurora (PostgreSQL/MySQL) as a serving layer for APIs and dashboards.
• Design APIs or direct query interfaces that expose curated datasets for React-based dashboards and web applications .
• Define and implement data models , partitioning strategies, and schema evolution best practices for performance and scalability.
• Implement data security policies , encryption, and role-based access controls using AWS IAM , KMS , Lake Formation , and Secrets Manager .
• Ensure compliance with organizational data governance and privacy standards.
• Maintain data cataloging, lineage, and access tracking within AWS Glue Data Catalog and Lake Formation .
• Implement CI/CD pipelines for data workflows in collaboration with DevOps teams.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees