The Community Health Choices (CHC) Strategic Analytics Developer, Intermediate develops data set infrastructure, communicates with regulators about data, and analyzes disparate sources to support the statewide CHC Program. This analysis supports the clinical and care management strategies by creating analysis that supports senior decision making on service coordination, provider quality, staff performance, and quality of care. The position will utilize Python, SQL, Airflow, Github, PowerBI, and Tableau; knowledge of these are preferred. This position is mostly remote. Travel to the office will be needed on a rare basis based on business needs. **Responsibilities:** + Develop data extraction and integration processes to support analysis, data science, clinical operations, and decision support activities. Map out workflows and processes to support metric development and continuous improvement efforts. + Analyze revenues, expenses, clinical metrics, and social determinants of health to identify opportunities to improve clinical and financial performance. Formulate research approaches to solve challenges, identifying the appropriate data any applying the necessary methods, then clearly communicate analysis results via high-impact written products and verbal presentation + Understand, maintain and iteratively develop existing code. Current ETL and analysis work is written with a mix of Python, R, SQL, Airflow, and within visualization programs (PowerBI/Tableau). Github is used for version control. Mastery of all of those languages is not required, but the ability to work with legacy code is essential. + The position requires the ability implement solutions, and track and monitor progress. These functions must be done while also weighing the practical considerations and potential barriers that need to be overcome in order to successfully implement new programs and processes. Perform validation and ensure quality standards for data sets created by fellow team members. + Experience using statistical software to provide descriptive statistics and linear and logistic regression techniques for understanding cost drivers. Subject matter expert in an area of CHC data and analysis. Provide technical consultation and act as reference point to peers, other business areas, senior leadership and external customers. Mentor new staff members. + Project management expertise with ability to prioritize workload and 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.)Maintain up-to-date information on status and effort related to each project. 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. Advise peers about existing programming that may be relevant to current/upcoming projects or requests. + Bachelor's degree in information systems, data management, healthcare management, business, public health, epidemiology, mathematics, statistics or public policy related field with 4 years of experience or Master's or other advanced degree with two years of experience. + Minimum of three years of work experience in information technology, healthcare, business, or research is required. + Experience in health insurance or healthcare industry is preferred, but those with relevant experience in other industries may be considered. + Experience and technical proficiency in SQL and/or SAS programming is required. + Experience with other programming languages used in data analytics (such as Python, Airflow and/or Github) is highly preferred. + Experience with extraction and manipulation of complex data sets is required. + Experience managing/preparing data sets for use in analysis, modeling, or business operations is required. + Experience with Microsoft Office products (particularly Excel) is required. + Experience with data visualization tools (such as Tableau, or PowerBI) is valuable. + Experience with geo-mapping software (such as ArcGIS) is valuable. + Intermediate-level 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. **Licensure, Certifications, and Clearances:** + Act 34 **UPMC is an Equal Opportunity Employer/Disability/Veteran**