Back to jobs

Associate Consultant - Data & Analytics

Toronto Downtown - ON 17

Live, first seen by us 16 days ago
Pay
$70,000–96,400/yearAnnual period assumed — pay source
· Experience with Git, deployment pipelines, Azure DevOps, Power Apps or Power Automate, and the ability to communicate in English and French Pay range: $ 70,000- $ 96,400, depending on experience and skill set Current Opening: This posting reflects a currently available position within our organization for which we are actively recruiting.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Run client discovery sessions and support scoping, estimates and statements of work

  • Design and build Power BI reports, dashboards and semantic models

  • Build and maintain data pipelines and lakehouses in Microsoft Fabric and Azure

  • Connect to APIs and business apps such as ServiceNow, Salesforce and ERP

  • Support Fabric assessments and prepare and deliver Power BI training

From the employer’s posting
Engage with clients in discovery sessions to translate business needs into technical requirements, and support scoping, estimates, letters of effort (LOE) and statements of work
Design and build Power BI reports, dashboards and semantic models
Build and maintain data pipelines, dataflows, lakehouses and warehouses in Microsoft Fabric and Azure
Connect to APIs and business applications such as ServiceNow, Salesforce and ERP platforms
Support Fabric assessments across capacity, cost, governance, pipelines, Power BI and AI readiness
Education & alternatives
Education and/or Experience Qualifications · Bachelor’s degree in Computer Science, Information Systems, Engineering, Business Analytics, or equivalent experience · 2-4 years of hands-on experience in business intelligence, analytics engineering or data engineering, ideally in a consulting or client-facing role

Tools in this posting

  • Python
  • SQL
  • Azure
  • Databricks
  • Power BI
  • Power Query
Source — Tool mentions in context
· Strong Power BI skills, including star-schema modelling, DAX, Power Query (M), report design, licensing, workspaces, security and access management · Proficiency in SQL, working knowledge of Python, and experience building ETL/ELT pipelines and integrating APIs · Ability to articulate complex data-related concepts clearly to both technical and non-technical audiences
Other Required Qualifications · Hands-on exposure to Microsoft Fabric (Lakehouse, Warehouse, Data Factory pipelines, notebooks) or Azure data services such as Azure Data Factory, Azure SQL, Synapse or Databricks · Strong analytical, problem-solving, communication and presentation skills, with confidence working directly with customers and collaborating with consultants, offshore delivery teams and partners
· Design and build Power BI reports, dashboards and semantic models using strong data modelling, DAX, Power Query (M) and visualization practices · Build and maintain data pipelines, dataflows, lakehouses and warehouses in Microsoft Fabric and Azure that integrate data from multiple sources · Connect to APIs and business applications such as ServiceNow, Salesforce and ERP platforms, including authentication and pagination
· Experience with ServiceNow, Salesforce or ERP data sources, and familiarity with data governance and quality practices such as Microsoft Purview and sensitivity labels · Experience with Git, deployment pipelines, Azure DevOps, Power Apps or Power Automate, and the ability to communicate in English and French Pay range: $ 70,000- $ 96,400, depending on experience and skill set
Reporting to the Senior Manager, Business Intelligence, the Associate Consultant, Data & Analytics will help customers make faster and better business decisions by turning their data into trusted, AI-ready insights. Working alongside consultants on client engagements, they will build Power BI reports and semantic models, develop data pipelines in Microsoft Fabric, support assessments and training workshops, and help customers prepare their data for Copilot and AI. The ideal candidate is a hands-on builder who enjoys working directly with customers and has a passion for using data to drive business outcomes. Core Responsibilities:
· Engage with clients in discovery sessions to translate business needs into technical requirements, and support scoping, estimates, letters of effort (LOE) and statements of work · Design and build Power BI reports, dashboards and semantic models using strong data modelling, DAX, Power Query (M) and visualization practices · Build and maintain data pipelines, dataflows, lakehouses and warehouses in Microsoft Fabric and Azure that integrate data from multiple sources
· Build well-modelled, documented and governed data foundations that support Copilot, AI agents and other AI use cases · Support Fabric assessments across capacity, cost, governance, pipelines, Power BI and AI readiness, and document findings, quick wins and implementation plans · Configure workspaces, user access, row-level security and governance controls in line with client policies
· Configure workspaces, user access, row-level security and governance controls in line with client policies · Prepare and facilitate Power BI and Fabric training, and create documentation and handover materials so client teams can sustain solutions after go-live · Review delivery work from offshore teams and partners, build reusable templates and sample reports, support customer demos, and identify follow-on opportunities to share with sales
· 2-4 years of hands-on experience in business intelligence, analytics engineering or data engineering, ideally in a consulting or client-facing role · Strong Power BI skills, including star-schema modelling, DAX, Power Query (M), report design, licensing, workspaces, security and access management · Proficiency in SQL, working knowledge of Python, and experience building ETL/ELT pipelines and integrating APIs
Nice to Have · Microsoft certifications such as PL-300, DP-600 or DP-700, and experience with Copilot in Power BI or Fabric, Copilot Studio, or preparing data for AI · Experience with ServiceNow, Salesforce or ERP data sources, and familiarity with data governance and quality practices such as Microsoft Purview and sensitivity labels

About CDW

CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology.

In the employer’s words · Read in context

Check the employer’s page ↗

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 5, 202616 days ago
Recorded sightings
12
Last seen by us
Nov 16, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 16

Similar jobs usually come down between day 5 and day 43.

At CDW, jobs usually come down by about day 35.

From 16,018 similar postings that came down, and 16 of CDW’s. Coming down is not always a hire.

CDW is hiring

