Data Visualization Specialist

Data Science Consulting

Up to 10%

Ability to Obtain Public Trust

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.

• 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.

• 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.

• 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.

• Work closely with federal program managers, analysts, and the Link Visum project team.
• Train end users on dashboards and self-service reporting.
• Support data governance, security, and privacy requirements, including handling of PII.

• 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.

• 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.

Compensation decisions depend on a wide range of factors, including but…