Description
Do you have health care data management experience? Are you familiar with writing SQL queries? If so, UPMC may have the perfect fit for you!
UPMC Health Plan has an exciting opportunity for a full-time Business Analyst to support the Behavioral Integration department. This position will have a Monday through Friday daylight schedule. Due to COVID-19 circumstances, this position will temporarily work remotely and will likely transition to a partial office-based role in Pittsburgh.
The Business Analyst will provide SQL coding and reporting support for various UPMC programs and product lines (including Quality, Finance and Operations). The Business Analyst will take a role in the enhancement, development, documentation and communication of various processes and programmatic outcomes.
Experience with writing SQL queries and working with Power BI and/or Tableau is highly preferred. A background working with health care data is also preferred.
Responsibilities:
- Effectively prioritize and complete all assigned tasks.
- Work with users and developers to identify problems and propose solutions.
- Identify areas of concern that may compromise client satisfaction.
- Maintain employee/insured confidentiality.
- Meet deadlines and turnaround times set by managers and department director.
- Apply SQL programming to build data sets and ensure accuracy and consistency in reporting measures.
- Execute recurrent data processes and create exception reports for those recurrent processes.
- Identify, develop, and integrate new sources of data into existing databases.
- Develop validation and testing protocols to ensure accuracy and quality of final deliverables.
- Develop new reporting capabilities, reporting automation, and analytical dashboards.
- Design/update Power BI and Tableau dashboards.
- Utilize advanced Excel skills to create financial models and present analyses.
- Investigate variances and derive solutions to cost increases and quality issues.
- Perform analyses, and then explain this analysis to a non-technical audience of both internal and external customers and, at times, senior management.
- Identify trends in expenses, utilization, medical quality, and other areas.
- Manage special projects.
- Monitor business unit operating performance against benchmarks.
Qualifications
- Bachelor's degree or equivalent related work experience required.
- Minimum of two years of general business experience required.
- Minimum of two years of experience in business/industry specialty required. Knowledge of commercial, Medicaid, and Medicare products preferred.
- Competent in MS Office and PC skills preferred.
- Working knowledge of COB (Coordination of Benefits) preferred.
- Organizational, interpersonal, and communication skills required.
Licensure, Certifications, and Clearances:
UPMC is an Equal Opportunity Employer/Disability/Veteran
Total Rewards
More than just competitive pay and benefits, UPMC’s Total Rewards package cares for you in all areas of life &emdash; because we believe that you’re at your best when receiving the support you need: professional, personal, financial, and more.
Our Values
At UPMC, we’re driven by shared values that guide our work and keep us accountable to one another. Our Values of Quality & Safety, Dignity & Respect, Caring & Listening, Responsibility & Integrity, Excellence & Innovation play a vital role in creating a cohesive, positive experience for our employees, patients, health plan members, and community. Ready to join us? Apply today.
