Business Planning Analyst

Confidential; Montreal (administrative region); On-site; CAD 70,000 - 110,000; Full time

Benefits offered by this job

Professional growth

Cross-functional exposure

Dynamic manufacturing environment

Operational improvement initiatives

Job summary

Confidential in Montreal, QC is seeking a seasoned Business Analyst to drive process improvement across production planning, inventory, and supply chain operations. You will gather requirements, map current processes, and translate them into actionable SOPs, dashboards, and reporting solutions.

A strong analytical mindset and ability to work with cross-functional teams are essential. Responsibilities include developing Power BI reports, leveraging advanced Excel, and coordinating with

Qualifications

• Bachelor's degree in Business, Operations, or a related field.
• Minimum 3 years of experience in business analysis, operations, planning, or supply chain.
• Experience gathering requirements and documenting processes.
• Strong analytical and problem-solving skills.
• Experience with ERP and/or MRP systems.
• Advanced Excel skills.
• Experience developing Power BI reports and dashboards.
• Fluent in English and French.

Responsibilities

• Analyze and document business processes related to production planning, inventory management, and supply chain operations.
• Meet with stakeholders to gather requirements and recommend improvements.
• Develop dashboards and reporting solutions using Power BI and Excel.
• Create SOPs, process maps, and business requirements documents.
• Support planning activities and coordinate material availability.
• Monitor planning exceptions and supply-chain risks.
• Collaborate with procurement, production, logistics, and engineering teams.

Skills

Analytical thinking

Problem-solving

Communication

Multitasking

Education

Bachelor's degree in Business/Operations/Supply Chain

Tools

Power BI

Advanced Excel

ERP/MRP systems

SQL

SAP / Oracle / Ariba

Job description

Key Responsibilities

Business Analysis & Process Improvement

Analyze and document business processes related to production planning, inventory management, materials planning, and supply chain operations.

Meet with stakeholders to gather requirements, understand operational challenges, and recommend improvements.

Facilitate discussions and working sessions with cross-functional teams to identify opportunities for greater efficiency.

Conduct root-cause analyses related to material shortages, scheduling issues, inventory discrepancies, and workflow inefficiencies.

Translate business requirements into actionable process, reporting, or system improvements.

Create and maintain process documentation, workflows, procedures, and business requirements documents.

Contribute to operational excellence, digital transformation, and continuous improvement initiatives.

Support daily and long-range production and materials planning activities.

Maintain planning parameters including lead times, safety stock levels, reorder points, and bill-of-material accuracy.

Coordinate material availability to support customer demand and production requirements.

Develop and maintain production schedules based on capacity, demand forecasts, inventory levels, and operational priorities.

Monitor planning exceptions, shortages, and supply-chain risks.

Analyze demand trends and inventory performance to support operational decision-making.

Work closely with procurement, production, logistics, and engineering teams to ensure uninterrupted operations.

Reporting & Data Analytics

Develop, maintain, and enhance dashboards, KPIs, and operational performance reports.

Analyze large datasets using advanced Excel tools, formulas, and pivot tables.

Build and maintain reporting solutions using Power BI and other business intelligence tools.

Identify trends, risks, inefficiencies, and opportunities using operational and business data.

Present findings and recommendations to managers and senior leaders.

Support decision-making through accurate reporting, analysis, and business insights.

Improve data quality, reporting processes, and visibility of operational metrics.

Process Documentation & Continuous Improvement

Develop and maintain standard operating procedures (SOPs), workflows, process maps, and operational documentation.

Ensure planning and reporting processes are documented, standardized, and continuously improved.

Identify opportunities to increase efficiency, reduce manual processes, and improve data accuracy.

Support system enhancements, reporting improvements, and operational initiatives across multiple departments.

Participate in continuous improvement projects focused on planning effectiveness, inventory management, and operational performance.

Qualifications

Bachelor's degree in Business, Business Technology Management, Operations Management, Supply Chain Management, Engineering, Information Systems, or a related field.

Minimum 3 years of experience in business analysis, operations, manufacturing, planning, supply chain, project analysis, or related environments.

Experience gathering business requirements and documenting processes.

Strong analytical and problem-solving skills.

Experience working with ERP and/or MRP systems.

Advanced Microsoft Excel skills.

Experience developing reports and dashboards using Power BI.

Experience analyzing operational, supply chain, manufacturing, or business data.

Manufacturing or industrial experience is considered a strong asset.

Preferred Technical Skills

Power BI

Advanced Excel (Pivot Tables, Power Query, Lookups, Data Analysis)

ERP/MRP Systems

SQL (Asset)

SAP, Oracle, Ariba, or similar enterprise systems (Asset)

Business Process Mapping

KPI Development and Reporting

Process Improvement Methodologies

Strong analytical mindset

Exceptional attention to detail

Excellent organizational skills

Ability to manage multiple priorities simultaneously

Strong communication and presentation skills

Initiative and accountability

Ability to work effectively across multiple departments

Strong problem-solving capabilities

Professional proficiency in English and French.

Ability to communicate effectively with employees, managers, suppliers, and business partners across various functions.

What We Offer

• Opportunities for professional growth and development
• Exposure to cross-functional business initiatives
• Collaborative and dynamic manufacturing environment
• Opportunity to play a key role in operational and business improvement initiatives