Data Design Developer

Data Design Developer

Alexandria, VA (Hybrid - 2-3 days onsite a week) - local only

Must-Have Skills:

• Azure SQL, Cosmos DB, and SQL/NoSQL database design
• Data modeling, schema design, and Azure data architecture
• .NET Core or Node.js, API development, and data integration

Seeding 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 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.

Qualifications

• 5 years of experience designing and managing relational (SQL) and NoSQL databases, including document modeling and the development of denormalized data structures.
• 5 years of experience working with Azure SQL Database, Azure SQL Managed Instance, Azure Blob Storage, Azure Cosmos DB for MongoDB, and business intelligence (BI) reporting data layers.
• 5 years of experience developing applications using .NET Core or Node.js on Azure, including data pipeline development, data ingestion and transformation, and data quality and governance.
• 5 years of experience designing data-driven, cross-platform API models and developing data mappings and integrations for Adobe Experience Manager (AEM), customer relationship management (CRM) systems, and downstream data feeds.
• 5 years of experience designing and implementing data structures to support operational dashboards, analytics, data archiving and search capabilities, and audit logging.
• A bachelor's degree in computer science, information technology, engineering, or a related field, or an equivalent combination of education, certifications, and professional experience demonstrating the required competencies.

Desired Qualifications and Experience

• 5 years of experience with General Transit Feed Specification (GTFS), enhanced GTFS, and GTFS-Realtime (GTFS-RT) data modeling, including Metro-specific data models and the alignment of stop, route, and transit network data.
• A master's degree in computer science or a related field, or equivalent professional experience.
• PeopleSoft certification.
• 8 years of experience working with third-party systems, including integration, configuration, or data exchange.
• 6 years of experience supporting, implementing, or managing cloud-based PeopleSoft deployments.