Assistant Manager, Commercial Analytics & Business Intelligence at Midea

Markham, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

21 Sep, 26

Salary

82000.0

Posted On

23 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, SQL, Python, DAX, SSAS, SSIS, Data Modeling, ETL, Business Intelligence, Data Analytics, Excel VBA, Power Automate, Pricing Strategy, Financial Analysis, Stakeholder Management, Database Management

Industry

electrical;Appliances;and Electronics Manufacturing

Description

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 Bachelor’s 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$ 75,000 - $82,000 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.

Responsibilities

Design and maintain business intelligence solutions and reporting platforms to support data-driven decision-making across various commercial functions. Lead the development of pricing tools, promotional strategies, and process automation to improve operational efficiency.