APPLICATION INSTRUCTIONS:

• CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please login to Workday to complete the internal application process. Please do not apply here, apply internally through Workday.

• CURRENT PENN STATE STUDENT (not employed previously at the university) and seeking employment with Penn State, please login to Workday to complete the student application process. Please do not apply here, apply internally through Workday.

• If you are NOT a current employee or student, please click “Apply” and complete the application process for external applicants.

Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see Notice to Out of State Applicants.

​

POSITION SPECIFICS​

The College of Medicine is seeking a Financial Business Intelligence Analyst to support the Controller’s Office by developing, maintaining, and optimizing enterprise reporting and analytics solutions focused on financial operations and labor distribution. This position serves as a technical and financial resource responsible for transforming complex institutional data into actionable reporting solutions using Power BI, SQL, and related analytics tools.

Key Responsibilities

• Design, develop, and maintain Power BI dashboards, semantic models, and visualizations supporting labor distribution, effort reporting, financial operations, and sponsored research administration.
• Develop complex DAX measures, KPIs, calculated tables, and scalable reporting solutions using business intelligence best practices.
• Build and maintain data transformation and ETL processes using Power Query, SQL, and related tools to integrate data from finance, HR, ERP, and research administration systems.
• Analyze labor and financial transactions to ensure reporting accuracy and perform reconciliations between reporting outputs and source systems, identifying and resolving discrepancies.
• Identify opportunities to automate recurring reporting processes, improve performance, and strengthen data quality and governance standards.
• Collaborate with finance, research administration, HR, faculty affairs, and departmental leadership to gather requirements and translate business needs into technical solutions.
• Apply accounting and financial systems knowledge, including general ledger structure, cost centers, debits, and credits, to support accurate reporting and analytics development.
• Perform testing, validation, and quality assurance for dashboards, reports, and datasets to ensure accuracy, consistency, and reliability.
• Provide end-user support, troubleshooting, documentation, and training related to dashboards, reporting tools, and data interpretation.
• Support data governance, security, and confidentiality requirements, including appropriate access controls and row-level security where applicable.

Qualifications

• Demonstrated experience leading or independently managing complex business intelligence solutions, including advanced data modeling, dashboard architecture, ETL developmen