Data Engineer

Parrish & Heimbecker, Limited; Winnipeg; On-site; CAD 80,000 - 95,000; Full time

Job summary

A leading Canadian agricultural company in Winnipeg is looking for a motivated Data Engineer to design and maintain data warehouses and ETL pipelines. The ideal candidate will have a Bachelor's degree in Computer Science and experience with Microsoft technologies including Azure and SQL Server. Join a family-owned business committed to meaningful growth and offer various benefits including development programs and health care.

Benefits

Learning and Development Programs

Dental, Vision, and Extended Health Care

Tuition Reimbursement

Employee Assistance Program

Paid Time Off

RRSP Matching

Wellness Program

Company Events

Qualifications

• 3+ years data warehouse/BI development with Microsoft technologies.
• Experience with SQL Server, T-SQL, stored procedures, and query optimization.
• Strong understanding of dimensional modeling principles.

Responsibilities

• Design, develop, and maintain data warehouses and ETL pipelines.
• Implement ETL processes using Microsoft Fabric.
• Assist in design, development, and optimization of SQL Server data warehouse.

Skills

Data warehouse/BI development with Microsoft technologies

Python development

ETL/ELT development and maintenance

Dimensional modeling principles

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

Microsoft Azure

SQL Server

Azure Data Factory

Microsoft Fabric

Job description

Data Engineer

Parrish & Heimbecker

Join our team that shares your Passion & Heart for Canadian agriculture! Parrish & Heimbecker, Limited (P&H) has an opportunity for a motivated, forward-thinking, and dedicated individual as a Data Engineer for our Grain division based in Winnipeg, MB.

P&H Grain

The P&H Grain Division is a comprehensive grain and crop input network, operating across approximately 45 locations in the prairie provinces, Ontario and Quebec. Our strategically positioned facilities, including grain elevators, rail sidings, inland terminals, and specialized export terminals, ensure that we effectively match producer grain with the needs of both domestic and export end users. As a full-service agri-retailer, we provide farming communities with a full range of quality crop input products and agronomic solutions, encompassing crop protection products, certified seeds, nutrients, and custom applications.

Wage and Benefits

Parrish & Heimbecker Ltd has a people-first approach therefore, we offer many perks to our hard-working staff! Some of our benefits include:

• Learning and Development Programs
• Dental, Vision, and Extended Health Care
• Tuition Reimbursement
• Employee Assistance Program
• Paid Time Off
• RRSP Matching
• Wellness Program
• Company Events

Your Role

As Data Engineer, the successful candidate will design, develop, and maintain data warehouses and ETL pipelines. They will work with Microsoft Fabric, Azure Data Factory, SQL Server, Azure DevOps, and code in Python and PySpark to deliver reliable, high-quality BI solutions to support business decision-making.

Day to Day

• Implement ETL processes using Microsoft Fabric.
• Develop and maintain pipelines and Git repositories in Azure DevOps.
• Assist in design, development, and optimization of SQL Server data warehouse solutions using star schema and dimensional modeling.
• Perform advanced data analysis, including predictive modeling and statistical analysis to support decisions.
• Develop and deploy reports, scorecards, and dashboards.
• Optimize BI solutions for performance, scalability, and automation.
• Collaborate with stakeholders to translate business requirements into technical specifications.
• Identify process failures and implement solutions to prevent recurrence.
• Assist in the designing, developing, and optimizing SQL Server data warehouse solutions using star schema and dimensional modeling.
• Collaborate with stakeholders to translate business requirements into technical BI specifications.

Required Qualifications

• Bachelor’s degree Computer Science, Information Systems, or related field
• 3+ years data warehouse/BI development with Microsoft technologies
• Experience Microsoft Azure, Data Factory
• Python development experience: Apache Spark/PySpark, Databricks, Delta Lake or similar
• Experience with SQL Server, T-SQL, stored procedures, and query optimization
• Proven experience in ETL/ELT development and maintenance
• Strong understanding of dimensional modeling principles and experience implementing star

Preferred Qualifications

• Prior experience in the agriculture industry
• Experience with Microsoft Fabric
• Microsoft Fabric DP-600 or DP-700 certification is an asset
• Knowledge of machine learning development

Work and grow with a family-owned company.

Join our team with Purpose & History! P&H’s roots go back over 115 years. We have always been a Canadian, family-owned and managed agri-business that understands the qualities and conditions needed for meaningful growth. Our corporate culture values are family values; honesty and integrity with a focus on listening and continuous learning. Like family, we support our staff to always do better.

With over 70 locations spanning from coast to coast, and trade links around the globe, P&H is growth-oriented, diversified and vertically integrated with operations spanning across grain merchandising, flour milling, crop input distribution and animal feed production.

To apply and learn more visit us at www.pandhcareers.com.

We thank all applicants, but only those selected for an interview will be contacted.

P&H is committed to building a skilled and diverse workforce that is reflective of Canadian society. Parrish & Heimbecker, Limited is an equal opportunity employer and is in compliance with the Employment Equity Act. P&H welcomes and encourages applications from women, aboriginal people, people with disabilities and members of visible minorities. Accommodations in relation to the job selection process are available upon request for both internal and external candidates taking part in all aspects of the recruitment process.