Remote Data Engineer — AWS ETL & Medallion Lakehouse

Wintrio LLC; Washington (District of Columbia); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Healthcare (Medical, Dental, Vision)

FSA/HSA benefits

401(k) and retirement plan

Bonus and profit sharing

PTO and vacation

EAP

Job summary

WINTrio LLC is seeking an experienced Data Engineer (ETL Developer) to design, build, and optimize AWS native data pipelines for a federal data management program. This role will ingest and transform 30+ high priority datasets into an enterprise data platform built around a Medallion (Bronze, Silver, Gold) architecture.

The ideal candidate has strong hands on experience with AWS data services and a track record of delivering well documented, production grade pipelines.

Qualifications

• 3 to 7+ years designing and maintaining AWS based data pipelines.
• Experience with serverless, event driven ETL/ELT workflows and Medallion/Lakehouse designs.
• Proficiency in Python, SQL, PySpark, Pandas, or similar data processing frameworks.
• Experience with data validation tools (Great Expectations) and data catalogs (AWS Glue, Lake Formation).
• Experience CI/CD and infrastructure as code (Terraform).
• Experience designing relational schemas, star/snowflake models, indexes, and partition strategies.
• Experience in federal or regulated environments with stakeholders and CORs.

Responsibilities

• Design, build, test, and deploy ETL pipelines for priority datasets on AWS.
• Develop data models, schemas, validation frameworks, and dictionaries; enhance data models for analytics.
• Implement scalable data validation and lineage capture; ensure quality checks and error handling.
• Produce ERDs, data dictionaries, and pipeline specifications; document thoroughly.
• Collaborate with agency stakeholders to prioritize datasets and deployment options.
• Support testing across development, staging, and production environments.
• Meet performance targets including 97%+ pipeline success and 15–45 minute SLA windows.

Tools

AWS Glue

AWS Lambda

AWS Step Functions

AWS S3

Lake Formation

Python

SQL

PySpark

Pandas

Great Expectations

Terraform

CI/CD

Job description

WINTrio LLC is seeking an experienced Data Engineer (ETL Developer) to design, build, and optimize AWS native data pipelines for a federal data management program. This role will ingest and transform 30+ high priority datasets into an enterprise data platform built around a Medallion (Bronze, Silver, Gold) architecture.

The ideal candidate has strong hands on experience with AWS data services and a track record of delivering well documented, production grade pipelines.