Role Title: Data Engineer(Senior Platform Developer)

Type of contract: W2

Location: Remote

Project: Legacy Application System and Data Management Support Services

Duration: 1 Year

Job Description

Project Overview:

The Connect Modernization Program is a large-scale multi-agency initiative focused on modernizing and transforming legacy applications and data systems to support the evolving needs of state agencies. As a Senior Data Platform Developer, you will play a pivotal role in enabling the transformation of legacy application case management systems and related data into modernized, scalable, and cloud-based architectures.

This position requires strong leadership in the analysis, conversion, and integration of application, system, and operational data. You will be responsible for defining and implementing strategies for data migration and synchronization that ensure the integrity and continuity of mission-critical services during system transformation.

Key Responsibilities:

Data Engineering & Analytics Platform Development

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 with DAX, Power Query (M), and dimensional modeling (star schema) best practices.
Ensure data pipelines are efficient, reliable, and meet performance and security standards.

Legacy System Modernization & Data Transformation

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 comprehensive data migration strategies and processes for operational and case management systems.
Coordinate data synchronization and bridging efforts to support phased implementation across new platforms.
Provide hands-on leadership to ensure data quality, integrity, and alignment to modernized systems.

Leadership, Collaboration & Governance

Lead and mentor a team of developers and analysts in best practices for data integration and transformation.
Oversee resource planning, task allocation, and status reporting for data conversion activities.
Collaborate cross-functionally with business users, system integrators, architects, and data scientists.
Evaluate and enhance the existing data architecture, driving innovation and scalability.

Required Skills and Experience:

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).
Familiarity with other cloud and big data platforms such as Databricks, Snowflake, AWS, or Google Cloud Platform.
Strong understanding of data governance, security, and compliance principles.
Excellent problem-solving, debugging, and analytical skills, particularly within large and complex data ecosystems.
Proven ability to lead cross-functional teams and communicate effectively with both technical and non-technical stakeholders.

Preferred Qualifications:

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.

Additional Skillset:

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

Senior Data Engineer (Google Cloud Platform BigQuery & Data Ingestion)

About this role