Data Engineer

Chicago, IL - USA

Monthly Salary: Not Disclosed

Posted on: 4 hours ago

Vacancies: 1 Vacancy

Job Summary

Data Engineer AWS (Data Lake Redshift Aurora Integration)
Location: Chicago IL Hybrid - 2 3 days onsite per week

About the Role
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.

Key Responsibilities
Data Engineering & Architecture
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.

Security Governance & Compliance
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.

Required Skills & Qualifications
7 years of experience in data engineering and AWS data architecture.
Strong expertise with AWS Glue Redshift S3 Lake Formation Aurora (Postgres/MySQL).
Proven experience building APIs or exposing curated datasets for web applications (preferably React or similar front-end frameworks).
Strong programming skills in Python and SQL.
Experience with data modeling ETL/ELT frameworks and performance optimization.
Working knowledge of Terraform/CloudFormation and CI/CD practices.
Understanding of data security IAM policies encryption and governance frameworks.

Preferred Skills
Experience with Athena for ad-hoc analytics.
Familiarity with API Gateway AppSync or GraphQL APIs for serving data to front-end applications.
Knowledge of event-driven pipelines (Kinesis EventBridge) and data quality monitoring.

Dont worry about failures worry about the chances you miss when you dont even try.

Cheers

Lipika Mohanty (LIZA)

Direct: / EXTN 1031

w: e:

440 Benigno Blvd Unit#A 2nd Floor. Bellmawr NJ 08031

Interstate Business Park

Exceeding customer expectations.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex pregnancy sexual orientation gender identity national origin age protected veteran status or disability status.

Data Engineer AWS (Data Lake Redshift Aurora Integration) Location: Chicago IL Hybrid - 2 3 days onsite per week About the Role 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 ma...

Data Engineer AWS (Data Lake Redshift Aurora Integration)
Location: Chicago IL Hybrid - 2 3 days onsite per week