Job Description

Job Title: Financial Analyst, Senior (SQL)
Job ID: 776507
Status: Full-Time
Regular/Temporary: Regular
Hours:
Shift: Day Job
Facility:
Department: INS Payer Provider
Location: 600 Grant St, Pittsburgh PA 15219

Description

Job Summary:

Do you exemplify respect, integrity, and excellence? These values are the root of everything we do at UPMC and guide us when delivering life changing medicine to our patients! The Corporate Finance Department is looking for a Financial Analyst, Senior with a background in health care to work in their Insurance Payer Provider Group, a part of the Health Plan at UPMC.

The ideal candidate has a strong understanding of SQL language and has the ability to construct business cases based on analyses of data and data needs. The position identifies and summarizes basic characteristics in data and trends in data patterns related to clinical programs and other indicators, investigates variances and errors in data and derive solutions, and writes SQL queries to extract and manipulate data from data warehouse for use in business case and financial model analysis. If you are looking for a rewarding career in the health care industry within finance, see below!

Responsibilities:
  • Act as a mentor for Financial Analysts or administrative staff.
  • Analyze complex financial data and extract and define relevant information; interpret data for the purpose of determining past financial performance and/or to project a financial probability.
  • Develop financial reports for forecasting, trending, and results analysis.
  • Interpret financial transactions and events for users who must make economic or business decisions.
  • Perform complex statistical, cost, and financial analysis of data reported.
  • Plan and conduct complex studies to determine cost of business activities. Recommend budget adjustments, and other cost improvement measures.
  • Record, classify, and summarize financial transactions and events in accordance with generally accepted accounting principles.

Qualifications

  • Bachelors degree in finance or related business field required.  
  • Minimum of three years of related work experience required. 
  • Proficient knowledge with SQL language/coding as well as working knowledge of analytic reporting packages such as Access, Excel, SAS, or SSPS strongly preferred
  • Ability to create, transform data into analysis quality data preferred.
  • Experience in health care insurance or health care industry preferred, but those with relevant experience in other industries may be considered. 
  • Ability to develop single and multi-data sources to serve as the foundation of complicated analysis preferred.
  • Experience using Oracle, Tableau, Cognos Framework, Cognos ReportNet, Cognos Transformer, Microsoft Access, Microsoft Visual Studio, Qlik, or other relevant software packages is preferred.
  • Microsoft office with emphasis on spreadsheet application required.

Licensure, Certifications, and Clearances:


UPMC is an equal opportunity employer. Minority/Females/Veterans/Individuals with Disabilities

Salary Range: $27.43 to $46.22 / hour

Union Position: No

Apply Current Employee?

UPMC VALUES

At UPMC, our shared goal is to create a cohesive, positive, experience for our employees, patients, health plan members, and community. If you too are driven by these values, you may be a great fit at UPMC!

QUALITY & SAFETY
DIGNITY & RESPECT
CARING & LISTENING
RESPONSIBILITY & INTEGRITY
EXCELLENCE & INNOVATION

UPMC provides a total rewards package that can help you achieve the goals you have for your career and your personal life. Whether you want to learn a new skill through a training course, reach personal health and wellness targets, become more involved in your community, or follow a career path that provides you with the right experience to be successful, UPMC can help you get to where you want to be.


WORKING HERE



Now more than ever, YOU can help us shape our communities and UPMC into a better place for everyone to work, study, play, and thrive.

Learn more about working here and check out our policies and recent updates.

UPMC Health Plan Named Best Places to Work for LGBTQ Equality in 2019


UPMC Ranked #1 Best Places for Women and Diverse Managers in 2019

Share:
Talent Network