WMATA Data Design Developer

Database Architect 3 (Data Design Developer) to design and implement data architecture and schemas and support enterprise data integrations for the MetroAlerts notification platform on Microsoft Azure and Power Platform.

Long Description

WMATA is seeking staff augmentation resources for software development tasks that span the full operational scope of Metro. These contract positions support the development of applications in Microsoft Power Platform and Microsoft Azure, focused on process improvement for mission-critical processes, including public-facing service applications.

The engagement seeks professionals with demonstrated experience in the design, deployment, enhancement, and support of highly available, mission-critical applications serving public-facing and internal business functions, primarily on Microsoft Azure and Power Platform. Candidates must have expertise in the tools, governance frameworks, security practices, and delivery methodologies commonly employed by large enterprises to develop, integrate, and maintain complex business applications.

The initial scope includes enhancement, optimization, and enterprise integration of a public-facing notification platform that requires additional integration with key enterprise systems. Services may include data architecture and design, application development to support new business processes, refinement and automation of existing processes, enterprise system integrations, UX/UI improvements, accessibility enhancements, quality assurance, performance optimization, and scalable solutions that improve operational efficiency and customer engagement.

Duties and Responsibilities

• The Data Design Developer needs to be proficient in the WMATA Data Platforms in use and needs to make themselves familiar with applications and their data structures/schemas.
• The Data Design Developer needs to be able to understand business needs and be able to advise on how to append to an existing solution as well as how to design new structures/schemas.
• The Data Design Developer needs to be able to implement an entire data architecture supporting, as well as adapt an existing architecture, for deployment in production applications.
• There is a clear expectation for team collaboration and the use of the Agile methodology.

Education

Bachelor's degree in a relevant field and/or a combination of education/certification and experience that provides an equivalent level of competency.

Skill

Required / Desired

Amount

of Experience

Data platforms

relational (SQL) and NoSQL database design, document modeling and denormalized data structures,

Required

5

Years

Data platforms

Azure SQL Database/SQL mngd instance, Azure Blob Storage & Cosmos DB for MongoDB, and BI reporting data layer.

Required

5

Years

Transit data

exp w GTFS & enhanced GTFS/GTFS-RT modeling; complementary Metro-specific data models; stop/route/network data alignment.

Required

5

Years

Engineering

.NET Core or Node.js on Azure; data pipelines, ingestion/transformation, and data quality/governance.

Required

5

Years

Integration

data-driven, cross-platform API models; data mapping for Adobe/AEM, CRM, and downstream feeds.

Required

5

Years

Reporting

data structures supporting operational dashboards, analytics, archive/search, and audit logging.

Required

5

Years

Bachelor's degree in a relevant field and/or a combination of education/certification and experience that provides an equivalent level of competency.

Required

Master's degree in computer science or a related field or equivalent experience

Desired

PeopleSoft certified.

Desired

Experience in working with third-party systems.

Desired

8

Years

Experience in cloud-based PeopleSoft deployments.

Desired

6

Years

Must qualify for a Level 3 WMATA ITCL Category.

Required

8

Years