As a member of the Data + Analytics team, the Data Analyst [DA] will develop processes to stage, transform and ingest data from multiple sources into the Prodigo Data Warehouse. Data will be used in operational systems, Prodigo's global item data repository, as well as, consumed in interactive visualizations in the form of Dashboards and performance analytics within Prodigo's BI (Business Intelligence) platform. The DA meets with stakeholders to understand business / end user requirements; using this information to define and develop data processing design, data storage and data validation across Prodigo's chain of custody. During the data design, the DA will build processes to validate data sets to ensure data integrity and fix inaccuracies in existing data to meet business requirements, data standards and support application development requirements. Additionally, The DA troubleshoots and resolves issues in the data and supporting applications; working closely with the data team to facilitate root cause analysis, data queries and technical integrations with data sources.
-Bachelor's degree in Mathematics, Business, Finance, Computer Science or related disciplines.
-At least 2-3 year's technical work experience in data analyisis, preferably for large, complex data sets.
-Strong experience with SQL and performace tuning. Required to aggregate, gather and manipulate data [stored procedures, functions and triggers].
-Experience writing moderately complex SSIS packages preferred.
-Solid experience in analyzing query performance issues and modifying data structures as necessary to remedy performance problems. Superior analytical, research and problem-solving skills with a demonstrated ability to structure and conduct analyses to generate insight and recommendations from data.
-Strong problem-solving skills for data management with a willingness to roll up one's sleeves to get the job done. Excellent skills in data administration with excellent organizational and analytical skills.
-Experience with data visualization tools [ Power BI, Tableau] to interpret data into business goals and effectively present meaningful KPIs to all stakeholders.
-Experience with project management/ownership to execute project plans within clearly defined deliverables and timelines. Strong working knowledge of relational databases [MS SQL] and business solutions software [MS Word, Excel, PowerPoint, Visio].
-Experience in Python or NLTK [Natural Language ToolKit] strongly preferred.
-Experience working with financial, clinical and/or supply chain datasets.
-Skilled at working effectively with cross functional teams in a matrix organization.Strong communication skills: both verbal and written; must be comfortable communicating with internal and external stakeholders.
-Healthcare experience preferred but not required.
Licensure, Certifications, and Clearances:
UPMC is an Equal Opportunity Employer/Disability/Veteran