Data Analyst Mgd Svc

CDW • Full-time • Hybrid in Vernon Hills, Illinois, United States • $77,725 - $108,265 / year • 2d ago

Fast Facts

Join CDW as a Data Analyst where you'll design and develop reporting and analytics to support Managed Services customers, using your expertise in data systems and Microsoft Excel to deliver actionable insights.

Responsibilities: Key responsibilities include generating and troubleshooting reports, designing standardized reporting formats, performing data analysis, and documenting procedures.

Skills: Proficient in Microsoft Excel (including formulas, pivot tables, and V-lookups), analytical skills, and strong communication abilities are essential.

Qualifications: Bachelor's degree in business or equivalent experience with advanced Excel functions; SQL experience is a plus.

Location: This position is based in Vernon Hills, Illinois, United States.

Compensation: $77725 - $108265 / Annually

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/ Salary ranges may be subject to geographic differentials

CDW is committed to being an AI-fluent organization
We’relooking 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—notreplaces—human creativity and decision-making. Youdon’tneed 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.