Position Title: Data Architect
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.comTo apply, please submit your resume to careers@wintrio.com or complete the application form below.
Job Summary:
WINTrio LLC is seeking an experienced Data Architect to support the design, review, optimization, and evolution of a federal agency's enterprise data environment. This role defines data standards and models, advises on Medallion Lakehouse architecture, and supports modernization efforts across the organization's AWS based data platform.
Key Responsibilities:
Define data standards and models for the enterprise data environment.
Advise on Medallion (Bronze, Silver, Gold) Lakehouse architecture.
Review pipeline designs for alignment with enterprise data standards and governance expectations.
Oversee metadata and lineage integration across the data platform.
Support modernization efforts, including OpenMetadata integration, RDS evaluation, and observability frameworks.
Maintain updated data architecture diagrams and documentation as pipelines and modernization efforts evolve.
Develop to be and transition plans for architecture changes as directed.
Ensure recommended patterns reflect best practices for AWS based Medallion/Lakehouse designs, interoperability, and modernization goals.
Required Qualifications:- Experience designing and maintaining AWS based data pipelines and Medallion/Lakehouse architectures.
- Experience with metadata and lineage tooling, including cataloging frameworks such as OpenMetadata.
- Experience evaluating and recommending managed data stores, such as AWS RDS.Experience producing architecture documentation, including diagrams, transition plans, and data flow descriptions.
- Familiarity with federal security, privacy, and auditability requirements as they apply to data architecture.
- 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 & ToolsData Architecture: Medallion/Lakehouse design, data standards and modelingAWS Cloud Services: RDS, Glue, S3, and related data services
- Metadata & Lineage: OpenMetadata or comparable cataloging and lineage tools
- Observability Frameworks for pipeline and data platform monitoring
- Documentation: architecture diagrams, transition plans, data flow documentation
- Recommended Certifications (not mandatory): AWS Certified Solutions Architect (Associate or Professional)
- Work Environment
- Full time or part time position, based on contract activation.
- 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 PlanAnnual 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 federal data architecture leadership, enterprise modernization strategy, and IT governance. 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 EmployerWINTrio 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.
