Senior Data Platform Developer

About This Role

This role involves designing, building, and maintaining enterprise-scale data pipelines and optimizing Azure SQL-based data warehouses for the migration of legacy case management systems. The engineer will lead data migration efforts, ensure data quality, and mentor other developers.

Responsibilities

• Design, build, and maintain enterprise-scale data pipelines using Azure Data Factory (ADF)
• Develop and optimize Azure SQL–based data warehouses, data marts, and complex transformation logic
• Architect and implement Power BI semantic models using DAX, Power Query (M), and dimensional modeling
• Ensure data pipelines meet performance, reliability, security, and compliance standards
• Lead legacy system analysis, data profiling, cleansing, and transformation activities
• Collaborate with stakeholders to define and document legacy and future-state data requirements
• Develop and execute data migration strategies for operational and case management systems
• Coordinate data synchronization and bridging efforts to support phased platform implementations
• Ensure data quality, integrity, and alignment with modernized systems
• Lead and mentor developers and analysts on data integration and transformation best practices

Requirements

• 8+ years of progressive experience in Data Warehouse/Data Mart environments, with a focus on cloud-based solutions
• Advanced expertise with Azure Data Factory (ADF) and Azure SQL Server
• Proven ability to deliver enterprise-grade Power BI semantic models, including advanced DAX and Power Query transformations
• Demonstrated experience in legacy data migration, including strategy definition, mapping, cleansing, and execution
• Proficient in SQL and experienced with data modeling methodologies (e.g., Kimball, Inmon, Boyce-Codd)
• Strong understanding of data governance, security, and compliance principles
• Excellent problem-solving, debugging, and analytical skills within large and complex data ecosystems
• Proven ability to lead cross-functional teams and communicate effectively with both technical and non-technical stakeholders

Qualifications

• 8+ years of progressive experience in Data Warehouse/Data Mart environments, focusing on cloud-based solutions

Nice to Have

• Experience implementing CI/CD pipelines and infrastructure-as-code in a data engineering context
• Exposure to DevOps practices for data operations and delivery
• Experience supporting phased data bridging and live system cutovers during system modernization efforts
• Knowledge of data cataloging, metadata management, and data lineage tools

Skills

* Required skills