Data Engineer

Data Engineer
Location: North York ON
Duration: 6 Month contract + extension
Background Check Requirement: To be confirmed

About the Opportunity
Are you a hands-on Data Engineer who enjoys transforming complex data environments into modern, scalable solutions? An organization undergoing a major digital transformation is looking for an experienced professional to help migrate critical business data from legacy systems into Microsoft Dynamics 365 and Dataverse.
Working alongside data leaders, technical specialists, and business stakeholders, you'll play an important role in building reliable data pipelines, strengthening data quality, and enabling meaningful business insights through modern analytics platforms.

What's In It for You
• Contribute to a large-scale enterprise data modernization initiative.
• Gain exposure to Microsoft Fabric, OneLake, Dataiku, and cloud-native technologies.
• Collaborate with experienced technical teams in an environment that values knowledge sharing and problem-solving.
• Make a tangible impact on data accessibility, reporting, and business decision-making.
Your Responsibilities
• You'll develop and execute data migration processes from legacy databases and SSAS models into Dynamics 365 and Dataverse.
• You'll build, test, and maintain ETL/ELT pipelines using Azure Data Factory, SSIS, and Dataiku.
• You'll support data transformation, schema mapping, and master data management (MDM) activities.
• You'll prepare clean, reporting-ready datasets within Microsoft Fabric and OneLake.
• You'll perform data cleansing, validation, and reconciliation across migration cycles.
• You'll document transformation logic, extraction processes, and pipeline schedules while collaborating with system integrators and stakeholders.

Skills and Qualifications
• 5+ years of hands-on data engineering experience, particularly in data migration and ETL/ELT development.
• Strong proficiency in SQL (T-SQL), Azure Data Factory, SSIS, and SSAS, including troubleshooting and managing existing models.
• Experience with Dataiku workflows and preparation recipes, plus knowledge of Dynamics 365, Dataverse, or Power Platform.
• Familiarity with Microsoft Fabric, OneLake, and structured or semi-structured data formats, including CSV, JSON, and XML.
• Exposure to MDM, with experience in D365 Data Management Framework (DMF) or staging tables considered an asset.
• Understanding of Star Schema, Power BI data modelling, and enterprise transformation projects involving system integrators.
• Strong communication, adaptability, and attention to detail. Experience in financial services, banking, insurance, or regulated environments is an asset.

Why Partner with Altis
If you’ve never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if you’re a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching and connecting you directly with the hiring manager. And rest assured, all our services are free of cost for candidates.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.