Data Engineer

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.

Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

Employment Type : Full Time

Experience : years

Vacancy : 1