Senior Consultant, Data Visualization

West Monroe; Los Angeles (CA); Hybrid; USD 132,000 - 155,000; Full time

Benefits offered by this job

401k plan

Annual bonuses

Unlimited flexible time off

10 paid holidays

Employee stock ownership program

Job summary

West Monroe is seeking a Senior Consultant, Data Visualization with expertise in Power BI to turn complex data into clear, actionable insights. You will design, develop, and maintain interactive dashboards, collaborate with stakeholders to define requirements, and optimize SQL-driven data pipelines.

Require 4+ years in data visualization, advanced Power BI and Excel skills, and strong SQL. Travel 25–50% with a hybrid schedule (2x in office).

Qualifications

• 4+ years of experience in data visualization, BI, or reporting.
• Advanced Power BI experience including dashboard development and performance optimization.
• Advanced Excel skills for analyzing large datasets with complex formulas and pivot tables.
• Strong SQL skills for querying, joining, transforming, and validating data from multiple sources.
• Experience connecting and preparing data from multiple systems for reporting and visualization.
• Experience integrating AI tools into workflows to enhance productivity and insights.
• Ability to travel 25–50% and work in a hybrid office model (2x/week).
• Ability to work in the United States without sponsorship.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards, reports, and data visualizations.
• Partner with stakeholders to define reporting requirements and recommend visualization solutions.
• Write and optimize SQL queries to extract and analyze data across sources.
• Create reliable datasets from structured and unstructured data to support reporting needs.
• Manage data visualization workstreams and communicate risks and progress.
• Perform data quality checks and QA dashboards, calculations, and datasets.
• Translate complex data into intuitive visualizations and compelling data stories.
• Leverage AI tools to accelerate analysis and generate data-driven recommendations.

Skills

Power BI

Advanced Excel

SQL

Data visualization

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 Power BI 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 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 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%.
• Hybrid role: 2x per week in office
• 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 salaryrange for this role canvary based on your proximity to one of our West Monroe offices (seetable 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. Employeesare able to enrol 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 (CPA) and linked here.