Sr Financial Data Analyst FP&A (Hybrid Remote)

Full-time - Mid Level

Hybrid - Pittsburgh, PA

Hospitals

About the position

The Sr. Financial Data Analyst, FP&A 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 Finance Transformation Manager. 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
• 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 three years of related work experience required or High School Diploma/GED and five 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.