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

CA$83,000.00–CA$93,000.00 yearly

Permanent, Full-time

This posting is for (1) current vacancies. Toronto, ON | Vancouver, BC | Ottawa, ON | Calgary, AB | Halifax, NS | St John's, NL | Kelowna, BC | Prince George, BC | Montreal, QC | Québec, QC (Detailed...)

Full-time

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

📌 Data & BI Analyst (Calgary)
🏢 Hopewell Residential
📍 Calgary