Data Engineer (ETL Developer)

Data Engineer (ETL Developer) at Wintrio LLC

Wintrio LLC Data Engineer (ETL Developer) Remote

• Full time Company website Apply for Data Engineer (ETL Developer)

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.

About Wintrio LLC

WINTrio is an 8(a) and HUBZone organization with a successful record of delivering high-quality technical and professional services to federal and commercial customers including USCIS and Walmart. WINTrio manages and improves overall performance through IT Modernization practices. Our team of seasoned Cyber Security, Cloud/DevSecOps, software, and Support Experts helps your organization secure its digital environment with innovative and bleeding-edge technology solutions based on best practices and approved industry standards. We deliver a 360-degree spectrum of Systems Integration services from Inception to Project Delivery. At WINTrio we provide tailored customized services to meet all your business needs.

Description

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.

Apply online through the WINTrio Careers Portal

Job Posting

Data Engineer (ETL Developer) – WINTrio

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.

Salary

$10,000 - $300,000 per year

Apply for Data Engineer (ETL Developer)

Your Privacy Choices Read our Privacy Policy

By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.

Cookies settings Reject all Accept all

Privacy Preference Center

When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

Learn more information about your privacy

Allow all

Manage consent preferences

Strictly Necessary Cookies

Always active

These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.

Functional Cookies

Functional Cookies

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

Performance Cookies

Performance Cookies

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.

Targeting Cookies

Targeting Cookies

These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookie List

Clear checkbox label label

Apply Cancel

Consent Leg.Interest

checkbox label label

checkbox label label

checkbox label label

Reject all Confirm my choices