Financial Data Analyst, FP&A Expert (Hybrid Remote)

Full-time - Mid Level

Hybrid - Pittsburgh, PA

Hospitals

About the position

The Financial Data Analyst, FP&A Expert role designs, analyzes and presents analytical solutions to multidisciplinary teams including but not limited to physicians, administrators and organizational leaders. The position requires a high degree of technical competence, and the ideal candidate will have significant experience in SQL and/or Business Intelligence software such as Power BI, Qlik or Tableau. The role will support analyzing complex financial and clinical data to design automated reporting solutions based on direction from senior leadership. The position will support advancing our budgeting/forecasting process, KPI development and correlating financial and clinical data to design volume-based financial impacts. Communication skills with stakeholders and the ability to interpret complex data with tight deadlines will be paramount. Various clinical and financial systems will be used as the data sources, including but not limited to Epic, PeopleSoft and various external systems. Final aggregation and presentation will be completed through various software packages, including SQL Developer, SSMS, Power BI and Qlik. The analyst must ensure reporting logic is accurate and optimized by comparing analytical output to data within the source systems, as well as through cross validation to base reports under the direction of the Director of Finance. The analyst must be able to work both independently as well as in a team setting. The position is a flexible hybrid role with some in-person presence required.

Responsibilities

• Analysis of complex financial data for the purpose of determining past financial performance and/or to project a financial probability
• Perform complex statistical, cost and financial analysis on reported and forecasted results
• Development of reporting and interpretation of financial and clinical reports to identify trends and review analytical outcomes with both financial and non-financial audiences
• Development/Enhancement of system-wide KPI's for volume and financial based metrics
• Role is heavily project-based that necessitates both an individual and team structure including development of presentations to executive leadership
• Serve as a leader/mentor in the analytics space across the finance department including education, training, and use of best practices
• Perform under tight deadlines. Communicate and interact with varying levels of UPMC personnel, including executive management, on a consistent basis. Manage certain key reports provided to senior management.

Requirements

• Bachelor's degree in finance, Mathematics, Statistics, Economics, Data Analytics or related business field required.
• Minimum of five years of related work experience required.
• A Master's degree or CPA license and four years of experience will also be considered.
• High School Diploma/GED and seven years of related work experience.
• Proficiency in Oracle/SQL and Business Intelligence software required.
• Demonstrated expertise in forecasting financial operations and budgeting experience required.
• Ability to interact effectively with executives and business unit management required.
• Excellent oral and written communications and time management skills are required.
• Strong analytical ability and knowledge of accounting and financial reporting matters required.
• Microsoft Excel, Word and PowerPoint proficiency required.

Nice-to-haves

• CPA/MBA preferred
• Prior experience leading/supervising staff preferred.
• PeopleSoft General Ledger proficiency preferred.
• Knowledge of system operations preferred.
• Successful completion of UPMC's Finance Management Rotation Program preferred.