Information Technology Business Partner

Confidential Career; Guelph; On-site; CAD 90,000 - 100,000; Full time

Job summary

A leading data solutions provider in Guelph, Ontario is seeking a Senior D365 Finance and Operations / Business Intelligence Analyst. This role focuses on ERP management and the development of Power BI reports to transform data into actionable insights. The ideal candidate has over 5 years of expertise in Dynamics 365 and is proficient in financial processes. This full-time role offers significant opportunities for driving process excellence.

Qualifications

• 5+ years of hands-on expertise with Microsoft Dynamics 365 Finance and Operations.
• Strong understanding of Manufacturing Finance, Costing, and Inventory Controls.
• Proven proficiency in Power BI for data visualization.

Responsibilities

• Lead the D365 Manufacturing ERP application team.
• Oversee ERP system upgrades and enhancements.
• Design insightful reports and dashboards using Power BI.

Skills

D365 F&O expertise

Power BI mastery

Financial acumen

SQL skills

Data modeling

Job description

Base pay range

CA$90,000.00/yr - CA$100,000.00/yr

Senior D365 Finance and Operations / Business Intelligence Analyst

We are seeking a highly skilled and analytical Senior D365 F&O / BI Analyst to take ownership of our integrated data and ERP ecosystem. This is a critical role responsible for ensuring the stability and performance of our cloud-based manufacturing ERP while transforming business data into actionable intelligence through Power BI.

If you thrive at the intersection of Finance, Manufacturing, and Data Visualization, this is your opportunity to drive process excellence and reporting strategy.

The Opportunity: Drive Strategic Insights & System Excellence

This role involves a critical balance of ERP application leadership and advanced data modeling. You will serve as the technical lead for our D365 Manufacturing ERP application while simultaneously developing and maintaining our core Business Intelligence reporting capabilities.

Key Focus Areas

• System Ownership: Lead the D365 Manufacturing ERP application team, managing support escalations, prioritizing requests, and ensuring the timely resolution of critical issues.
• Optimization: Oversee ERP system upgrades, enhancements, and improvements in collaboration with cross‑functional teams to align the system with business goals.
• Integration & Support: Maintain all existing system integrations and act as the primary liaison between business stakeholders and the application environment.
• Enablement: Develop and oversee training programs to maximize ERP system adoption and utilization across the organization.

Business Intelligence & Reporting Development (Power Platform)

• BI Solution Design: Interact with stakeholders (especially Manufacturing Finance) to define new requirements and design visually appealing, insightful reports and dashboards using Power BI.
• Data Modeling: Build robust tabular and multidimensional data models, developing advanced‑level calculations using complex DAX functions.
• Ecosystem Management: Maintain the overall IDMS/BI environment, ensure data source integrity, and implement row‑level security on critical data sets.
• Integration: Work closely with application developers to integrate Power BI reports into other business applications.

Required Experience & Expertise

• D365 F&O Expertise: 5+ years of hands‑on expertise with Microsoft Dynamics 365 Finance and Operations, including configuration, customization, and integration.
• Financial Acumen: Strong understanding of Manufacturing Finance, Costing, Inventory Controls, MRP, P2P, and O2C processes.
• Power BI Mastery: Proven proficiency in Power BI for data visualization and report creation, including strong SQL and DAX skills. Power BI Certification (PL-300) is preferred.
• Technical Stack: Familiarity with data warehousing concepts, Azure services for cloud-based BI solutions, and programming skills in R or Python are beneficial.
• Soft Skills: Proven ability to manage complex projects, lead teams, deliver results, and communicate effectively with stakeholders at all organizational levels.

If you are ready to apply your technical depth to solve complex manufacturing and finance challenges and elevate our data‑driven decision‑making, we encourage you to apply.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Industries

Manufacturing and Motor Vehicle Parts Manufacturing

Referrals increase your chances of interviewing at Confidential Career by 2×

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.