Assistant Manager, Commercial Analytics & Business Intelligence

Midea•Markham, ON

1d•CA$75,000 - CA$82,000

About The Position

The Assistant Manager, Commercial Analytics & Business Intelligence is responsible for designing, developing, and maintaining business intelligence solutions that support data-driven decision-making across Sales, Product Management, Supply Chain, Finance, and Operations functions. This role will lead the development of data models, reporting platforms, analytical tools, and automated business processes while ensuring data quality, accessibility, and governance. The successful candidate will transform complex business requirements into scalable BI solutions that improve operational efficiency and deliver actionable insights.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Finance, Economics, Engineering, or a related field.
5+ years of experience in Business Intelligence, Data Analytics, Data Engineering, or related fields.
Proven experience designing and delivering end-to-end BI solutions.
Advanced SQL development and database management skills.
SQL Server technologies including SSIS, SSAS, and SQL Server Agent.
Strong Power BI development experience including data modeling and DAX.
Experience designing and maintaining data warehouses and analytical data models.
Advanced Microsoft Excel skills.
Experience with ETL development and data integration.
Python programming for data processing and automation.
Strong analytical and problem-solving skills.
Excellent communication and stakeholder management abilities.
Strong business acumen with the ability to translate business needs into technical solutions.
Ability to manage multiple projects and priorities in a fast-paced environment.
Continuous improvement mindset with a passion for data and technology.

Nice To Haves

Experience supporting commercial functions such as Sales, Product Management, Finance, or Supply Chain is preferred.

Responsibilities

Design, develop, and maintain enterprise reporting and analytics solutions using Power BI and other BI tools.
Partner with business stakeholders to understand requirements and translate them into scalable data and reporting solutions.
Develop and maintain dashboards, scorecards, and KPI reporting for Sales, Product Management, Supply Chain, Finance, and Executive leadership teams.
Support and optimize analytical data environments, including SSAS cubes, SQL Server databases, and semantic data models.
Manage AHAM and other external industry datasets to generate actionable business insights.
Support the development and execution of pricing and promotional strategies across multiple product categories.
Develop and maintain tools and processes to manage pricing, promotional planning, and trade terms.
Create and maintain retail and regional price lists to support sales execution and customer communication.
Develop and maintain promotional calendars, planning templates, and related calculation models.
Support Sell Through Allowance (STA) calculations, deduction analysis, accrual tracking, and promotional spending simulations.
Ensure data accuracy and consistency across pricing and promotional planning processes.
Analyze promotional effectiveness, pricing performance, and trade investment ROI.
Develop dashboards and reports to monitor promotional spending, sell-through performance, and pricing compliance.
Support MAP/PMAP monitoring and pricing governance activities where applicable.
Identify opportunities to automate manual reporting and business processes.
Develop automation solutions using SQL, Python, Power Automate, Excel VBA, APIs, and related technologies.
Improve reporting efficiency, reduce manual effort, and increase data accessibility across the organization.
Create tools and applications that support business planning, forecasting, pricing management, promotional planning, and performance tracking.
Deliver recurring and ad hoc analyses, including executive-level reporting and business performance reviews.
Support cross-functional decision-making by transforming complex data into clear and actionable business insights.