Associate Consultant – Data & Analytics

CDW

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

Posted 11/5/2026full-timeToronto • CanadaJuniorMid-Level💰 CA$70,000 - CA$96,400 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Power BI report design, data modeling, and analytics engineering, with a strong focus on building and maintaining data pipelines in Microsoft Fabric and Azure. Proficient in client engagement, translating business needs into technical solutions, and delivering training and documentation for sustainable implementations.

Highest-signal resume keywords

Power BI Report DesignData ModelingMicrosoft FabricSQL ProficiencyETL/ELT Pipeline Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

DAXPower Query (M)Data EngineeringAnalytics EngineeringAPI IntegrationData GovernanceData WarehouseData LakehouseSQLPython

Soft Skills

Analytical SkillsProblem-SolvingCommunicationPresentation SkillsCollaboration

Tools & Technologies

Microsoft FabricAzure Data FactoryAzure SQLSynapseDatabricksServiceNowSalesforcePower AppsPower AutomateGit

Certifications & Qualifications

PL-300DP-600DP-700

Industry Keywords

Business IntelligenceData GovernanceClient-Facing RoleConsultingData Quality Practices

Tech Stack

Tools & technologies

AzureERPETLPythonServiceNowSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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