Power BI & Program Analytics Specialist I

Guidehouse; San Antonio (TX); Hybrid; USD 70,000 - 116,000; Full time

Benefits offered by this job

Medical Insurance

401(k) Retirement Plan

Tuition Reimbursement

Employee Assistance Program

Job summary

Guidehouse is seeking a Power BI–driven Senior BI Analyst to design, develop, and maintain interactive dashboards and reporting products. You will translate complex requirements into actionable analytics and optimize data models, DAX measures, and ETL pipelines.

The role involves collaboration with program leaders and stakeholders, applying GIS and geospatial visuals, and using AI/ML to enhance analytics workflows. A US citizenship or clearance-enabled profile is preferred.

Qualifications

• Bachelor's degree in a related field; 3+ years BI/analytics experience.
• Experience in building dashboards with Power BI and translating requirements into reports.
• Strong SQL and statistical analytics knowledge; data quality focus.

Responsibilities

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

Skills

Power BI

SQL

DAX

Data Modeling

ETL/ELT

Data Visualization

Education

Bachelor's degree

Master's degree (nice to have)

Tools

Power BI Desktop

Power BI Service

Power Query (M)

Data modeling

Job description

Guidehouse is seeking a Power BI–driven Senior BI Analyst to design, develop, and maintain interactive dashboards and reporting products. You will translate complex requirements into actionable analytics and optimize data models, DAX measures, and ETL pipelines.

The role involves collaboration with program leaders and stakeholders, applying GIS and geospatial visuals, and using AI/ML to enhance analytics workflows. A US citizenship or clearance-enabled profile is preferred.