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
