Location: North York, Ontario (3-4x week)
Duration: 6 months+ ext
About the Opportunity
Are you a hands-on Data Engineer who enjoys solving complex data challenges and building reliable solutions? An organization undergoing a major data modernization initiative is looking for someone to help transform and migrate enterprise data while supporting the development of a modern Microsoft Fabric environment.
You’ll work alongside Data Leads, Architects, Business Analysts, technical teams, and System Integrators to move data from legacy and enterprise systems into modern cloud platforms. This is an opportunity to contribute to meaningful data transformation work where data quality, accuracy, and reliable delivery are key to the success of the project.
What’s In It for You
- Work on a large-scale data modernization initiative with exposure to modern Microsoft data technologies.
- Gain hands-on experience across data migration, integration, transformation, and analytics.
- Collaborate with experienced technical and business teams in a highly cross-functional environment.
- Contribute to solutions that improve how enterprise data is structured, governed, and used.
Your Responsibilities
- You’ll design, develop, and support scalable data pipelines for enterprise data integration and migration.
- You’ll use scripting and SQL to extract, transform, validate, and reconcile data from multiple sources.
- You’ll develop and support data solutions within the Microsoft Fabric ecosystem, including modern cloud-based data platforms.
- You’ll perform data mapping, transformation, cleansing, and schema alignment across legacy and modern data environments.
- You’ll implement data quality, reconciliation, monitoring, and validation processes to maintain data integrity.
- You’ll collaborate with technical and business stakeholders to document requirements, migration processes, technical solutions, and operational procedures.
Skills and Qualifications
- 5+ years of hands-on data engineering experience, with strong data engineering and data management fundamentals.
- Hands-on scripting experience with SQL/T-SQL, Python, PySpark, or similar technologies, along with practical data migration development experience.
- Hands-on Microsoft Fabric experience, with an understanding of Lakehouse, Warehouse, OneLake, Fabric Data Factory, or related Fabric capabilities.
- Strong experience developing ETL/ELT pipelines and integrating, transforming, and migrating data across enterprise systems.
- Experience with data modelling, data warehousing, data quality, governance, reconciliation, and large-scale datasets.
- Experience with Azure data services, particularly Azure Data Factory, with exposure to Dataverse, Dynamics 365, SSIS, SSAS, or Dataiku considered an asset.
- Strong communication, problem-solving, attention to detail, and ability to work effectively with technical and business stakeholders.
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.
