Job Family:Data Science Consulting
Travel Required:Up to 10%
Clearance Required:Ability to Obtain Public Trust
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.
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 GuidehouseGuidehouse 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- or via email at 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 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 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.
