

Ampstek
AWS Data Engineer (Only W2)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior AWS Data Engineer in Detroit, MI, with a contract length of "unknown" and a pay rate of "unknown." Requires 8+ years of experience in AWS, Azure Fabric, Datalake, data architecture, and end-to-end data engineering.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 18, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
Detroit, MI
-
🧠 - Skills detailed
#Data Migration #Azure #Datasets #AWS (Amazon Web Services) #Redshift #Data Ingestion #S3 (Amazon Simple Storage Service) #Cloud #Athena #Leadership #Dataflow #Data Modeling #"ETL (Extract #Transform #Load)" #Schema Design #Migration #AWS S3 (Amazon Simple Storage Service) #Lambda (AWS Lambda) #Data Architecture #Data Engineering #Data Pipeline
Role description
Job Title: Senior AWS Data Engineer
Work Location : Detroit, MI-Onsite
Minimum years of experience: 8+ years
Must Have Skills: AWS, Azure Fabric, Datalake
Detailed Job Description:
1. AWS Reverse Engineering & Subject Matter Expertise
• To Analyze and reverse engineering for Data models, dataflows,
• Identify source-to-target logic, transformations, joins, filters, and KPIs.
• Ensured 100% functional parity between Existing pipeline to new Fabric based solution.
1. AWS Data Architecture & Design
• Understand & reverse engineer data pipelines based upon AWS S3, Glue, Lambda, Athena, Redshift, etc. (based on project setup)
• Designed and documented the entire data flow and architecture of existing AWS based data pipelines to help migration
1. End-to-End Data Engineering
• Developed and automate the full data ingestion and transformation pipeline.
• Performed data modeling, schema design, and ETL/ELT implementation.
• Validated migrated datasets to match existing logic accurately.
1. Project Leadership & Coordination
• Served as the single point of contact (SPOC) for the entire AWS transformation track.
• Coordinated with product owners, business stakeholders, and technical teams.
1. Key Skills & Technologies
• data flows, data modelling.
• AWS Cloud – S3, Glue, Lambda, Athena, Redshift (or project-specific AWS tools)
• Data Engineering & ETL
• Data Migration & Transformation
• Solution Architecture
• Stakeholder Management & Communication
jericho@ampstek.com
Job Title: Senior AWS Data Engineer
Work Location : Detroit, MI-Onsite
Minimum years of experience: 8+ years
Must Have Skills: AWS, Azure Fabric, Datalake
Detailed Job Description:
1. AWS Reverse Engineering & Subject Matter Expertise
• To Analyze and reverse engineering for Data models, dataflows,
• Identify source-to-target logic, transformations, joins, filters, and KPIs.
• Ensured 100% functional parity between Existing pipeline to new Fabric based solution.
1. AWS Data Architecture & Design
• Understand & reverse engineer data pipelines based upon AWS S3, Glue, Lambda, Athena, Redshift, etc. (based on project setup)
• Designed and documented the entire data flow and architecture of existing AWS based data pipelines to help migration
1. End-to-End Data Engineering
• Developed and automate the full data ingestion and transformation pipeline.
• Performed data modeling, schema design, and ETL/ELT implementation.
• Validated migrated datasets to match existing logic accurately.
1. Project Leadership & Coordination
• Served as the single point of contact (SPOC) for the entire AWS transformation track.
• Coordinated with product owners, business stakeholders, and technical teams.
1. Key Skills & Technologies
• data flows, data modelling.
• AWS Cloud – S3, Glue, Lambda, Athena, Redshift (or project-specific AWS tools)
• Data Engineering & ETL
• Data Migration & Transformation
• Solution Architecture
• Stakeholder Management & Communication
jericho@ampstek.com






