Assistant Manager, Commercial Analytics & Business Intelligence

Assistant Manager Commercial Analytics & Business Intelligence

About Midea America Canada Corporation (MACC):

Midea America Canada Corporation (MACC) is a Global leader in home appliances manufacturing dedicated to improving the lives of consumers through innovative high-quality products. At MACC we pride ourselves on fostering creativity and excellence in every aspect of our work.

Position Summary

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.

Key Responsibilities

Business Intelligence & Analytics

• 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.

Pricing Promotions & Trade Terms (PP&T)

• 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.

Process Automation & Operational Excellence

• 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.

Qualifications

Education

• Bachelors degree in Computer Science Information Systems Data Analytics Business Analytics Finance Economics Engineering or a related field.

Experience

• 5 years of experience in Business Intelligence Data Analytics Data Engineering or related fields.
• Proven experience designing and delivering end-to-end BI solutions.
• Experience supporting commercial functions such as Sales Product Management Finance or Supply Chain is preferred.

Technical Skills

Required:

• 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.

Core Competencies

• 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.

The expected base salary range for this role is CAD$ 75000 - $82000 Final compensation will be based on a variety of factors including experience skills and qualifications relevant to the position. This job posting represents a current opportunity within the company.

Midea America (Canada) Corp. is an equal opportunity employer. We do not discriminate based upon race religion color national origin gender (including pregnancy childbirth or related medical conditions) sexual orientation gender identity gender expression age status as a protected veteran status as an individual with a disability or other applicable legally protected characteristics.