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