ETL Report Developer

Posted March 12, 2026

Job Description

Company Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Position: ETL Report Developer (797686)

Location : Alexandria Va (Hybrid)

The client is seeking resources to build, test and deploy components of system to support the Open Payment 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 the 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 shall support full-fare and senior customers and enable tapand-pay using contactless bank cards for Metro rail, bus, and parking services, as well as participating regional partner systems. The solution must accept domestically and internationally issued contactless bank cards.

client is looking for a total of 2 resources for supporting Open Payment Project.

This resource will be responsible for

Design, automate and support sophisticated applications for data extraction, transformation, and loading.
Ensures the accuracy of data.
Creates logical and physical data flow models for ETL applications.

Responsibilities

Data warehousing, Data modeling, Data integration, DataMigration, ETL process and Business Intelligence.
Data Modeling design, analysis, and implementation -conceptual, logical, and physical data modeling, Data conversion, Dataintegration and Data Mining specialization in the area of Data Warehouse andBusiness Intelligence.
Data import from Vendor cloud.
Proactively solve problems to ensure milestones are metand projects are completed on time and within budget.
Exceptional application architecture, and softwaredevelopment 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.
Successfully complete mandatory WMATA security awareness training on annual basis.
Review and assist with system hardening and vulnerability remediation.