Associate Consultant - Data & Analytics

CDW; Calgary; On-site; CAD 70,000 - 100,000; Full time

Job summary

CDW seeks an Associate Consultant, Data & Analytics to help clients turn data into AI-ready insights. You’ll build Power BI reports and semantic models, and develop data pipelines in Microsoft Fabric and Azure while collaborating with consultants on client engagements.

The role emphasizes hands-on data construction, client interaction, and governance. You’ll train teams, document processes, and enable Copilot and AI initiatives for business outcomes.

Qualifications

• Bachelor’s degree in CS/IS/Engineering/Analytics or equivalent experience.
• 2-4 years in BI, analytics engineering, or data engineering, client-facing.
• Strong Power BI skills: star-schema, DAX, Power Query, report design, security.
• Proficient in SQL, Python, and ETL/ELT with API integrations.
• Ability to clearly articulate data concepts to technical and non-technical stakeholders.

Responsibilities

• Engage with clients to translate business needs into technical requirements and scopes.
• Design and build Power BI reports, dashboards, and semantic models with strong modelling.
• Build data pipelines and dataflows in Fabric and Azure integrating multiple sources.
• Connect to APIs and business apps like ServiceNow, Salesforce, and ERP platforms.
• Develop well-governed data foundations to support Copilot and AI use cases.
• Support Fabric assessments on capacity, cost, governance, and AI readiness; document findings.
• Configure workspaces, access, and row-level security per client policies.
• Prepare training and handover materials for client teams post go-live.
• Review offshore delivery, create reusable templates, support demos, and identify follow-ons.

Skills

Power BI

DAX

Power Query

Data modelling

SQL

Python

ETL/ELT pipelines

APIs

Microsoft Fabric

Education

Bachelor’s degree

Tools

Azure

ServiceNow

Salesforce

ERP platforms

Job description

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