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 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 .
EEO IS THE LAW
Penn State is an equal opportunity employer and is committed to providing employment opportunities to all qualified applicants without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you are unable to use our online application process due to an impairment or disability, please contact 814-865-1473.
Penn State is committed to and accountable for advancing equity, respect, and belonging. We embrace individual uniqueness, as well as a culture of belonging that supports equity initiatives, leverages the educational and institutional benefits of inclusion in society, and provides opportunities for engagement intended to help all members of the community thrive. We value belonging as a core strength and an essential element of the university’s teaching, research, and service mission.
Federal Contractors Labor Law Poster
PA State Labor Law Poster
Penn State Policies
Copyright Information
Hotlines
