Sign upLog in

ETL Developer

Shiftcode Analytics, Inc

Washington, DC

Apply
JOB DETAILS
SKILLS
Analysis Skills, Budget Management, Business Architecture, Business Intelligence, Business Process Management, Cloud Computing, Communication Skills, Computer Science, Data Import/Export, Data Migration, Data Mining, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Enterprise Applications, Finance, Information Technology & Information Systems, Internet Application, Management of Information Systems/Technology (MIS), Microsoft Excel, Microsoft PowerPoint, Microsoft Visio, Microsoft Word, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Product Requirements Document (PRD), Project Planning, Software Administration, Software Development, Team Player, Testing, Time Management, Web Programming, Writing Skills
LOCATION
Washington, DC
POSTED
30+ days ago
Title ETL Report Developer
Role Hybrid (Washington DC Candidates must be Local to the DMV area)
Visa Open to USC, GC
Interview Virtual (However, client may switch to in-person at their discretion.)
Domain Transportation
Close Date: 03/16/2026

Responsibilities
Seeking 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.

Responsibilities:
  • 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.

Qualifications
Required Skills:
  • 5 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 applications
  • 5 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.

Additional Requirements:
  • 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.

About the Company

S

Shiftcode Analytics, Inc

Resume Resources

Free Resume TemplatesFree Resume Builder