Business Intelligence Analyst

Guidehouse; McLean (VA); Hybrid; USD 98,000 - 163,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Tuition Reimbursement

Parental Leave and Adoption Assistance

Employee Referral Program

Mobility Stipend

Discretionary bonus

Job summary

Guidehouse is seeking a data analytics professional to design dashboards and analytics products for government clients, turning complex mission data into actionable insights. You will collaborate with operators and leaders to capture requirements and iterate solutions that align with mission goals.

Responsibilities include building data pipelines in Databricks, creating visualizations in Tableau/Power BI/Qlik, and documenting analytics logic for long-term maintainability, while delivering

Qualifications

• Active Secret clearance.
• Experience developing dashboards and data visualizations using Tableau, Power BI, or Qlik.
• Ability to translate stakeholder and mission requirements into technical specifications and actionable analytic products.
• Experience preparing, cleaning, integrating, and modeling data in enterprise or mission environments.
• Strong communication skills and proven ability to work closely with cross-functional technical and mission teams.
• Ability to work either on-site at a government facility in Washington, DC or Northern Virginia, or remote, depending on project needs.

Responsibilities

• Develop dashboards, analytic products, and decision-support tools that transform complex mission data into clear, actionable insights for government stakeholders.
• Engage directly with operational and leadership personnel to gather requirements, refine analytic needs, and iterate solutions to ensure mission alignment.
• Prepare, clean, integrate, and model structured and unstructured data from diverse systems to enable reliable analytics and reporting.
• Build, optimize, and sustain analytic workflows and data pipelines within Databricks (mandatory), including notebooks, delta tables, automated jobs, and transformations supporting mission operations.
• Create user-centered dashboards and visualizations using Tableau, Power BI, or Qlik (preferred for all tracks).
• Document analytic logic, workflow processes, and dashboard design decisions to support continuity and long-term maintainability.
• Conduct quality assurance, troubleshoot issues, and continuously improve analytic products based on stakeholder feedback and mission requirements.
• Provide embedded analytic support when needed, delivering rapid-turn analysis and operational insights directly within mission environments.
• Collaborate across engineering, analytics, data science, and mission support teams to ensure solutions directly contribute to program objectives.
• Support RFP-aligned technical workstreams through the development of dashboards, embedded analysis, reporting, and data-driven decision-support tools.

Skills

Dashboard development

Stakeholder engagement

Data modeling

Strong communication

Requirements gathering

Mission-domain understanding

Tools

Databricks

Tableau

Power BI

Qlik

SQL

Job description

• Develop dashboards, analytic products, and decision-support tools that transform complex mission data into clear, actionable insights for government stakeholders.
• Engage directly with operational and leadership personnel to gather requirements, refine analytic needs, and iterate solutions to ensure mission alignment.
• Prepare, clean, integrate, and model structured and unstructured data from diverse systems to enable reliable analytics and reporting.
• Build, optimize, and sustain analytic workflows and data pipelines within Databricks (mandatory), including notebooks, delta tables, automated jobs, and transformations supporting mission operations.
• Create user-centered dashboards and visualizations using Tableau, Power BI, or Qlik (preferred for all tracks).
• Document analytic logic, workflow processes, and dashboard design decisions to support continuity and long-term maintainability.
• Conduct quality assurance, troubleshoot issues, and continuously improve analytic products based on stakeholder feedback and mission requirements.
• Provide embedded analytic support when needed, delivering rapid-turn analysis and operational insights directly within mission environments.
• Collaborate across engineering, analytics, data science, and mission support teams to ensure solutions directly contribute to program objectives.
• Support RFP-aligned technical workstreams through the development of dashboards, embedded analysis, reporting, and data-driven decision-support tools.

Job Family

Travel Required

Up to 10%

Clearance Required

Active Secret

What You Will Do

• Develop dashboards, analytic products, and decision-support tools that transform complex mission data into clear, actionable insights for government stakeholders.
• Engage directly with operational and leadership personnel to gather requirements, refine analytic needs, and iterate solutions to ensure mission alignment.
• Prepare, clean, integrate, and model structured and unstructured data from diverse systems to enable reliable analytics and reporting.
• Build, optimize, and sustain analytic workflows and data pipelines within Databricks (mandatory), including notebooks, delta tables, automated jobs, and transformations supporting mission operations.
• Create user-centered dashboards and visualizations using Tableau, Power BI, or Qlik (preferred for all tracks).
• Document analytic logic, workflow processes, and dashboard design decisions to support continuity and long-term maintainability.
• Conduct quality assurance, troubleshoot issues, and continuously improve analytic products based on stakeholder feedback and mission requirements.
• Provide embedded analytic support when needed, delivering rapid-turn analysis and operational insights directly within mission environments.
• Collaborate across engineering, analytics, data science, and mission support teams to ensure solutions directly contribute to program objectives.
• Support RFP-aligned technical workstreams through the development of dashboards, embedded analysis, reporting, and data-driven decision-support tools.

What You Will Need

• Active Secret clearance
• Experience developing dashboards and data visualizations using Tableau, Power BI, or Qlik.
• Ability to translate stakeholder and mission requirements into technical specifications and actionable analytic products.
• Experience preparing, cleaning, integrating, and modeling data in enterprise or mission environments.
• Strong communication skills and proven ability to work closely with cross-functional technical and mission teams.
• Ability to work either on-site at a government facility in Washington, DC or Northern Virginia, or remote, depending on project needs.

What Would Be Nice To Have

• Experience supporting defense, readiness, operational personnel, or enterprise analytics missions.
• Familiarity with Python, SQL, or Spark for analytics development within Databricks.
• Experience supporting large-scale analytics, BI solutions, or mission decision-support systems.
• Background working with data governance, metadata management, or structured quality frameworks.
• Experience optimizing dashboards for performance, usability, accessibility, and mission relevance.
• Experience providing embedded analytic support, producing rapid-turn insights, or briefing mission leadership.

The annual salary range for this position is $98,000.00-$163,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

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.