Data Engineer

Company Description Krasan Consulting Services is a Chicago boutique management consulting and technology solutions integrator. As a certified BEP WBE with the State of Illinois and a certified WBE, MBE, and DBE recognized by the City of Chicago, Krasan provides complex technology solutions and services for clients in the Public and Commercial sectors. With decades of experience, Krasan specializes in end-to-end technology solutions, integration, and implementation services and is proud to enable the success of our customers. Role Title: Data Engineer(Senior Platform Developer ) Type of contract: W2 Location: Remote Note: This is a W-2 employee position on our payroll. Unfortunately, 1099/C2C/C2H are not allowed at this time. Job Description: Project Overview: 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 GCP. • 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. • Knowledge of data cataloging, metadata management, and data lineage tools.