Job Summary  

The Reporting & Data Analyst designs and develops reporting & analyses to support Managed Services customers and coworkers. This role focuses on providing the best solutions through useful and accurate reporting and dashboards based on a thorough understanding of CDW data, systems, and reporting tools. 

What you will do:  

• Report Generation: Create weekly, monthly, bi-monthly, quarterly, and annual reports based on management requirements for content, frequency, and formatting.  
• Design standardized reporting formats for utilization within department, incorporating CDW system data and other practice specific requirements.  
• Perform ad-hoc reporting utilizing CDW reporting systems, based on manager and team needs.  
• Interact with business stakeholders to help identify and develop new reports or updates to existing reports which will enable the business to take a deeper look at data and increase productivity.  
• Troubleshoot and improve existing reporting and data solutions.  
• Implement and maintain testing processes to ensure data quality in reporting.  
• Perform analysis of data being shared and design solutions using best practices.  
• Lend expertise to others in the department as necessary to help resolve process or reporting issues.  
• Design and develop reporting and analytics to support the key internal clients.  
• Document and maintain Standard Operating Procedures as required.  

What we expect of you:  

• Bachelor’s degree in business, plus 3 years of experience with Microsoft Excel advanced functions to include:  formulas, V-lookups, pivot tables, and data manipulation, OR 7 years of experience with Microsoft Excel advanced functions to include: formulas, V-lookups, pivot tables, and data manipulation.  
• Experience with VBA, and/or Excel to develop analytical customer solutions.  
• Experience with MS Office applications (Word, Outlook, PowerPoint).  
• Applicants should demonstrate solid attention to detail with a penchant for accuracy. 
• Demonstrated commitment to quality, accuracy, and completeness in reporting. 
• Exceptional oral and written communication skills and the ability to deal effectively with a variety of internal customers. 
• Strong customer focus – committed to building and maintaining strong working relationships with management and staff. 
• Ability to balance multiple priorities simultaneously and adapt to the changing needs of the business while meeting deadlines, especially in a fast-paced environment. 
• Adaptable, dependable, and proactive in determining managers’ needs. 
• Excellent analytical skills. Demonstrated ability to understand data findings, draw conclusions, and develop actionable recommendations. 
• Demonstrated time management skills with the ability to meet deadlines while maintaining strong attention to detail. 
• Ability to compute, analyze and interpret complex statistical data and/or to develop forecasts and other statistical reports as needed. 
• Proven ability to shift priorities quickly. 
• Preferred qualifications, all a plus: 
• SAS, Crystal Reports, IBMi experience, Mainframe. 
• Experience with SQL, views, functions, indexes, and query tuning. 
• Working knowledge of ITS business data and processes. 
• 2 years of SQL experience to include: query writing, data extraction and manipulation. 
• Understanding a relational database. 

• Pay range: $77,725 - $108,265 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan Benefits overview: https://cdw.benefit-info.com/  Salary ranges may be subject to geographic differentials  

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