Position Title: Data Engineer (ETL Developer)
Location: Remote (Washington, DC metro area preferred); place of performance is 395 E Street SW, Washington, DC
Client: U.S. Department of Transportation, Surface Transportation Board (STB)
Work Authorization: Must be eligible for a Moderate Risk (MBI level) background investigation prior to accessing STB systems
Application Email: careers@wintrio.com
To apply, please submit your resume to careers@wintrio.com or complete the application form below.
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.
Key Responsibilities
- Design, build, test, and deploy ETL pipelines for priority datasets using AWS native services or approved third party tools hosted on AWS.
- Develop supporting data models, schemas, validation frameworks, and database structures, and enhance data models to support expanded analytics and reporting.
- Implement scalable data validation and quality checks, including error handling and lineage capture.
- Produce complete technical documentation, including ERDs, data dictionaries, and pipeline specifications.
- Collaborate with agency stakeholders to prioritize datasets, define sequencing, and identify phased deployment options.
- Support thorough testing across development, staging, and production environments.
- Support optional surge development capacity when activated, including accelerating backlog ingestion and parallel development tracks.
- Meet performance standards including a 97%+ monthly pipeline success rate, SLA windows of 15 to 45 minutes (2 to 4 hours for large regulatory datasets), curated layer data freshness within 4 to 24 hours, and a 98%+ data validation pass rate.
Required Qualifications
- 3 to 7+ years designing and maintaining AWS based data pipelines, including Glue, Lambda, Step Functions, and S3.
- Experience building 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 (such as Great Expectations), data catalogs (AWS Glue, Lake Formation), CI/CD, and infrastructure as code (Terraform).
- Experience designing relational schemas, star/snowflake models, indexes, and partition strategies.
- Experience working in a federal or regulated environment with stakeholders, CORs, and structured deliverables.
- Must be eligible for a Moderate Risk (MBI) background investigation.
Technical Skills & Tools
- AWS Cloud Services: Glue, Lambda, Step Functions, S3, Lake Formation
- Programming & Data Processing: Python, SQL, PySpark, Pandas
- Data Quality: Great Expectations or similar validation frameworks
- DevOps & Infrastructure as Code: CI/CD pipelines, Terraform
- Documentation: ERDs, data dictionaries, pipeline specifications, lineage diagrams
- Recommended Certifications (not mandatory): AWS Certified Data Engineer Associate, AWS Certified Developer Associate
Work Environment
- Full time position.
- Remote eligible; contractor services may be performed remotely per the contract’s terms.
- Standard business hours Monday through Friday.
- No travel required.
WINTrio Benefits
- Healthcare (Medical, Dental, and Vision)
- Flexible Spending Account (FSA) and Health Savings Account (HSA)
- 401(k) and Retirement Savings Plan
- Annual Bonus and Profit Sharing Opportunities
- Paid Time Off (PTO) and Vacation
- Employee Assistance Program (EAP)
- Life, Personal, and Voluntary Disability Insurance
Growth Opportunities
There is ample opportunity to grow in multiple dimensions, including AWS data architecture, pipeline modernization, and federal program leadership. We are a completely employee driven company, and our continued success is built on the talent, dedication, and innovation of our team members.
Equal Opportunity Employer
WINTrio LLC is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
