Associate Consultant

At CDW, we make it happen, together. Trust, connection, and commitment are at the heart of how we work together to deliver for our customers. It's why we're coworkers, not just employees. Coworkers who genuinely believe in supporting our customers and one another. We collectively forge our path forward with a level of commitment that speaks to who we are and where we're headed. We're proud to share our story and Make Amazing Happen at CDW.

Position: Associate Consultant
Experience: 2 – 4 years
Employment Type: Full-time

Role Overview

We are seeking an experienced Analytics Consultant with a strong background in designing, developing, and delivering enterprise Dynamics and Power Platform-based BI and automation solutions. The ideal candidate will have hands-on expertise in Microsoft Dynamics, CoPilot Studio, Power Pages, Power Apps, Power Automate, Dataverse, SQL, and SharePoint, with exposure to Azure cloud services.
The consultant will be responsible for transforming business requirements into actionable insights, building automation frameworks, and enabling self-service analytics across business units.

Key Responsibilities

• Design, develop, and deploy end-to-end business solutions leveraging Microsoft Dynamics and CoPilot Studio for enhanced automation and intelligence.
• Develop, customize, and manage Power Pages, Power Apps, and Power Automate solutions integrated with SharePoint, Dataverse, and SQL.
• Build and maintain data models, ETL pipelines, and optimized SQL queries for data extraction and transformation.
• Implement automation workflows for approvals, notifications, and reporting using Power Automate and CoPilot Studio.
• Collaborate with business stakeholders and cross-functional teams to understand requirements and translate them into effective data-driven solutions.
• Ensure performance optimization, data accuracy, and visualization best practices in dashboards and reports.
• Manage deployment, data refreshes, and alert mechanisms for cloud-based BI and automation solutions.
• Conduct training and enablement sessions to promote self-service analytics and user adoption.

Required Skills & Experience

• 2+ years of experience in Analytics, BI development, or Consulting.
• Strong hands-on expertise in:
  • Microsoft Dynamics 365 (CRM/ERP modules)
  • CoPilot Studio
  • Power Pages, Dataverse, SQL, and SharePoint
• Proven experience integrating Dynamics and Power Platform with Azure or other cloud ecosystems.
• Deep understanding of data modeling, ETL processes, and performance tuning.
• Strong analytical, problem-solving, and client communication skills.

Good-to-Have Skills

• Proficiency in Power BI and Power Platform (Power Apps, Power Automate) for business intelligence and process automation.
• Exposure to Microsoft CoPilot for workflow enhancements and AI-driven automation.
• Experience in Azure Data Services or Google BigQuery integrations.

Preferred Qualifications

• Microsoft Certifications such as PL-100, PL-200, PL-300, or MB-910/MB-920.
• Experience in retail, pharmaceutical, or insurance domains.
• Experience working in Agile or Scrum-based delivery environments.

We make technology work so people can do great things.     

CDW is a leading multi-brand provider of information technology solutions to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. A Fortune 500 company and member of the S&P 500 Index, CDW helps its customers to navigate an increasingly complex IT market and maximize return on their technology investments. Together, we unite. Together, we win. Together, we thrive.

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.