Job Title: Data Engineer (Senior Platform Developer)
Location: Remote
Agency: Department of Children and Family Services (DCFS)
Project Name: Legacy Application System and Data Management Support Services
Duration: 4,000 Hours
Project Overview
The Illinois Connect Modernization Program is a multi-agency initiative aimed at transforming legacy case management systems into scalable, cloud-based architectures. As a Senior Data Platform Developer, you will lead the analysis, conversion, and integration of operational data, ensuring integrity and continuity during the transition from legacy systems to modernized platforms.
Key Responsibilities
Data Engineering & Analytics Platform Development
Pipeline Management: Design, build, and maintain enterprise-scale data pipelines utilizing Azure Data Factory (ADF).
Warehouse Optimization: Develop and optimize Azure SQL-based data warehouses and data marts.
BI Architecture: Architect Power BI semantic models using DAX, Power Query (M), and dimensional modeling (star schema).
Performance: Ensure all pipelines are efficient, secure, and meet high-performance standards.
Legacy System Modernization & Data Transformation
Data Profiling: Lead legacy system analysis, profiling, cleansing, and complex transformation activities.
Strategy Execution: Develop and execute migration strategies for operational and case management systems.
Synchronization: Coordinate data bridging efforts to support phased implementation across new platforms.
Quality Assurance: Provide hands-on leadership to ensure data integrity and alignment with modernized systems.
Leadership, Collaboration & Governance
Mentorship: Lead a team of developers and analysts in data integration best practices.
Project Oversight: Oversee resource planning, task allocation, and status reporting for conversion activities.
Cross-Functional Alignment: Collaborate with business users, system integrators, architects, and data scientists.
Innovation: Evaluate and enhance existing data architecture to drive scalability.
Required Skills and Experience
Experience: 8+ years in Data Warehouse/Data Mart environments, focusing on cloud solutions.
Azure Stack: Advanced expertise in Azure Data Factory (ADF) and Azure SQL Server.
Power BI: Proven ability to deliver enterprise-grade semantic models and advanced DAX.
Migration: Demonstrated experience in legacy data migration (mapping, cleansing, and execution).
Data Modeling: Proficiency in SQL and modeling methodologies (Kimball, Inmon, Boyce-Codd).
Soft Skills: Strong problem-solving, debugging, and the ability to lead cross-functional teams.
Preferred Qualifications
DevOps: Experience implementing CI/CD pipelines and infrastructure-as-code for data engineering.
Cutovers: Experience supporting phased data bridging and live system cutovers.
Data Management: Knowledge of data cataloging, metadata management, and data lineage tools.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10236892
- Position Id: OOJ - 4919-3920-1778517167
- Posted 1 day ago
Never miss an opportunity! Create an alert based on the job you applied for.
