Analytics Data Integration Developer Senior

UPMC Health Plan is hiring a full-time Senior Analytics Data Integration Developer to join the Medicare/SNP Stars Team. This is a remote position working Monday through Friday. Candidates must be available during core business hours, with required availability from 9:00 a.m. to 4:00 p.m. EST.

The ideal candidate will have a strong background in data engineering, including advanced SQL skills and experience working with Snowflake, or Databricks. Success in this role requires the ability to compile, integrate, and analyze large, complex datasets from multiple sources while ensuring data accuracy, quality, and integrity.

The Analytics Data Integration Developer Senior creates highly complex programming, data set infrastructure, and other advanced technical processes to integrate healthcare data elements from disparate sources throughout the UPMC enterprise. This integration results in a layer of information that fuels health economics activities including strategic analysis, predictive modeling, and clinical program evaluation.

Must be legally authorized to work in the United States, without requiring, now or in the future, sponsorship for employment visa status. UPMC does not participate in STEM OPT.

Responsibilities

• Investigate data errors/variances and derive solutions with appropriate follow-up monitoring.
• Make recommendations for optimal data extraction, manipulation, and integration methodologies based upon research and analysis.
• Maintain up-to-date information on status and effort related to each project.
• Maintain policies and procedures of the team/department. Assist team leadership with distribution and monitoring of work assignments.
• Develop high-complexity integrated data sets to support analysis, data science, clinical operations, and decision support activities.
• Coordinate ongoing communication with other departments in order to manage information integrity and maintain cross-department processes.
• Perform validation and ensure quality standards for high-complexity data sets created by fellow team members.
• Assist with orientation and process-specific training of new staff members.
• Provide technical consultation and act as reference point to peers, other business areas, senior leadership and external customers.
• Adopt and promote best practices, tools, and methods set by team/department leadership.
• Develop and maintain working relationships with internal UPMC health Plan departments, and external contacts as appropriate.
• Meet deadlines and turnaround times set by supervisor. (These deadlines will, at times, require the employee to work until the project is completed, meaning extended daily work hours, extended work weeks, or both.)
• Bachelor's degree in information systems, data management, healthcare management, business, or related field.
• Master's or other advanced degree is a bonus.
• Minimum of five years of work experience in information technology, healthcare, business, or research is required.
• Demonstrated experience compiling, transforming, and managing large datasets from multiple sources strongly preferred.
• Experience and high technical proficiency in SQL strongly preferred.
• Experience and high technical proficiency in Snowflake or Databricks strongly preferred.
• Experience in data engineering strongly preferred.
• Experience building efficient data structures strongly preferred.
• Experience in health insurance or healthcare industry is preferred, but those with relevant experience in other industries may be considered.
• Extensive experience managing/preparing data sets for use in analysis, modeling, or business operations is required.
• Experience with Microsoft Office products (particularly Excel) is required.
• Advanced problem-solving skills are required.
• The ability to effectively communicate issues and results, verbally and in writing, is required.
• The ability to use effective time management skills, including prioritization multiple tasks, is necessary for success.
• Attention to detail is critically important in this role.
• Ability to succeed in a fast-paced, ambiguous/fluid environment.
• A strong customer/stakeholder focus is expected at all times.
• Ability to work extra hours if required.

Licensure, Certifications, and Clearances

UPMC is an Equal Opportunity Employer/Disability/Veteran