Data Engineer

WE NEED W2 ONLY MUST AND SHOULD WORK ON W2 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. [Upgrade to PRO to see contact] 6306350518