ETL Developer

ETL Report DeveloperRole - Hybrid (Washington DC – Candidates must be local to the DMV area)Visa - Open to USC, GCInterview - Virtual (However, client may switch to in-person at their discretion.)Domain - TransportationClose Date: 03/16/2026ResponsibilitiesSeeking a full-time ETL Report Developer to build, test, and deploy components of the system to support the project. Planning, design, and implementation work for Open Payment was awarded to a separate implementation vendor. The Offeror for this task order will be provided with extensive information around requirements, architecture, and design to use in developing components required to support the Open Payment project. The Open Payment Solution shall enable Metro customers to pay fares using their own contactless open payment media, without requiring a SmarTrip card or any other closed-loop card. The solution should support full-fare and senior customers and enable tap and-pay using contactless bank cards for Metro rail, bus, and parking services, as well as participating in regional partner systems. The solution must accept domestically and internationally issued contactless bank cards.Design, automate and support sophisticated applications for data extraction, transformation, and loading.Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.Data Modeling design, analysis, and implementation -conceptual, logical, and physical data modeling, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence. Data import from Vendor cloud.Ensures the accuracy of data.Creates logical and physical data flow models for ETL applications.Qualifications5 years Exceptional application architecture, and software development skills.5 years Experience using Microsoft (MS) Visio or other data or application visualization software to document application architecture.5 years Experience using MS Excel to perform basic software requirements documentation.5 years of Understanding and work experience with the reporting of data within enterprise applications5 years Familiarity with MS Word and MS PowerPoint.5 years Experience coordinating software requirements and working with development teams.5 years Proven ability to plan and deploy complex custom Web application programs and process improvements.5 years Experience performing the application Architecture function, from conception to deployment.5 years Experience using Visio and Moqups to document the relationship of application architectures.Bachelor's degree in Business, Computer Science, Communications, Finance, or in related discipline, or equivalent experience.Proactively solve problems to ensure milestones are met and projects are completed on time and within budget.Exceptional application architecture, and software development skills.Strong analytical, verbal communication, and written communication skills.Experience using Microsoft (MS) Visio or other data or application visualization software to document application architecture.Experience coordinating software requirements and working with development teams.Proven ability to plan and deploy complex custom application programs and process improvements.Experience performing the application Architecture function, from conception to deployment.Experience with administration and architecture of Business Process Management; and Experience using Visio and Moqups to document the relationship of application architectures.Review and assist with system hardening and vulnerability remediation.Bachelor's degree in computer science, Information Technology, Management Information Systems, or in a related discipline.