Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
We are seeking an experienced Data Engineer to support a short-term, large-scale data migration. The role focuses on migrating legal case management data from a long-standing legacy SQL-based system into Microsoft Dataverse, enabling delivery of a new model-driven Power App. This migration involves terabyte-scale data volumes and requires careful planning and execution of both an initial full migration and a delta migration aligned to a defined go-live event.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Significant experience as a Data Engineer, with demonstrable delivery of cloud-based data pipelines (typically 6+ years).
Strong hands-on experience with:
Azure Data Factory
Azure Service Bus
Azure Data Lake
Azure SQL
Azure Key Vault
Solid understanding of ETL/ELT concepts, including data mapping, transformation logic, and error handling.
Proven ability to clearly document data flows, lineage, and transformation rules.
Experience working with legacy systems and delivering complex data migrations.
Knowledge of data privacy and protection requirements (e.g. FOIPOP), including implementation of controls around PII.
Strong communication skills, with the ability to work effectively with both technical and non-technical stakeholders.
Nice to Have Skills & Experience
Experience supporting public sector or government data programmes.
Experience working on large-scale or time-bound migration projects.
Familiarity with Power Platform and Dataverse migrations.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.