Business Intelligence Analyst

Rennie Consulting - Oakville, ON (30+ days ago)

Apply Now

Business Intelligence Analyst

This North American manufacturer is experiencing significant growth as it continues to surpass business projections.

The successful candidate will provide key assistance and advice to Senior Management by conducting detailed analysis and preparing related reports.

Critical responsibilities include planning, developing and maintaining operational projects and initiatives related to product flow, inventory management, layout planning and production optimization.

Specific Responsibilities:

  • Work with management to prioritize information needs Identify, analyze, and interpret trends or patterns, problematic areas using statistical techniques and suggest improvements in complex data sets
  • Plan and assist in the implementation of supply chain optimization initiatives or projects related to operational changes including but not limited to layout, planning, merchandise flow, capacity planning, inventory – aging, DOH, risks, damages – quality and service
  • Plan the movement of merchandise for all programs
  • Track KPIs and report on supply chain’s performance, extract value from KPI and explain variance
  • Work with cross-functional teams to analyze, plan and assist in the management of production activities, plans and schedules to ensure continuous operations
  • Highlighting potential risks and opportunities and formulate & execute process improvement, action & mitigation plans
  • Analyze consumption and production rates and determine production efficiency
  • Develop standard procedures to optimize workflow locally or nationally
  • Evaluate issues, analyze root causes and recommend improvements to maintain production integrity, consistency and quality
  • Help analyze and assess the impact of the proposed projects, while taking into account schedules and effort/budgets, and follow up with regional management to ensure proper implementation
  • Collaboratively lead projects
  • Act as an expert in your field, providing ideas/innovations, opinions and advice to others regional and nationally
  • Create and deliver quality presentations with the purpose of informing, instructing, inspiring or persuading an audience.

Minimum Requirements

  • Minimum of 3-5 years’ experience in a similar role, technical role or as a Business Analyst associated with a good understanding of supply chain, material management, merchandise flow and / or production operations
  • Solid knowledge of SQL, MS Office including advanced Excel; AS400 - must have advanced proficiency in order to manipulate and extract system data
  • Proficient in ETL (extract, transform, load)
  • Experience with Microsoft BI would be an asset
  • Proven track record in preparing operational analyses and business plans
  • Experience in project management, including practices, techniques and tools;
  • PMP designation would be an asset
  • Lean Six Sigma would be an asset
  • Organized and methodical, with a thorough work method
  • Proven problem-solving, detail oriented and decision-making skills
  • Able to work independently Strong communication skills, verbal and written skills
  • Able to plan and lead facilitation sessions
  • Able to travel approximately 10% of the time
  • French & English bilingual is an asset


  • Extended health care
  • Vision care
  • Dental care
  • Bonus scheme
  • Profit sharing/share options
  • Flexible working hours
  • Work from home opportunities
  • Employee assistance programs
  • Vacation & paid time off
  • Company events & social hours
  • On-site parking
  • Education reimbursement

Job Types: Full-time, Permanent


  • Business Analyst: 5 years (Preferred)
  • Supply Chain optimization: 5 years (Preferred)
  • Training: 5 years (Preferred)
  • KPI/Metrics: 5 years (Preferred)
  • SQL: 5 years (Required)
  • AS400: 5 years (Required)
  • Capacity Planning: 5 years (Preferred)
  • Root Cause Analysis: 1 year (Preferred)
  • Continuous Improvement : 1 year (Preferred)
  • 5S: 1 year (Preferred)
  • ETL: 5 years (Required)
  • Six Sigma: 1 year (Preferred)


  • Bachelor's Degree (Preferred)


  • Oakville, ON (Preferred)


  • PMP (Preferred)


  • English (Required)
  • French (Preferred)