19 Nov
|
CO3000 CDW Canada
|
Toronto
19 Nov
CO3000 CDW Canada
Toronto
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 workDesign and build Power BI reports, dashboards and semantic models using strong data modelling, DAX, Power Query (M) and visualization practicesBuild and maintain data pipelines, dataflows, lakehouses and warehouses in Microsoft Fabric and Azure that integrate data from multiple sourcesConnect to APIs and business applications such as ServiceNow, Salesforce and ERP platforms, including authentication and paginationBuild well‐modelled, documented and governed data foundations that support Copilot, AI agents and other AI use casesSupport Fabric assessments across capacity, cost, governance, pipelines, Power BI and AI readiness, and document findings, quick wins and implementation plansConfigure workspaces, user access, row‐level security and governance controls in line with client policiesPrepare and facilitate Power BI and Fabric training, and create documentation and handover materials so client teams can sustain solutions after go‐liveReview delivery work from offshore teams and partners, build reusable templates and sample reports, support customer demos, and identify follow‐on opportunities to share with salesEducation and/or Experience Qualifications:Bachelor's degree in Computer Science, Information Systems, Engineering, Business Analytics, or equivalent experience2-4 years of hands‐on experience in business intelligence, analytics engineering or data engineering, ideally in a consulting or client‐facing roleStrong Power BI skills, including star‐schema modelling, DAX, Power Query (M), report design, licensing, workspaces, security and access managementProficiency in SQL, working knowledge of Python, and experience building ETL/ELT pipelines and integrating APIsAbility to articulate complex data‐related concepts clearly to both technical and non‐technical audiencesOther 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 DatabricksStrong analytical, problem‐solving, communication and presentation skills, with confidence working directly with customers and collaborating with consultants, offshore delivery teams and partnersTrack record of balancing multiple priorities and client deadlines while adapting to changing needs, with the ability to travel occasionally to client sitesNice 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 AIExperience with ServiceNow, Salesforce or ERP data sources, and familiarity with data governance and quality practices such as Microsoft Purview and sensitivity labelsExperience with Git, deployment pipelines, Azure DevOps, Power Apps or Power Automate, and the ability to communicate in English and FrenchPay range: $ 70,000- $ 96,400, depending on experience and skill setCurrent 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 integrateAI 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 UsCDW 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 cooperative 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 or any other basis prohibited by state and local law.At CDW, we make technology work so people can do great things. We are a leading multi‐brand technology solutions provider to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. Our coworkers across the globe are working together to bring technology to life for our customers by solving complicated IT business challenges, providing outstanding service, and orchestrating the technology landscape to optimize our customers' performance.
📌 Associate Consultant - Data & Analytics (Toronto)
🏢 CO3000 CDW Canada
📍 Toronto