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. As a result, 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.
