Job Summary
We are seeking a Data Design Developer to design, implement, and maintain data architectures, schemas, and enterprise integrations for a public-facing notification platform built on Microsoft Azure and Power Platform. The role involves curating data from source to target, integrating APIs, and ensuring transit alerts are packaged and routed to the appropriate applications for internal and public audiences. The ideal candidate will have experience with relational and NoSQL database design, Azure data services, business intelligence reporting layers, and GTFS and GTFS-RT data modeling. This is a full-time contract position with a hybrid work arrangement requiring 2 days onsite. Candidates may work from Hyattsville, MD; Washington, DC; or Alexandria, VA.
Key Responsibilities
• Design and implement data architectures and schemas supporting the notification platform.
• Support enterprise data integrations across Microsoft Azure and Power Platform environments.
• Develop proficiency in client data platforms and understand application data structures and schemas.
• Analyze business needs and recommend enhancements to existing solutions and designs for new data structures and schemas.
• Implement enterprise data architectures for production applications and adapt existing architectures as needed.
• Support enhancements, optimization, and enterprise integration of public-facing notification platforms.
• Participate in application development to support new business processes and operational improvements.
• Refine and automate existing business processes.
• Develop and support enterprise system integrations.
• Work with APIs and source-to-target data mappings to ensure alerts and related data are routed to the appropriate applications.
• Contribute to UX/UI improvements and accessibility enhancements.
• Support quality assurance, performance optimization, and scalable solution development.
• Support business intelligence reporting data layers, including solutions involving Power BI.
• Collaborate with cross-functional teams using Agile methodologies.
Required Qualifications
• Bachelor's degree in a relevant field, or an equivalent combination of education, certifications, and experience demonstrating the required competency.
• 8 years of experience in the field or a related area.
• 5 to 7 years of hands-on experience.
• Experience with GTFS and exposure to GTFS-RT modeling.
• Experience designing relational SQL and NoSQL databases.
• Experience with document modeling and denormalized data structures.
• Experience with Azure SQL Database and SQL Managed Instance.
• Experience with Azure Blob Storage.
• Experience with Azure Cosmos DB for MongoDB.
• Experience supporting business intelligence reporting data layers.
• Experience designing, deploying, enhancing, and supporting highly available, mission-critical applications.
• Knowledge of enterprise governance frameworks, security practices, and delivery methodologies.
Preferred Qualifications
• Experience with transit-specific data models and alignment of stops, routes, and network data.
• Experience with data-driven, cross-platform API models.
• Experience mapping data for Adobe Experience Manager (AEM), CRM systems, and downstream feeds.
• Experience with .NET Core or Node.js on Azure.
• Experience with data pipelines, ingestion, transformation, data quality, and governance.
• Experience designing data structures for operational dashboards, analytics, archiving, search functionality, and audit logging.
• Master's degree in Computer Science or a related field.
• PeopleSoft certification.
Physical Demands
• Ability to safely and successfully perform essential job functions in accordance with the Americans with Disabilities Act (ADA) and applicable federal, state, and local standards.
• Ability to perform sedentary work, including sitting or remaining stationary for most of the time, with occasional movement around the office to attend meetings.
• Ability to perform repetitive computer-based tasks using a mouse, keyboard, and monitor.
