Power BI Analytics & Visualization Specialist

Guidehouse; Huntsville (AL); On-site; USD 80,000 - 133,000; Full time

Benefits offered by this job

Medical, Rx, Dental & Vision Insurance

401(k) Retirement Plan

Paid Holidays

Job summary

Guidehouse in Huntsville, AL seeks an experienced BI/Analytics professional to design, develop, and maintain Power BI dashboards and data products. You will translate stakeholder needs into scalable analytics, build data models, and optimize performance across enterprise reporting architectures.

You will collaborate with program leaders to define KPIs, governance, and reporting standards, while conducting statistical analyses and geospatial visualization to support health and government

Qualifications

• Must be able to OBTAIN and MAINTAIN a Federal or DHS "PUBLIC TRUST".
• Bachelor's degree required.
• 5+ years of experience in BI, analytics, reporting, data visualization, public health informatics, healthcare analytics, or related field.
• Experience designing, developing, and administering enterprise Power BI solutions.
• Experience with Power BI Desktop, Power BI Service, DAX optimization, Power Query (M), data modeling, row-level security, deployment pipelines, and data gateway configuration.

Responsibilities

• Design, develop, and maintain interactive dashboards, reports, and visual analytics using Power BI.
• Translate business and stakeholder requirements into analytics and reporting products.
• Develop Power BI data models, semantic models, and performance-tuned reporting solutions.
• Create data transformation workflows with Power Query (M) and ETL/ELT processes.
• Conduct statistical analyses to support program evaluation and decision-making.
• Perform geospatial analysis and mapping using Power BI and GIS tools.
• Profile, validate, and monitor data quality for reporting accuracy.
• Collaborate with leaders and clients to define metrics, KPIs, and standards.
• Support health, government, or mission-focused analytics initiatives with data-driven insights.
• Explore AI/ML capabilities to enhance analytics workflows and discovery.
• Develop documentation such as data dictionaries, dashboards guides, and methodologies.
• Present findings to technical and non-technical audiences.

Skills

Stakeholder engagement

Statistical analysis

Data visualization

Geospatial analysis

Public health informatics

Healthcare analytics

Education

Bachelor's degree

Master's degree (nice to have)

Tools

Power BI Desktop

Power BI Service

DAX optimization

Power Query (M)

Data modeling & dimensional design

Row-level security

Deployment pipelines

Data gateway configuration

Enterprise reporting architecture

Job description

Guidehouse in Huntsville, AL seeks an experienced BI/Analytics professional to design, develop, and maintain Power BI dashboards and data products. You will translate stakeholder needs into scalable analytics, build data models, and optimize performance across enterprise reporting architectures.

You will collaborate with program leaders to define KPIs, governance, and reporting standards, while conducting statistical analyses and geospatial visualization to support health and government