Senior Consultant, Data Visualization

Socket.dev; Chicago (IL); On-site; USD 120,000 - 141,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

401(k) plan

Employee stock ownership program

Unlimited flexible time off

Ten paid holidays

Paid parental leave

Job summary

West Monroe is seeking a Senior Consultant, Data Visualization with expertise in Power BI to help clients turn complex data into clear, actionable insights. You will design, develop, and maintain dashboards and reports, partnering with client stakeholders to define requirements and deliver impactful visual solutions.

Proficiency in Power BI or Tableau, strong Excel and SQL skills, and experience translating business questions into visual data stories are essential.

Qualifications

• 4+ years in data visualization, BI, or related field.
• Advanced Power BI and/or Tableau: dashboards, data modeling, DAX, Power Query.
• Advanced Excel for large datasets and complex analysis.
• Strong SQL: querying, joining, transforming, and validating data.
• Experience connecting data from multiple sources for reporting.
• Understanding of data visualization principles and dashboard usability.
• Ability to translate business questions into visual stories.
• QA of data, calculations, and reporting outputs.
• Experience managing workstreams and collaborating with stakeholders.
• Experience integrating AI tools (e.g., ChatGPT) into workflows.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports.
• Partner with stakeholders to define requirements and visualize solutions.
• Use advanced Excel to model and analyze data, including pivot tables and Power Query.
• Write and optimize SQL queries across multiple sources.
• Prepare data from multiple systems for reporting and visualization.
• Lead data visualization workstreams and manage delivery with quality and risk awareness.
• Perform data quality checks on dashboards and datasets.
• Translate complex data into intuitive visual narratives for clients.

Skills

Power BI

Excel

SQL

Data Visualization

Dashboard design

Stakeholder collaboration

AI tools

Travel 25-50%

Tools

Tableau

Job description

Are you ready to make an impact?

West Monroe is seeking a Senior Consultant, Data Visualization with expertise in Power BI to help clients turn complex data into clear, actionable insights. This role combines strong data visualization expertise with hands‑on experience working with complex datasets.

What You Will Do

• Design, develop, and maintain interactive dashboards, reports, and data visualizations that translate complex information into actionable business insights.
• Partner with client stakeholders to understand business questions, define reporting requirements, and recommend effective visualization solutions.
• Use advanced Excel capabilities to analyze, model, validate, and communicate data, including complex formulas, pivot tables, Power Query, and related functionality.
• Write and optimize SQL queries to extract, transform, validate, and analyze data across multiple sources.
• Work with structured and unstructured data from multiple sources to create reliable datasets that support reporting and visualization needs.
• Manage data visualization workstreams, driving deliverables to completion while maintaining quality and communicating risks, dependencies, and progress.
• Perform data quality checks and QA dashboards, calculations, and underlying datasets to ensure accuracy and reliability.
• Collaborate with technical and business stakeholders to translate complex data and ambiguous requirements into intuitive visualizations and compelling data stories.
• Leverage AI tools to accelerate analysis, synthesize complex information, and support data‑driven recommendations for clients, exercising sound judgment in evaluating outputs.
• Apply AI technologies (e.g., generative AI, automation tools, data models) to enhance insights, improve delivery efficiency, and elevate the quality of client outcomes.

What You Will Bring

• 4+ years of experience in data visualization, business intelligence, reporting, or a related field, preferably within consulting or professional services.
• Advanced Power BI and/or Tableau experience, including dashboard development, data modeling, DAX, Power Query, visualization design, and performance optimization.
• Advanced Excel skills with the ability to efficiently analyze, manipulate, and structure large or complex datasets.
• Strong SQL skills and experience querying, joining, transforming, and validating data from multiple sources.
• Experience connecting and preparing data from multiple systems and sources for reporting and visualization.
• Strong understanding of data visualization principles, dashboard usability, and effective approaches for communicating insights to different audiences.
• Ability to translate business questions and requirements into intuitive visualizations and compelling data stories.
• Strong attention to detail and experience performing quality assurance on data, calculations, and reporting outputs.
• Experience managing workstreams and collaborating with both technical and non-technical stakeholders.
• Experience integrating AI tools (e.g., ChatGPT) into day‑to‑day workflows to enhance productivity and insight generation, coupled with strong critical thinking to assess accuracy, mitigate bias, and ensure high‑quality outputs.
• Ability to travel 25 to 50%.
• A commitment to inclusion and diversity, and openness to new ideas and perspectives.
• Ability to work permanently in the United States without sponsorship.

Based on pay transparency guidelines, the salary range for this role can vary based on your proximity to one of our West Monroe offices (see table below). Information on our competitive total rewards package, including our bonus structure and benefits is here. Individual salaries are determined by evaluating a variety of factors including geography, experience, skills, education, and internal equity. Employees (and their families) are covered by medical, dental, vision, and basic life insurance. Employees are able to enroll in our company’s 401k plan, purchase shares from our employee stock ownership program and be eligible to receive annual bonuses. Employees will also receive unlimited flexible time off and ten paid holidays throughout the calendar year. Eligibility for ten weeks of paid parental leave will also be available upon hire date.

Seattle or Washington, D.C. — $125,500 — $147,600 USD

Los Angeles — $131,500 — $154,700 USD

New York City or San Francisco — $137,400 — $161,700 USD

A location not listed above — $119,500 — $140,600 USD

Other consultancies talk at you.At West Monroe, we work with you.

We’re a global business and technology consulting firm passionate about creating measurable value for our clients, delivering real-world solutions.

The combination of business and technology is not new, but how we bring them together is unique. We’re fluent in both. We know that technology alone is not the answer, but how we apply it is. We rely on data to constantly adapt and solve new challenges. Actions that work today with outcomes that generate value for years to come.

At West Monroe, we zero in on the heart of the opportunity, getting to results faster and preparing people for what’s next.

You’ll feel the difference in how we work. We show up personally. We’re right there in the room with you, co‑creating through the challenges. With West Monroe, collaboration isn’t a lofty promise, but a daily action. We work together with you to turn vision into clear action with lasting impact.

West Monroe is an Equal Employment Opportunity Employer. We believe in treating each employee and applicant for employment fairly and with dignity. We base our employment decisions on merit, experience, and potential, without regard to race, color, national origin, sex, sexual orientation, gender identity, marital status, age, religion, disability, veteran status, or any other characteristic prohibited by federal, state or local law. To learn more about diversity, equity and inclusion at West Monroe, visit www.westmonroe.com/inclusion. If you require a reasonable accommodation to participate in our recruiting process, please inquire by sending an email to [e-mail].

Please review our current policy regarding use of generative artificial intelligence during the application process.

If you are based in California, we encourage you to read West Monroe’s Notice at Collection for California residents, provided pursuant to the California Consumer Privacy Act (CCPA) and linked here.