Job Role: MS Fabric Data Engineer
Location: Toronto, ON
Position Type: Contract
2-3 Days in a week Onsite
Overview: Job Summary
We are seeking a skilled Data Engineer to support our transition from legacy databases to a modern, cloud-native ecosystem. In this role, you will focus on the technical execution of our migration strategy, moving critical business data from legacy systems into Microsoft Dynamics 365 and its Dataverse backend.
In addition to cloud development, you will leverage your hands-on experience with on-premises SQL Server tools (SSIS and SSAS) to extract legacy data and manage existing models. You will play a key role in setting up our future analytics landscape - building reliable ETL/ELT pipelines and utilizing Dataiku alongside OneLake and Microsoft Fabric to ensure migrated data is structured, optimized, and readily available for our analytical teams to build high-impact dashboards and reports.
Required Skills & Qualifications
- Experience: 5+ years of hands-on data engineering experience, with a strong focus on data migration and ETL/ELT pipeline development.
- Legacy Microsoft Stack: Hands-on experience developing, deploying, and troubleshooting SQL Server Integration Services (SSIS) packages and querying/managing SQL Server Analysis Services (SSAS) models.
- Cloud & Pipeline Tooling: Strong proficiency in Azure Data Factory (ADF), SQL (T-SQL), and knowledge on workflows and preparation recipes in Dataiku.
- Target Ecosystem: Good working knowledge of Microsoft Dynamics 365 (D365) data structures, Dataverse, or the broader Power Platform ecosystem.
- Modern Analytics Exposure: Experience with Microsoft Fabric and OneLake concepts for staging, transforming, and serving analytical data.
- Data Handling: Experience working with legacy data formats - profiling, mapping, and transforming structured and semi-structured data (CSV, JSON, XML).
Preferred Qualifications
- D365 Migration Tools: Experience utilizing the D365 Data Management Framework (DMF) or staging tables for migrations.
- Reporting Familiarity: Basic understanding of data modeling concepts (e.g., Star Schema) optimized for analytical tools like Power BI.
- Team Integration: Experience working within project teams alongside System Integrators (SIs) on structured enterprise transformation programs.
- Regulated Industries: Prior experience working in financial services, banking, insurance, or other regulated environments.
Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.