Job Description

Contract: 6 months to start

Location: Hybrid (3 days/week on-site in Markham)

We are seeking a highly motivated and versatile Data Engineer to play a critical role in supporting our client's journey towards a new master customer data centre and the development of a robust new data model. This hybrid role requires a strong analytical mindset with practical data engineering skills. Initially, the focus will be heavily on data analysis, cleansing existing system data, and developing scripts to produce high-quality, clean data. Leveraging your automation background, you will not only clean the data but also establish repeatable processes and best practices to prevent the introduction of bad data in the future. This position demands strong SQL querying and ETL skills, coupled with excellent communication abilities to effectively collaborate with business stakeholders.

Responsibilities:

• Data Analysis & Cleansing:
• Conduct in-depth analysis of existing customer data systems to identify data quality issues, inconsistencies, and anomalies.
• Develop and execute data cleansing strategies and techniques to improve data accuracy, completeness, and consistency.
• Write complex SQL queries to extract, transform, and analyze large datasets.
• Profile and understand data sources, data relationships, and data flows.
• Data Engineering & Automation:
• Design, develop, and implement ETL (Extract, Transform, Load) processes to move and transform data between systems.
• Develop scripts (e.g., Python, SQL) to automate data cleansing, validation, and transformation processes.
• Contribute to the design and implementation of data quality frameworks and monitoring systems.
• Provide best practices and recommendations for data governance and data entry processes to prevent future data quality issues.
• Data Modelling Support:
• Collaborate with data architects and other stakeholders in the design and development of the new customer data model.
• Provide data insights and analysis to inform data model decisions and ensure alignment with business requirements.
• Assist in data mapping and data migration activities related to the new data centre.
• Stakeholder Communication & Collaboration:
• Effectively communicate findings, insights, and recommendations to both technical and non-technical stakeholders.
• Collaborate closely with business users to understand their data needs and challenges.
• Participate in meetings and presentations to provide updates on data analysis and cleansing progress.
• Document data analysis processes, data flows, and data quality rules.

 Qualifications:

• Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, or a related field.
• Minimum of 8 years of experience in a Data Analyst or Data Engineer role with a strong focus on data quality.
• Demonstrated expertise in writing complex SQL queries for data extraction, manipulation, and analysis across various database systems.
• Proven experience in designing, developing, and implementing ETL processes using relevant tools and technologies.
• Strong scripting skills in languages such as Python for data manipulation, automation, and analysis.
• Solid understanding of data warehousing concepts, data modelling principles, and database design.
• Experience with data quality tools and methodologies.
• Excellent analytical and problem-solving skills with a keen attention to detail.
• Strong communication (both written and verbal) and interpersonal skills with the ability to effectively communicate technical concepts to non-technical audiences.
• Ability to work independently and collaboratively within a team environment.  
• Experience working in a hybrid work environment and being effective both remotely and on-site.

• Experience with master data management (MDM) concepts and tools.
• Previous experience supporting the implementation of a new data model or data warehouse.