Data Design Developer
About The Position
NFF is seeking a Data Design Developer for a contract staff-augmentation engagement supporting software development across the operational scope of Metro. The work supports applications built with Microsoft Power Platform and Microsoft Azure, focused on improving mission-critical processes, including public-facing services. The initial scope includes enhancing and integrating a public-facing notification platform with enterprise systems. The role involves learning the WMATA data platforms and application schemas, translating business needs into data design recommendations, and implementing or adapting data architectures for production applications. Work may also include data architecture and design, application development, process automation, enterprise integrations, user experience and accessibility improvements, quality assurance, performance optimization, and scalable solutions. Collaboration and use of Agile methodology are expected.
Requirements
- At least 5 years of experience designing and managing relational (SQL) and NoSQL databases, including document modeling and denormalized data structures.
- At least 5 years of experience with Azure SQL Database, Azure SQL Managed Instance, Azure Blob Storage, Azure Cosmos DB for MongoDB, and business intelligence reporting data layers.
- At least 5 years of experience with GTFS, enhanced GTFS, and GTFS-Realtime data modeling, including Metro-specific models and alignment of stop, route, and transit network data.
- At least 5 years of experience developing applications using .NET Core or Node.js on Azure, including data pipelines, data ingestion and transformation, and data quality and governance.
- At least 5 years of experience designing data-driven, cross-platform API models and developing data mappings and integrations for Adobe Experience Manager, CRM systems, and downstream data feeds.
- At least 5 years of experience designing and implementing data structures for operational dashboards, analytics, data archiving and search, 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.
- Must meet the qualifications for a Level 3 WMATA Information Technology Contractor Level Category.
Nice To Haves
- A master's degree in computer science or a related field, or equivalent professional experience.
- PeopleSoft certification.
- At least 8 years of experience working with third-party systems, including integration, configuration, or data exchange.
- At least 6 years of experience supporting, implementing, or managing cloud-based PeopleSoft deployments.
Responsibilities
- Become proficient in the WMATA data platforms in use and learn the applications and their data structures and schemas.
- Understand business needs and advise on extending existing solutions or designing new data structures and schemas.
- Implement data architectures that support production applications and adapt existing architectures for production deployment.
- Collaborate with the team and use Agile methodology.
- Support enhancement, optimization, and enterprise integration of a public-facing notification platform.
Benefits
- Competitive salary
- Comprehensive benefits
- Flexible paid time off options for eligible employees
- Medical, dental, and vision coverage
- Health Savings Account
- Flexible Spending Account
- Short-term disability
- Long-term disability
- Supplemental life insurance and ADD&D
- Comprehensive 401(k) plan
- Paid time off
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Mid Level
