Financial BI Analyst: Power BI, SQL & Analytics

The Pennsylvania State University; Hershey (PA); On-site; USD 81,000 - 122,000; Full time

Benefits offered by this job

75% tuition discount

Job summary

The Pennsylvania State University is seeking a Financial Business Intelligence Analyst to support the Controller's Office. You will develop, maintain, and optimize enterprise reporting and analytics focused on financial operations and labor distribution using Power BI, SQL, and related tools.

Responsibilities include designing dashboards, crafting DAX measures, ETL processes, and collaborating with finance, HR, and research administration teams to transform data into actionable insights.

Qualifications

• Bachelor's Degree required; 3+ years of relevant experience or equivalent combination of education and experience.

Responsibilities

• Design, develop, and maintain Power BI dashboards and semantic models for labor distribution, effort reporting, financial operations, and sponsored research administration.
• Develop complex DAX measures, KPIs, calculated tables, and scalable reporting solutions.
• Build and maintain data transformation and ETL processes using Power Query and SQL to integrate data from finance, HR, ERP, and research systems.
• Analyze labor and financial transactions to ensure reporting accuracy and reconcile outputs with source systems.

Skills

Power BI

SQL

Data Modeling

ETL

DAX

Education

Bachelor's Degree

Tools

Power Query

SQL Server

Job description

The Pennsylvania State University is seeking a Financial Business Intelligence Analyst to support the Controller's Office. You will develop, maintain, and optimize enterprise reporting and analytics focused on financial operations and labor distribution using Power BI, SQL, and related tools.

Responsibilities include designing dashboards, crafting DAX measures, ETL processes, and collaborating with finance, HR, and research administration teams to transform data into actionable insights.