Data Analyst and Business Intelligence Developer (1 Year contract)

About Us

Agrocrop Exports Ltd. is a trusted leader in the processing and export of Pulses, Beans, Lentils, Peas, and Grains, specializing in Private Label consumer packaging. Based in Canada and backed by HACCP and BRC “AA” certifications, we ensure the highest standards of quality, safety, and reliability in every product.

Serving major retailers across North America and Europe, our modern processing and packaging facility, combined with deep industry expertise, has positioned us as the largest Private Label processor of packaged pulses in the Western Hemisphere. Our continued growth is driven by innovation, operational excellence, and a deep commitment to our customers and partners worldwide.

The opportunity

We are seeking an experienced Data and Business Intelligence Analyst to turn financial, manufacturing, and supply chain data into reliable reporting and practical business recommendations. You will work directly with BI Manager, Finance, Operations, and Supply Chain teams to understand business needs, investigate performance, and deliver analytics that improve decisions, productivity, cost control, and inventory management.

This is a hands-on role combining advanced Excel and Power BI development, strong SQL and DAX skills, business analysis, and reporting automation. You will also help develop our analytics capabilities using Microsoft Fabric and Microsoft Azure cloud services.

Key responsibilities

• Partner with Finance, Operations, and Supply Chain stakeholders to define business questions, gather requirements, agree on KPI definitions, and prioritize reporting improvements.
• Design, develop, and maintain Power BI dashboards, reusable semantic models, and Excel analyses. Build accurate DAX measures and Power Query transformations, and optimize model and report performance.
• Extract, clean, transform, and integrate data from ERP systems Like Microsoft Business Central, SQL databases, Microsoft 365 sources, and APIs. Create documented, repeatable data preparation processes.
• Own report reliability through data validation, refresh monitoring, issue resolution, user acceptance testing, and controlled releases. Maintain KPI definitions, data lineage, and technical documentation.
• Apply appropriate access controls and row-level security. Train business users, support self-service reporting, and automate recurring reporting and manual workflows.
• Contribute to Microsoft Fabric and Azure initiatives with IT and data partners, including data integration, shared data models, and scalable analytics foundations.
• Strong understanding about Finance, Manufacturing performance, including overall equipment effectiveness, downtime, throughput, yield, scrap, labour productivity, and production schedule adherence.
• Analyze inventory levels and aging, inventory turns, demand and supply trends, forecast accuracy, supplier performance, and service levels to identify improvement opportunities.
• Investigate discrepancies and root causes, explain business implications, and present clear recommendations to technical and non-technical audiences.

Required qualifications

• Bachelor’s degree in Data Science, Engineering, Computer Science, Statistics, Business Analytics, Information Systems, or a related discipline.
• Typically, 3–5 years of relevant experience in business intelligence, data analytics, or reporting, with demonstrated ownership of solutions from requirements through deployment and support.
• Expert proficiency in Power BI Desktop and Service, DAX, data visualization, dimensional modelling, relationships, filter context, and performance optimization.
• SQL skills, including joins, common table expressions, window functions, aggregation, and data validation; experience working with relational databases and complex datasets.
• Power Query skills and a sound understanding of ETL processes, star schemas, data quality, and data warehousing concepts.
• Expert proficiency in Microsoft Excel, including advanced formulas, PivotTables, Power Query and Power Pivot.
• Strong proficiency in Microsoft 365, Power Automate, particularly SharePoint, Teams and reporting workflows.
• Working knowledge of Microsoft Fabric, including OneLake, Lakehouse or warehouse concepts, and data pipelines; familiarity with relevant Microsoft Azure data services and cloud security fundamentals.
• Strong business understanding and experience working directly with IT and BI.
• Clear communication, strong analytical judgment, attention to detail, and the ability to manage competing priorities independently. Availability to work on-site

Preferred qualifications and growth skills

• Experience in manufacturing, food processing, consumer goods, or distribution; familiarity with production, costing, inventory, procurement, and planning processes.
• Experience with Microsoft Dynamics 365 Business Central or a comparable ERP, including understanding transactional data and integrating ERP data into reporting.
• Experience with Power Automate, VSCode, Power Apps, REST APIs, OData, and authentication concepts such as OAuth.
• Hands-on Microsoft Fabric or Azure data integration experience; Python for analysis, validation, or automation; Git and version control for analytics development.
• Familiarity with forecasting, scenario analysis, data governance, and responsible use of AI-assisted analytics with appropriate validation and data protection.
• Relevant Microsoft certifications in Power BI, Fabric, or Azure are an asset.

Agrocrop Exports Ltd. is an equal opportunity employer committed to diversity and inclusion. We encourage applications from all qualified individuals and are dedicated to a fair and accessible hiring process. Accommodations are available upon request for candidates taking part in all aspects of the selection process.

Notice to Applicants: This posting represents an active vacancy. AI-enabled recruitment tools may be used to assist with parts of the applicant screening process, but all evaluations and hiring decisions are made by our hiring team.