Position Description:
We are seeking an experienced Data Engineering consultant to support enterprise data initiatives with a strong focus on data migration, pipeline development, and data platform optimization. This role plays a critical part in ensuring the accuracy, integrity, and accessibility of data across systems. The ideal candidate will combine strong technical expertise with the ability to collaborate across functional teams to deliver scalable, reliable data solutions that support business operations and decision-making.
Key Responsibilities:
The successful candidate's responsibilities will include:
. Lead and support data migration activities, including extraction, cleansing, mapping, transformation, validation, and reconciliation.
. Collaborate with functional teams to align migration logic with business and system requirements.
. Develop and optimize SQL, PL/SQL, and T-SQL code to support enterprise data workflows across Oracle and SQL Server.
. Build data pipelines, monitor them, and troubleshoot operational or data issues.
. Review existing operations data, research open issues, and collaborate with engineering and operations teams on new and ongoing projects.
. Design tools and infrastructure to analyze large volumes of data.
. Assist the team with troubleshooting, root cause analysis, and thorough defect resolution.
. Ensure the accuracy, integrity, and security of data within the organization.
Qualifications:
The ideal candidate for this position will have:
. Degree or Diploma in Computer Science, Information Systems, or related field.
. 5+ years of experience as a Data Engineer or similar role.
. Proficiency in Python, PySpark, data modeling, ETL/ELT processes, and data integration using Microsoft technologies.
. Strong SQL experience with Oracle and SQL Server, including query tuning and analysis.
. Advanced SQL skills for data transformation and querying on Azure data services (e.g., Data Factory, Databricks, Synapse, Fabric, Purview).
. Experience with Power BI or other BI tools.
. Familiarity with DevOps practices, including CI/CD.
. Strong understanding of data pipeline engineering and big data design principles.
. Experience with database, data warehouse, or data lake solutions.
. Exceptional communication skills with the ability to translate technical concepts for diverse stakeholders.
Use of the term ‘engineering’ in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions, but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.
Skills:
- Azure Data Lake
- Azure Service Fabric
- Data Warehousing
- ETL
- Python
- SQL
- Transact-SQL