Job Family:
Data Science Consulting
Travel Required:
Clearance Required:
What You Will Do:
The analyst will turn complex, multi-source data into clear dashboards and reports that inform agency leadership decisions. The ideal candidate brings extensive, hands-on expertise in both Tableau and Microsoft Power BI.
Key Responsibilities:
Data aggregation
- Collect, integrate, and consolidate data from multiple agency systems, databases, spreadsheets, and external sources.
- Build and maintain data pipelines, extracts, and data models that feed reporting tools.
- Perform data cleansing, validation, and quality checks to ensure accuracy and consistency.
- Document data sources, definitions, lineage, and business rules.
Data analytics
- Analyze large, complex datasets to identify trends, patterns, gaps, and performance drivers.
- Develop metrics, KPIs, and performance measures aligned with agency mission and strategic goals.
- Apply descriptive and diagnostic analysis, and support forecasting where appropriate.
- Translate analytical findings into clear, actionable insights for technical and non-technical audiences.
Data visualization
- Design, build, and maintain interactive dashboards and reports in Tableau and Microsoft Power BI.
- Gather requirements from agency stakeholders and convert them into intuitive visual products.
- Apply data visualization best practices and Section 508 accessibility standards.
- Optimize dashboard performance, manage workbooks and datasets, and administer publishing on Tableau Server/Cloud and the Power BI Service.
- Brief findings to agency leadership and produce executive-level presentations.
Client support
- Work closely with federal program managers, analysts, and the LinkVisum project team.
- Train end users on dashboards and self-service reporting.
- Support data governance, security, and privacy requirements, including handling of PII.
What You Will Need:
- Must be able to OBTAIN and MAINTAIN a Federal or DoD "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 in Data Analytics, Statistics, Computer Science, Information Systems, Mathematics, or a related field; FOUR (4) additional years of data analysis, business intelligence, or data visualization can be used in lieu of degree.
- FIVE (5) or more years of experience in data analysis, business intelligence, or data visualization. Experience should include:
- Extensive, hands-on expertise in Tableau (Desktop, Prep, and Server/Cloud), including calculated fields, LOD expressions, parameters, actions, and dashboard design.
- Extensive, hands-on expertise in Microsoft Power BI (Desktop and Service), including Power Query, DAX, data modeling, row-level security, and workspace management.
- Strong SQL skills for querying, joining, and transforming data from relational databases.
- Advanced Microsoft Excel skills.
- Proven ability to aggregate and reconcile data from disparate sources.
What Will Be Nice to Have:
- Active Public Trust or Secret clearance.
- Prior experience supporting a federal agency, preferably in human capital, workforce, or operational performance analytics.
- Tableau certification (Tableau Desktop Specialist, Certified Data Analyst) and/or Microsoft Certified: Power BI Data Analyst Associate.
- Experience with Python or R for data preparation and analysis.
- Familiarity with cloud data platforms such as Azure, AWS, Databricks, or Snowflake.
- Knowledge of federal data standards, the Evidence Act, and Section 508 compliance.
- Experience working in an Agile 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 [email protected]. 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 [email protected]. 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 [email protected]. 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.
Skills Required
- Ability to obtain and maintain Federal or DoD Public Trust clearance
- Bachelor's degree in Data Analytics, Statistics, Computer Science, Information Systems, Mathematics, or a related field, or four additional years of relevant experience in lieu of degree
- Five or more years of experience in data analysis, business intelligence, or data visualization
- Extensive hands-on expertise in Tableau Desktop, Prep, and Server or Cloud, including calculated fields, LOD expressions, parameters, actions, and dashboard design
- Extensive hands-on expertise in Microsoft Power BI Desktop and Service, including Power Query, DAX, data modeling, row-level security, and workspace management
- Strong SQL skills for querying, joining, and transforming relational database data
- Advanced Microsoft Excel skills
- Proven ability to aggregate and reconcile data from disparate sources
- Active Public Trust or Secret clearance
- Prior experience supporting a federal agency, preferably in human capital, workforce, or operational performance analytics
- Tableau certification and/or Microsoft Certified Power BI Data Analyst Associate certification
- Experience with Python or R for data preparation and analysis
- Familiarity with Azure, AWS, Databricks, or Snowflake
- Knowledge of federal data standards, the Evidence Act, and Section 508 compliance
- Experience working in an Agile environment
Guidehouse Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Guidehouse and has not been reviewed or approved by Guidehouse.
-
Healthcare Strength — Feedback suggests the benefits package includes broad medical, dental, vision, prescription, life, and disability coverage, which is often seen as a strong foundational offering. Access to HSA/FSA options further supports day-to-day healthcare and dependent-care needs.
-
Parental & Family Support — Feedback suggests parental leave and adoption assistance are available, alongside an emergency back-up childcare program. These offerings indicate meaningful support for employees managing family responsibilities.
-
Wellbeing & Lifestyle Benefits — Feedback suggests flexible work options and counseling/EAP-style support are part of the broader rewards mix. Additional lifestyle-oriented perks like community events and referral programs are also described as available in some contexts.
Guidehouse Insights
What We Do
Guidehouse is a leading global provider of consulting services to the public sector and commercial markets, with broad capabilities in management, technology, and risk consulting. By combining our public and private sector expertise, we help clients address their most complex challenges and navigate significant regulatory pressures focusing on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that help our clients outwit complexity and position them for future growth and success. The company has more than 12,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies.
