Data Analyst / Visualization Consultant

Guidehouse; McLean (VA); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

Holidays and Paid Time Off

Discretionary Bonus

Parental Leave and Adoption Assistance

401(k) Retirement Plan

Student Loan PayDown

Tuition Reimbursement

Mobility Stipend

Job summary

Guidehouse is seeking a Data Analyst / Visualization Consultant to transform complex data into actionable insights for programs and policies. You will build dashboards and automate workflows, using Power BI, Tableau, and the Power Platform, to improve data collection, analysis, and communication for stakeholders.

You will collect and analyze data from multiple sources, identify trends and data-quality issues, and present findings to technical and non-technical audiences while collaborating with

Qualifications

• Bachelor’s degree required.
• 1+ years of data analysis, reporting, BI, data visualization, automation, or app development.
• Experience creating dashboards or visualizations using Power BI or Tableau.
• Experience building workflow apps/automations with Microsoft Power Platform (Power Apps/Power Automate).
• Ability to work in a client-facing consulting environment.

Responsibilities

• Collect, clean, validate, and analyze data from multiple sources.
• Develop and maintain dashboards and data visualizations with Power BI and Tableau.
• Design and develop workflow applications and automated processes using Power Platform (Power Apps, Power Automate).
• Identify opportunities to streamline manual processes through automation.
• Translate business needs into analytical, reporting, and workflow requirements.

Skills

Data analysis

Reporting

Business intelligence

Automation

Education

Bachelor’s degree

Tools

Power BI

Tableau

Power Apps

Power Automate

Power Query

SQL

Excel

Job description

What You Will Do

As a Data Analyst / Visualization Consultant, you will help transform complex operational and infrastructure data into meaningful insights that inform programs, policies, and performance decisions. You will work on high-visibility initiatives, using modern analytics, visualization, and automation tools to improve how data is collected, analyzed, communicated, and acted upon. This role offers the opportunity to build practical solutions that make information easier to understand, streamline manual processes, and deliver measurable value for stakeholders.

• Collect, clean, validate, and analyze data from multiple sources.
• Develop and maintain dashboards, reports, and data visualizations using tools such as Power BI and Tableau.
• Design and develop workflow applications and automated processes using Microsoft Power Platform, including Power Apps and Power Automate.
• Identify opportunities to streamline manual processes through automation.
• Translate business needs into analytical, reporting, and workflow requirements.
• Test, troubleshoot, document, and maintain dashboards, applications, and automated workflows.
• Identify trends, patterns, anomalies, and data-quality issues.
• Communicate findings to technical and non-technical audiences.
• Collaborate with stakeholders and multidisciplinary project teams.

Job Family

Data Science Consulting

Travel Required

Up to 25%

Clearance Required

Ability to Obtain Public Trust

What You Will Do

As a Data Analyst / Visualization Consultant, you will help transform complex operational and infrastructure data into meaningful insights that inform programs, policies, and performance decisions. You will work on high-visibility initiatives, using modern analytics, visualization, and automation tools to improve how data is collected, analyzed, communicated, and acted upon. This role offers the opportunity to build practical solutions that make information easier to understand, streamline manual processes, and deliver measurable value for stakeholders.

• Collect, clean, validate, and analyze data from multiple sources.
• Develop and maintain dashboards, reports, and data visualizations using tools such as Power BI and Tableau.
• Design and develop workflow applications and automated processes using Microsoft Power Platform, including Power Apps and Power Automate.
• Identify opportunities to streamline manual processes through automation.
• Translate business needs into analytical, reporting, and workflow requirements.
• Test, troubleshoot, document, and maintain dashboards, applications, and automated workflows.
• Identify trends, patterns, anomalies, and data-quality issues.
• Communicate findings to technical and non-technical audiences.
• Collaborate with stakeholders and multidisciplinary project teams.

What You Will Need

• Must be able to OBTAIN and MAINTAIN a Federal or DHS "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
• Bachelor’s degree
• One (1) or more years of experience in data analysis, reporting, business intelligence, data visualization, automation, or application development.
• Experience developing dashboards or visualizations using Power BI, Tableau, or similar tools.
• Experience developing workflow applications and automations using Microsoft Power Platform, including Power Apps and Power Automate.
• Ability to work collaboratively in a client-facing consulting environment.

What Would Be Nice To Have

• Experience with SQL, Excel, Power Query, or other data preparation tools.
• Working knowledge of data preparation, validation, analysis, visualization, and workflow design.
• Ability to translate business requirements into dashboards, applications, or automated workflows.
• Strong analytical, problem-solving, organizational, and communication skills.
• Experience developing interactive dashboards and performance reports.
• Familiarity with financial, operational, infrastructure, or performance data.
• Experience supporting public-sector organizations.
• Familiarity with data-quality checks and repeatable reporting processes.
• Experience working in an Agile or iterative delivery environment.

What We Offer

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits Include

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend

About Guidehouse

Guidehouse is an Equal Opportunity Employer–Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at [e-mail]. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or [e-mail]. Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process. If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline. If you want to check the validity of correspondence you have received, please contact [e-mail]. Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.