Educational background in Computer Science, Information Systems, Engineering, or related field preferred.
3-5+ years as a Database Administrator, Data Engineer, or in a similar role, focusing on large-scale data pipelines.
Strong knowledge of relational databases and SQL, especially Microsoft SQL Server.
Experience with data profiling, root cause analysis, and data quality metrics using BI tools like Power BI.
Proficient in automating data processes and building solutions using Python, PowerShell, or T-SQL, with Git version control knowledge.
Familiarity with AI tools for documentation and visualization, such as ChatGPT and Copilot.
Working knowledge of data governance practices and cloud storage solutions.
Responsibilities
Troubleshoot database and pipeline issues, performing data profiling and root cause analysis.
Design and implement data controls to ensure data integrity from source to target.
Lead triage meetings and collaborate with stakeholders on data issue resolution.
Maintain and develop the organization's data library and documentation for consistency and visibility.
Automate manual data tasks and build scalable data solutions, ensuring proper development/testing across environments.
Integrate databases with applications and analytics platforms in collaboration with teams.
Utilize analytical tools to develop metrics measuring data quality across source systems.
Benefits
Full-time, permanent position with potential for career growth.
Opportunities for training and collaboration with cross-functional teams.
Engagement with innovative AI tools to enhance workflows and data visualization.
Work in a professional environment promoting teamwork and process improvement.
Occasional travel to other locations may offer diverse experiences.
Full Job Description
🌟 We're Hiring!
We are currently looking to fill a full-time, permanent position for a Data Engineer in our information Technology Department at our Leamington office.
What You'll Do:
Troubleshoot database and pipeline issues, independently performing data profiling and root cause analysis - including review of Source-to-Target Mapping documents and data dictionaries.
Design, develop, and implement data controls to ensure data integrity from source to target, including verifying upstream data meets defined quality standards.
Lead triage meetings and collaborate with Business and Technology stakeholders to determine and implement fixes for identified data issues.
Maintain and continue developing the organization's data library and related process documentation to ensure consistency, traceability, and end-to-end visibility across data assets.
Lead triage meetings globally and collaborate with required stakeholders to determine fixes for identified data issues.
Automate manual data processing tasks and build scalable, repeatable data solutions, collaborating with Technology development and testing teams to ensure data transformation logic is properly developed and tested across lower environments.
Collaborate with teams to integrate databases with applications and analytics platforms.
Leverage analytical tools to develop metrics that measure data quality across source systems.
Leverage AI tools such as Claude, ChatGPT, and Copilot to turn data into clear documentation and visuals - including AI-assisted data dictionaries, process write-ups, and dashboards that help stakeholders understand data quality and pipeline health at a glance.
Provide training to new and existing users on data processes, tools, and process changes.
Foster an environment that encourages productivity, innovation, process improvement, teamwork, and professionalism, while complying with all Health and Safety, Food Safety, Bio Security, and Nature Fresh Farms policies and procedures
Comply with all Health and Safety, Food Safety, Bio Security, and Nature Fresh Policies and Procedure
Complete all physical requirements of the job with or without a reasonable accommodation
This job description highlights the main components but is not inclusive of other activities that may be required
What You Bring:
Educational background in Computer Science, Information Systems, Engineering, or a related field preferred.
3-5+ years of hands-on experience as a Database Administrator, Data Engineer, or in a similar data-focused role, including direct support of data pipelines for large-scale applications.
Strong working knowledge of relational databases and SQL, primarily Microsoft SQL Server - including T-SQL, indexing, performance tuning, and backup/recovery - along with experience in ETL/ELT tools and pipeline technologies (e.g., SSIS, Azure Data Factory, or similar).
Experience performing data profiling and root cause analysis, working with Source-to-Target Mapping documents and data dictionaries, and developing data quality metrics using BI tools (e.g., Power BI) to monitor data quality across source systems.
Experience automating manual data processes and building scalable data solutions using scripting or query languages (e.g., Python, PowerShell, T-SQL), with version control experience using Git.
Experience leveraging AI tools such as Claude, ChatGPT, and Copilot to turn data into documentation and visuals - including AI-assisted data dictionaries, process documentation, and dashboards for Business Units.
Working knowledge of data governance, cataloging, and metadata management practices; familiarity with cloud object storage (e.g., Amazon S3) and cloud data platforms (e.g., Azure SQL, Azure Data Lake) considered an asset.
Demonstrated ability to lead triage and troubleshooting sessions with global, cross-functional stakeholders, and to communicate complex technical details clearly to both Business and Technology audiences.
Strong analytical, organizational, and documentation skills, with sharp attention to detail and problem-solving ability.
High degree of confidentiality and integrity, with a self-starter mindset, high energy, and strong motivation, along with comfort presenting recommendations to management.
Ability to lift and carry items minimum 20 lbs, depending on role requirements.
Valid passport and ability to travel within Canada and US
Valid driver's license and personal vehicle required.
What To Expect:
Work is primarily performed in an office environment, with the occasional travel to other locations as needed.
Prolonged periods of sitting and computer use are required.
Requires regular communication and coordination with team members across departments.
Standard workdays are Monday-Friday, with rotational on-call require. Afterhours and weekends based on business needs.
