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 |