Jobs › CDW

This position has closed. CDW removed this listing from their careers page on Oct 6, 2026. The interview prep below is still useful, and there are similar open roles at the bottom of this page.

Associate Analyst

CDW · Chicago, IL · Full time

Posted Sep 24, 2026 · We last checked this listing on Oct 4, 2026

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a dashboard you built or maintained. Who used it and what decisions did it support?

What they are checking: Whether they have built recurring reporting that people relied on, not just one-off charts.

Tell me about a time you found something in the data that surprised your stakeholders.

What they are checking: Whether they go beyond reporting numbers to surfacing insights and opportunities.

What would you do

You get three ad-hoc data requests in one afternoon, each marked urgent. How do you handle them?

What they are checking: Whether they can prioritize and communicate turnaround times instead of quietly falling behind.

A stakeholder's numbers do not match yours. How do you work it out?

What they are checking: Whether they trace definitions and sources calmly rather than assuming who is wrong.

About the work

How do you make sure a weekly or monthly report is accurate before it goes out?

What they are checking: Whether they have checks in place, since wrong numbers in recurring reports damage trust quickly.

What does data hygiene mean to you, and how would you keep data clean across internal and external sources?

What they are checking: Whether they understand deduplication, consistent definitions and validation across data sources.

What SQL, Excel or BI tools are you comfortable with, and how have you used them?

What they are checking: Whether they have the hands-on skills to pull and shape data for insights work.

This role supports a Voice of the Customer and Customer Lifetime Value program with a research partner. How would you approach analyzing customer survey results?

What they are checking: Whether they can connect survey feedback with behavior data to find meaningful patterns.

How would you explain customer lifetime value to someone in marketing who has never heard the term?

What they are checking: Whether they understand the concept well enough to explain it simply.

How would you help automate a manual report?

What they are checking: Whether they think about moving recurring work into a BI environment to save time and reduce errors.

Practice this interview out loud.

Offer builds a real interview for this exact role at CDW from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by CDW.

Job Summary: The Associate Analyst, Marketing Analytics & Insights supports data analysis and insights-based reporting that optimizes multi-channel marketing campaigns and deepens CDW's understanding of its customers. The analyst works with analytics stakeholders, eCommerce stakeholders, and the broader Marketing department to identify data-driven insights and surface areas of opportunity. The role exists to take on the recurring, high-volume Insights work: building and refreshing the Insights dashboards, maintaining data hygiene across internal and external sources, and turning around ad-hoc data requests from stakeholders. A core part of the role is hands-on support for CDW's new Voice of the Customer (VoC) and Customer Lifetime Value program, delivered alongside research partner Ipsos. What You Will Do: Insights Reporting and Dashboards • Build, refresh, and maintain the Insights dashboards so recurring reporting is delivered accurately and on time. • Project-own the standardized reporting cadence, including weekly, monthly, quarterly, and annual performance reporting. • Assist in implementation of reporting in an automated business intelligence environment. • Maintain external and internal data hygiene across new and existing data sources. • Turn around ad-hoc data pull requests from stakeholders across the business. Voice of the Customer and CLV Program Support • Provide hands-on support for the Voice of the Customer (VoC) and Customer Lifetime Value program alongside research partner Ipsos. • Gather and organize existing feedback sources from across the business, including NPS, CSAT, CES, and Customer Advisory Board inputs, for use by the Ipsos team. • Track deliverables and action items against the phased statement of work. • Coordinate working sessions and capture notes, decisions, and follow-ups. • Monitor survey fielding and response rates, flagging issues that put timelines at risk. • Clean and consolidate incoming feedback data across sources. • Prepare the recurring VoC reports and dashboards stakeholders rely on as the engagement moves into the embed phase. Data Analysis and Stakeholder Support • Utilize database querying, data manipulation, and statistical analysis to provide business support to Marketing. • Manipulate data in a SAS, SQL, and Hadoop environment to create actionable insights aligned to business objectives. • Support the leveraging of marketing channel and advanced customer analytics to assess and make strategic recommendations that improve company performance. • Accurately differentiate the contributing marketing signals from the noise in evaluation of multi-channel campaign analytics. • Assist in finding insights and creating recommendations that can be understood by a broad audience. • Partner with marketing analytics to help implement a data-driven culture focused on continually improving the understanding of the customer. • Establish and maintain strong relationships with key stakeholders in Marketing and eCommerce to drive actionable insights. • Help support the evaluation of ongoing analytics and insights needs from stakeholders. Intake, Triage, and Knowledge Management • Serve as the first point of contact for intake and triage of incoming ad-hoc requests, ensuring nothing slips during peak periods. • Prioritize and route incoming requests against the standing reporting calendar, escalating capacity constraints early. • Manage and maintain the Insights Knowledge Library, keeping documentation, definitions, and source materials current. What We Expect of You: • Bachelor's degree in business, information systems, statistics, mathematics, economics, computer science, or engineering. • CDW Summer Internship experience • Proficient with Microsoft Office, including Excel, Word, Outlook, and PowerPoint. • Strong analytical skills and the ability to problem solve independently, analyzing large volumes of raw data, drawing conclusions, and developing actionable recommendations. • Highly detail oriented, with the ability to handle multiple projects simultaneously in a fast-paced environment. • Excellent written and verbal communication skills, with the ability to interact with and present to all stakeholders. • Proven ability to identify areas of opportunity in existing practices and processes and execute appropriate improvements. • History of balancing multiple priorities simultaneously, adapting to the changing needs of the business while meeting deadlines. • Experience working with customer feedback or survey data, such as NPS, CSAT, or CES, a strong plus. • Experience supporting a third-party research or vendor engagement, including tracking deliverables against a statement of work, a plus. • Tableau experience a strong plus. • Relational database experience, such as SQL, a strong plus. 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. Additionally, CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, our goal is to understand your experience, strengths, skills, and qualifications. As an AI forward company, we see AI not just as a tool, but as a catalyst for new ways of thinking, creating, and communicating. We encourage candidates to embrace an AI mindset, one that’s curious, adaptive, and ready to explore what’s possible. We welcome thoughtful use of AI to expand your perspective and elevate how you share your story, while ensuring your application remains rooted in your own background, judgment, and voice. About Us CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology. What makes CDW different isn’t just what we do—it’s how we do it. At CDW we act as one—building trust, speaking candidly, and working together to achieve more. We play to win—focusing on what matters most and delivering for our customers. And we think forward—staying curious, moving fast, and continuously learning. We believe meaningful work happens when people feel supported, heard, and empowered to contribute. That’s why we think of ourselves as coworkers, not just employees—working together to solve complex challenges and deliver real impact for our customers and communities. As a full‑stack, full‑lifecycle technology partner, CDW brings deep expertise, strong relationships, and broad industry knowledge to help turn ideas into outcomes. When you join CDW, you become part of a collaborative environment where your work matters, your growth is supported, and your contributions help shape what’s next. Together, we deliver the full promise of what technology can do. Together, we Make Amazing Happen. 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.