ETL Report Developer

WMATA ETL Report Developer Location: Alexandria, VA Hybrid

Description:

• WMATA is looking for a total of 2 resources for supporting Open Payment Project.
• Successfully delivers business intelligence (BI) information to the entire organization and experienced in Data Warehouse/BI development and implementations.
• The Washington Metropolitan Area Transit Authority (WMATA)is seeking resources to build, test and deploy components of system to support the WMATA 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 WMATA 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 tap and-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.

Responsibilities

• 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.
• 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.
• 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.
• Successfully complete mandatory WMATA security awareness training on annual basis.
• 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.

Required/Desired Skills