The Data Analyst ensures the integrity, consistency and scalability of CDW’s Partner Compliance reporting and supports management’s decision making. This role designs and develops reporting, analyzes business processes and systems, and aligns projects with the executive strategy to drive improvements within CDW and with the partner community.
Key Areas of Responsibility
- Develop and manage centralized Partner Compliance reporting portfolio. Coordinate and guide stakeholders through a process of creating reports and data models that successfully address business issues. Provide ongoing support for these reports.
- Design actionable reporting tools that support effective management of data quality, open orders and other partner compliance topics.
- Produce sound analysis in support of Product and Partner Management decision makers to drive tactical and strategic departmental objectives and partnership decisions.
- Assess existing reports, data sources, business processes and initiatives. Troubleshoot data sources and address questions as identified. Find improvement opportunities and strategies to evolve the current capabilities. Facilitate effective communication with vendors including compliance audits.
- Maintain standard monthly reports and metrics used to measure partner compliance and improve overall department efficiency. Research monthly results to identify additional opportunities.
- Present findings and analysis to management and prepare associated trends and graphical illustrations.
- Conduct a variety of ad-hoc analysis based on business needs
- Establish and maintain data governance processes and strategies to minimize data integrity and business risk.
- Validate, research, and audit (external) data sources and internally develop collections to minimize data integrity risk.
- Assist with alignment of the technology solutions (Purchasing, E-commerce and Marketing) with PPM business strategies and objectives.
- Provides tactical analyses and troubleshooting of the business unit’s existing reports and data sources.
- Serve as a conduit / broker for cross-functional collaboration and knowledge sharing.
- Provide front-line application support to individual consumers of group’s work product (i.e. MS Excel and Access, Pyramid Analytics, Power BI) as needed.
- Craft and publish weekly and monthly dashboards and reports.
- Research unusual trends and provide supporting detail to management.
- Analyze the efficiency and effectiveness of programs and recommend improvements.
Education and/or Experience Qualifications
- Bachelor’s degree in Business or an IT related field and 2 years of work experience in an analytical position, OR
- HS diploma and 6 years of experience in IT, Procurement, Supply Chain, Marketing, or related field
Other Required Qualifications
- Demonstrated ability to critically evaluate information, identify risks and opportunities, while possessing creative problem-solving skills with an understanding of business concepts and models.
- Strong verbal and written communication skills with the ability to effectively interact with internal and external stakeholders
- Proficient in Microsoft Office applications, specifically Power BI or other BI tools Excellent written and verbal communication skills with the ability to effectively communicate across company and department boundaries at all levels.
- Demonstrated ability to work independently with little direction and make sound business decisions
- History of balancing multiple priorities simultaneously with the ability to quickly adapt to the changing needs of the business and meet deadlines
- Demonstrated time management skills with the ability to meet deadlines
- Working knowledge of SQL, MDX and/or other database query language(s)
- Working knowledge of AS400 or similar ERP
- Demonstrated ability to effectively facilitate and lead meetings, tailoring messages to the given audience.
- Proven ability to elicit project and system requirements.