6 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring at a steady pace
  • Takes jobs down quickly
Hiring record

Your next step

Check the employer’s posting for the current role and application details.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

Reporting to the Senior Manager, Business Intelligence, the Associate Consultant, Data & Analytics will help customers make faster and better business decisions by turning their data into trusted, AI-ready insights. Working alongside consultants on client engagements, they will build Power BI reports and semantic models, develop data pipelines in Microsoft Fabric, support assessments and training workshops, and help customers prepare their data for Copilot and AI. The ideal candidate is a hands-on builder who enjoys working directly with customers and has a passion for using data to drive business outcomes.

 

Core Responsibilities:

·        Engage with clients in discovery sessions to translate business needs into technical requirements, and support scoping, estimates, letters of effort (LOE) and statements of work

·        Design and build Power BI reports, dashboards and semantic models using strong data modelling, DAX, Power Query (M) and visualization practices

·        Build and maintain data pipelines, dataflows, lakehouses and warehouses in Microsoft Fabric and Azure that integrate data from multiple sources

·        Connect to APIs and business applications such as ServiceNow, Salesforce and ERP platforms, including authentication and pagination

·        Build well-modelled, documented and governed data foundations that support Copilot, AI agents and other AI use cases

·        Support Fabric assessments across capacity, cost, governance, pipelines, Power BI and AI readiness, and document findings, quick wins and implementation plans

·        Configure workspaces, user access, row-level security and governance controls in line with client policies

·        Prepare and facilitate Power BI and Fabric training, and create documentation and handover materials so client teams can sustain solutions after go-live

·        Review delivery work from offshore teams and partners, build reusable templates and sample reports, support customer demos, and identify follow-on opportunities to share with sales

 

Education and/or Experience Qualifications

·        Bachelor’s degree in Computer Science, Information Systems, Engineering, Business Analytics, or equivalent experience

·        2-4 years of hands-on experience in business intelligence, analytics engineering or data engineering, ideally in a consulting or client-facing role

·        Strong Power BI skills, including star-schema modelling, DAX, Power Query (M), report design, licensing, workspaces, security and access management

·        Proficiency in SQL, working knowledge of Python, and experience building ETL/ELT pipelines and integrating APIs

·        Ability to articulate complex data-related concepts clearly to both technical and non-technical audiences

 

Other Required Qualifications

·        Hands-on exposure to Microsoft Fabric (Lakehouse, Warehouse, Data Factory pipelines, notebooks) or Azure data services such as Azure Data Factory, Azure SQL, Synapse or Databricks

·        Strong analytical, problem-solving, communication and presentation skills, with confidence working directly with customers and collaborating with consultants, offshore delivery teams and partners

·        Track record of balancing multiple priorities and client deadlines while adapting to changing needs, with the ability to travel occasionally to client sites

 

Nice to Have

·        Microsoft certifications such as PL-300, DP-600 or DP-700, and experience with Copilot in Power BI or Fabric, Copilot Studio, or preparing data for AI

·        Experience with ServiceNow, Salesforce or ERP data sources, and familiarity with data governance and quality practices such as Microsoft Purview and sensitivity labels

·        Experience with Git, deployment pipelines, Azure DevOps, Power Apps or Power Automate, and the ability to communicate in English and French

Pay range: $ 70,000- $ 96,400, depending on experience and skill set

Current Opening: This posting reflects a currently available position within our organization for which we are actively recruiting. 

CDW is committed to being an AI-fluent organization 

We’re looking for people who bring curiosity, a learner’s mindset, and a willingness to engage with ever-evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances—not replaces—human creativity and decision-making. You don’t need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work.

CDW is committed to being an AI-fluent organization

We’re looking for people who bring curiosity, a learner’s mindset, and a willingness to engage with ever-evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances—not replaces—human creativity and decision-making. You don’t need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work.

Additionally, CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, our goal is to understand your experience, strengths, skills, and qualifications. As an AI forward company, we see AI not just as a tool, but as a catalyst for new ways of thinking, creating, and communicating. We encourage candidates to embrace an AI mindset, one that’s curious, adaptive, and ready to explore what’s possible. We welcome thoughtful use of AI to expand your perspective and elevate how you share your story, while ensuring your application remains rooted in your own background, judgment, and voice.

About Us

CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology. What makes CDW different isn’t just what we do—it’s how we do it. At CDW we act as one—building trust, speaking candidly, and working together to achieve more. We play to win—focusing on what matters most and delivering for our customers. And we think forward—staying curious, moving fast, and continuously learning. We believe meaningful work happens when people feel supported, heard, and empowered to contribute. That’s why we think of ourselves as coworkers, not just employees—working together to solve complex challenges and deliver real impact for our customers and communities.

 

As a full‑stack, full‑lifecycle technology partner, CDW brings deep expertise, strong relationships, and broad industry knowledge to help turn ideas into outcomes. When you join CDW, you become part of a collaborative environment where your work matters, your growth is supported, and your contributions help shape what’s next.

Together, we deliver the full promise of what technology can do. Together, we Make Amazing Happen.

 

CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law.       

About CDW

People
About 250 in 2025, about the same as the year before.Annual report (SEC Form 10-K)
Company
Listed as CDW.
H-1B visas
7 approved for new hires in fiscal 2025.US Citizenship and Immigration Services

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
· Experience with Git, deployment pipelines, Azure DevOps, Power Apps or Power Automate, and the ability to communicate in English and French Pay range: $ 70,000- $ 96,400, depending on experience and skill set Current Opening: This posting reflects a currently available position within our organization for which we are actively recruiting.
Location & working pattern

Toronto Downtown - ON 17

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

AI answers unavailable

We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting