Data Analyst Mgd Svc

CDW

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.