Program Analytics & Data Visualization Specialist I

• Design, develop, and maintain interactive dashboards, reports, and visual analytics solutions using Microsoft Power BI.
• Gather and translate business, operational, programmatic, and stakeholder requirements into actionable analytics and reporting products.
• Develop and optimize Power BI data models, semantic models, DAX measures, calculated columns, and performance-tuned reporting solutions.
• Design and implement data transformation workflows using Power Query (M) and related extract, transform, and load (ETL/ELT) processes.
• Conduct statistical, trend, and quantitative analyses to support program evaluation, operational decision-making, performance measurement, and reporting requirements.
• Perform geospatial analysis and geographic visualization using Power BI mapping capabilities, GIS tools, and spatial datasets.
• Analyze, profile, validate, and monitor data quality to ensure reporting accuracy, consistency, and reliability.
• Collaborate with program leaders, technical teams, data stewards, and client stakeholders to define metrics, KPIs, reporting standards, and analytical approaches.
• Support public health, healthcare, government, or mission-focused analytics initiatives through data-driven insights and visualization.
• Leverage emerging artificial intelligence and machine learning capabilities to enhance analytics workflows, reporting efficiency, data discovery, and decision support.
• Develop technical documentation, data dictionaries, dashboard user guides, and reporting methodologies.
• Present findings, recommendations, and analytical insights to technical and non-technical audiences.

• US Citizen or permanent resident; must have ability to obtain and maintain a Public Trust clearance.
• Bachelor’s degree.
• THREE (3) or more years of experience in business intelligence, analytics, reporting, data visualization, public health informatics, healthcare analytics, or a related field.
• Experience developing dashboards and reporting solutions using Microsoft Power BI.
• Experience with:
• Power BI Desktop
• Power BI Service
• DAX
• Power Query (M)
• Data modeling and semantic models
• Report and dashboard development
• Data visualization best practices
• Experience performing data analysis using SQL and/or statistical analysis tools.
• Experience working with structured and semi-structured datasets from multiple data sources.

What Would Be Nice To Have:

• Master’s degree in Public Health, Health Informatics, Data Science, Analytics, Statistics, Computer Science, Information Systems, Geography/GIS, or a related field.
• Knowledge of data governance, data quality, metadata management, and reporting standards.
• Experience eliciting business requirements and collaborating with stakeholders.
• Strong written, verbal, and presentation communication skills.
• Ability to work independently and within cross-functional teams.
• Experience supporting federal health, public health, healthcare, or government programs.
• Experience with public health informatics standards, data exchange, surveillance, epidemiology, or population health analytics.
• Experience with GIS and geospatial analytics tools such as ArcGIS, ArcGIS Online, or QGIS.
• Experience with Python, R, SAS, SPSS, or other analytical/statistical programming tools.
• Experience with cloud-based data and analytics platforms including: Databricks, Snowflake, Palantir Foundry, Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric
• Familiarity or experience with Power Platform technologies including: Power Apps, Power Automate, Power Pages, Power Virtual Agents
• Familiarity with data integration, API connectivity, and enterprise data architectures.
• Knowledge of responsible AI, AI governance, AI literacy, or AI implementation practices.
• Microsoft certifications such as: Power BI Data Analyst Associate, Fabric Analytics Engineer Associate, Azure Data Engineer Associate
• Experience supporting Agile project delivery environments.

Pulled from the full job description

• Referral program
• Tuition reimbursement
• AD&D insurance
• Parental leave
• 401(k)
• Health insurance
• Vision insurance, The annual salary range for this position is $70,000.00-$116,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
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

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.