The Data Analyst will lead and perform complex analysis in an evolving data environment. In addition to very strong technical skills, this position will have superb business process analysis and interpersonal skills. The ability to extract and analyze data, patterns, and related trends is needed, with the subsequent ability to query and synthesize the data into information consumable by senior business decision makers. In this role, you will analyze and visualize data on a project basis to enhance operational efficiency for healthcare supply chain organizations. Responsible for the full lifecycle of analytic activities to include: requirements gathering and data designs, development of analytic tools and reporting capabilities, and continuous monitoring of performance and quality control plans to identify improvements. The Data Analyst will transform the data found inside of an organization into new information critical to business decisions. We are looking for a passionate Data Analyst to turn data into information, information into insight and insight into business decisions.
•Gathering Data - Collecting the data to be studied. Data may come from corporate databases, ERP system, spreadsheets or other structured sources. The Analysts will design systems, processes and templates for capturing data then gather and analyze the results.
•Select and use appropriate tools to perform data extraction, modeling, transformation, cleansing, loading, and interpretation.
•Acquire data from primary or secondary data sources such as ERP systems, MMIS systems and Contract repository systems
•Design and prepare standard and ad hoc reports and summaries for statistical analysis and planning purposes
•Design, create and implement programs and templates to collect, display and analyze data for assigned projects and/or Prodigo customers
•Analyzing Data into Reports and Summaries - The Analyst is responsible to develop data extracts and reports using scripts, data filters, sort and list data, adding groupings and subtotals. The Analyst will be able to interpret general requirements gathered from executives who need to interpret the data. It is the Analyst's job to determine the source of the data and design the appropriate reports or summary lists.
•Identify, analyze, and interpret trends or patterns in complex data sets
•Maintain databases/data systems
•Cleaning Data - Once the data has been collected, in order to allow for proper comparison, the analyst must filter and clean the data to remove errors and ensure consistency and completeness of data. Cleansing routines should be used to transform abbreviations found inside the data, as well as, identify like matches where data values may have been keyed incorrectly, may have partially matching strings or values may be missing. The Analyst will need some programming skills to write cleansing scripts to correct errors.
•Develop routines that compare data for exact matches, likely matches and misses
•Interpret data, analyze results using statistical techniques and provide ongoing reports
•Review reports, and performance indicators to locate and correct code problems/gaps
•Know which statistical techniques apply to a given problem, and then translate the results into information useful to the executive.
•Dig deep into the data, using statistical techniques like correlation, regression or time series analysis to write reports summarizing the findings in a language the executive understands.
•Write cleansing scripts to filter and clean data
•Filter the data, then selects a format that effectively presents the information
•Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality
-Bachelor's degree in Mathematics, Economics, Computer Science, Information Management or Statistics required.
- 4-5 years of professional experience in a business or data analyst role required.
-Technical expertise regarding data models, database design development, data mining and segmentation techniques required.
-Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
-Adept at queries, report writing, and presenting findings.
Licensure, Certifications, and Clearances:
UPMC is an Equal Opportunity Employer/Disability/Veteran