[Remote] Data Engineer

Note: The job is a remote job and is open to candidates in USA. Krasan Consulting Services is seeking a Data Engineer to lead in the analysis, conversion, and integration of data. The role involves defining and implementing strategies for data migration and synchronization to ensure the integrity and continuity of mission-critical services during system transformation.

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 with DAX, Power Query (M), and dimensional modeling (star schema) best practices
• Ensure data pipelines are efficient, reliable, and meet performance and security standards
• Collaborate cross-functionally with business users, system integrators, architects, and data scientists
• Evaluate and enhance the existing data architecture, driving innovation and scalability

Skills

• 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, particularly within large and complex data ecosystems
• Proven ability to lead cross-functional teams and communicate effectively with both technical and non-technical stakeholders
• Exposure to DevOps practices for data operations and delivery
• Knowledge of data cataloging, metadata management, and data lineage tools
• Integration with Dynamics365

Company Overview

Krasan Consulting Services is a technology management consulting firm and solutions integrator. It was founded in 2019, and is headquartered in Chicago, Illinois, USA, with a workforce of 201-500 employees. Its website is https://krasanconsulting.com.

Company H1B Sponsorship

Krasan Consulting Services has a track record of offering H1B sponsorships, with 5 in 2026, 42 in 2025, 21 in 2024, 4 in 2023. Please note that this does not guarantee sponsorship for this specific role.