APPLICATION INSTRUCTIONS:- CURRENT PENN STATE EMPLOYEE (faculty, staff, technical service, or student), please to complete the. 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, pleaselogin 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 .
Approval of remote and hybrid work is not guaranteed regardless of work location. For additional information on remote work at Penn State, see .
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 development, and cross-functional analytics support.
- Ability to consult with stakeholders, drive reporting improvements, and deliver scalable analytics solutions in a complex organizational environment.
Preferred Qualifications
- Experience developing dashboards and data models in Microsoft Power BI.
- Strong knowledge of SQL, Power Query, DAX, and data transformation techniques.
- Experience with financial reporting, labor reporting, reconciliation, or accounting data.
- Understanding of data governance, validation, testing, and quality assurance practices.
- Ability to communicate technical concepts clearly to non-technical stakeholders.
- Experience working in a higher education, academic medicine, healthcare, or similarly complex regulated environment.
- Knowledge of sponsored research administration, effort reporting, or related institutional reporting processes.
- Certified Public Accountant (CPA) credential or similar financial/accounting background is a plus.
This position offers a remote work arrangement which may require minimal travel to Penn State’s College of Medicine in Hershey, PA. Questions related to work arrangements should be directed to the hiring manager during the interview process.
MINIMUM EDUCATION, WORK EXPERIENCE & REQUIRED CERTIFICATIONS
Bachelor's Degree
3+ years of relevant experience; or an equivalent combination of education and experience accepted
Required Certifications:
None
BACKGROUND CHECKS/CLEARANCES
Employment with the University will require successful completion of background check(s) in accordance with University policies. Due to the financial and fiduciary responsibilities of this position, successful completion of a credit history check will be required in addition to standard background checks.
Penn State does not sponsor or take over sponsorship of a staff employment Visa. Applicants must be authorized to work in the U.S.
SALARY & BENEFITS
The salary range for this position, including all possible grades, is $81,312.00 - $122,016.00.
Salary Structure - Information on Penn State's salary structure
Penn State provides a competitive benefits package for full-time employees designed to support both personal and professional well-being. In addition to comprehensive medical, dental, and vision coverage, employees enjoy robust retirement plans and substantial paid time off which includes holidays, vacation and sick time. One of the standout benefits is the generous 75% tuition discount, available to employees as well as eligible spouses and children. For more detailed information, please visit our Benefits Page.
CAMPUS SECURITY CRIME STATISTICS
Pursuant to the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act and the Pennsylvania Act of 1988, Penn State publishes a combined Annual Security and Annual Fire Safety Report (ASR). The ASR includes crime statistics and institutional policies concerning campus security, such as those concerning alcohol and drug use, crime prevention, the reporting of crimes, sexual assault, and other matters. The ASR is available for review here.
