At CDW, our purpose is to make technology work so people can do great things.
The Role
The Data Analyst designs and develops reporting and analyses for Managed Services customers, ensuring accurate and useful reporting and dashboards. Responsibilities include report generation, ad-hoc reporting, and collaborating with stakeholders to enhance data solutions.
Summary Generated by Built In
Description
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.
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/](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.
* 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. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
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.
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/](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.
* 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. CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, CDW's goal is to get to know you as an applicant and understand your experience, strengths, skills, and qualifications. While AI can help you present yourself more clearly and effectively, the essence of your application should be authentically yours. To learn more, please review [CDW's AI Applicant Notice](https://www.cdwjobs.com/pages/ai-applicant-notice).
Top Skills
Excel
MS Office
SQL
VBA
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
CDW Corporation 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. For more information about CDW, please visit www.CDW.com.
Our broad array of products and services range from hardware and software to integrated IT solutions such as security, cloud, hybrid infrastructure and digital experience.
Why Work With Us
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.
Gallery
CDW Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
CDW is committed to offering a high quality, flexible work experience centered around connection, collaboration, and coworker well-being. Our flexible hybrid approach enables coworkers to get the best of working from home and being together.
Typical time on-site:
Not Specified
