Power BI Architect for Program Analytics

Guidehouse; Charlotte (NC); On-site; USD 80,000 - 133,000; Full time

Benefits offered by this job

Medical insurance

401(k) retirement plan

Tuition reimbursement

Paid holidays

Job summary

Guidehouse is seeking a senior BI Analytics professional in the United States to design, develop, and maintain Power BI dashboards and analytics solutions. The role focuses on translating stakeholder needs into actionable reporting, building robust data models, and delivering data-driven insights across public health and government initiatives.

Responsibilities include data transformation, statistical analyses, GIS visualization, and collaboration with data stewards and program leaders.

Qualifications

• Must be able to obtain and maintain a Federal or DHS Public Trust.
• Five or more years of experience in BI, analytics, or related field.
• Experience designing and administering enterprise Power BI solutions.
• Experience with Power BI Desktop/Service, DAX optimization, Power Query, and data modeling.
• Experience leading stakeholder engagement and translating objectives into analytics.

Responsibilities

• Design, develop, and maintain interactive dashboards, reports, and visual analytics using Power BI.
• Gather and translate requirements into analytics and reporting products.
• Develop and optimize Power BI data models, semantic models, DAX measures, calculated columns, and performance-tuned reporting.
• Design and implement data transformation workflows using Power Query (M) and ETL/ELT processes.
• Conduct statistical analyses to support program evaluation and decision-making.
• Perform geospatial analysis and geographic visualization using Power BI mapping and GIS tools.
• Analyze, profile, validate, and monitor data quality for reporting accuracy.
• Collaborate with program leaders, data stewards, and stakeholders to define KPIs and reporting standards.
• Support health, government, or mission-focused analytics through data-driven insights.
• Leverage AI/ML capabilities to enhance analytics workflows and discovery.
• Develop technical documentation, data dictionaries, and reporting methodologies.
• Present findings and insights to technical and non-technical audiences.

Skills

Power BI

DAX

Power Query(M)

ETL/ELT

Data Modeling

GIS

Education

Bachelor's degree

Tools

Power BI Desktop

Power BI Service

DAX

Power Query (M)

Data modeling

ETL/ELT tools

GIS tools

Job description

Guidehouse is seeking a senior BI Analytics professional in the United States to design, develop, and maintain Power BI dashboards and analytics solutions. The role focuses on translating stakeholder needs into actionable reporting, building robust data models, and delivering data-driven insights across public health and government initiatives.

Responsibilities include data transformation, statistical analyses, GIS visualization, and collaboration with data stewards and program leaders.