Senior Business Intelligence Analyst (Power BI)

CM2; Oshawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in automotive innovation is seeking a Senior Business Intelligence Analyst (Power BI) to create impactful business intelligence solutions. The role involves designing and deploying reports, collaborating with marketing teams, and optimizing data processes to support decision-making. Ideal candidates will have strong skills in Power BI, DAX, and SQL, along with a relevant degree. Join a dynamic team at GM Canada to drive insights and enhance marketing strategies.

Qualifications

• Minimum of 3 years experience in Power BI report/dashboard design.
• Strong proficiency in DAX and data modeling.

Responsibilities

• Develop interactive Power BI reports and dashboards.
• Collaborate with stakeholders to define requirements.

Skills

DAX

Power Query

SQL

Analytical Thinking

Problem Solving

Communication

Education

Bachelor’s degree in Business Analytics

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Tools

Power BI

SAS

R

Python

Job description

Senior Business Intelligence Analyst (Power BI)

Senior Business Intelligence Analyst (Power BI)

Role Title: Senior Business Intelligence Analyst (Power BI)

Employer: CM2 Solutions Inc. at General Motors of Canada Company

The Company

CM2 supports Marketing and Customer Relationship Management (CRM) activities at General Motors of Canada. The GM team of CM2 is based at GM’s Canadian headquarters in Oshawa.

General Motors of Canada employs more than 9,000 people across the country and is a recognized leader in innovation, technology, and green manufacturing. GM markets four automotive brands in Canada (Chevrolet, Buick, GMC and Cadillac) through Canada's largest automotive dealer network.

Overview of Position

At GM Canada, you will find self-motivated people that dream big and go the extra distance to implement innovative solutions.

As a Senior Business Intelligence Analyst (Power BI), you will be responsible for designing, developing, and deploying business intelligence solutions using Microsoft Power BI, to deliver insightful visualizations and reports that support decision-making processes for marketing.

You will collaborate with marketing stakeholders, and other analytical specialists to define visually engaging dashboards to generate business insights and track KPI’s. You will work with other IT professionals to transform data from various sources, automate data feeds, ensure data accuracy, and optimize performance.

Key Activities

• Develop interactive and visually compelling Power BI reports, dashboards, and visualizations to address marketing needs and opportunities.
• Collaborate with business and analytical stakeholders to define requirements, gather feedback, and iteratively enhance reports and dashboards.
• Define measurement frameworks and business rules for KPI’s
• Design and manage ETL processes to transform data from various sources into Power BI, ensuring data quality and consistency.
• Create and optimize data models, DAX calculations, and queries to ensure efficient and reliable reporting.
• Optimize report performance and automation through proper data model design, query optimization, and report configuration.
• Enhance over time, in response to user feedback, marketing needs, and additional data sources.
• Create documentation for data models, processes, and reports.
• Generate insights and conduct training sessions to empower users to leverage Power BI effectively.
• Monitor and maintain quality.

Skills and Experience

• Minimum of 3 years of experience in designing and developing reports/dashboards using Power BI.
• Strong proficiency in DAX, Power Query, and data modeling in Power BI.
• Experience with SQL and large relational databases for data extraction and manipulation.
• Ability to transform business requirements into technical specifications and intuitive visualizations.
• Strong analytical thinking and problem-solving skills.
• Attention to detail, and a keen interest to understand the data (sales, consumer interactions, marketing campaigns)
• Excellent communication skills, with the ability to articulate complex data insights to non-technical stakeholders.
• Business acumen in applying analytical insights to marketing.
• Strong interpersonal and communication skills, to collaborate within a dynamic marketing and technical environment
• Proficiency with other analytical languages/tools preferred (e.g; SAS, R, Python)

Education

• Bachelor’s degree in Business Analytics, Computer Science, Information Technology, or relevant quantitative discipline.

We thank all applicants, but will only contact those selected for interviews.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Advertising Services

Referrals increase your chances of interviewing at CM2 by 2x

Get notified about new Senior Business Intelligence Analyst jobs in Oshawa, Ontario, Canada.

Senior Analyst - Data Strategy and Analytics

Data Analyst Intern/Co-Op (Undergrad | Fall, 2025 | Onsite/Hybrid | 4 months)

ERP Analyst Data Integration & System Administration

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.