As a member of the Data + Analytics team, the Data Administrator [DA] will develop processes to stage, transform and ingest data from multiple sources into the Prodigo Data Warehouse. Data will be consumed in interactive visualizations in the form of Dashboards and performance analytics within Prodigo's BI (Business Intelligence) platform as well as through the use of Prodigo's global item data repository. The Data Administrator will create new applications/visualizations for the data, develop enhancements to the data and fix inaccuracies in existing data to meet business requirements, data quality standards and support application development requirements. Additionally, the Data Administrator meets with stakeholders to understand business / end user requirements; using this information to define and develop technical specifications for data processing design, data storage and validating data across Prodigo's chain of custody. The DA troubleshoots and resolves issues in the data and supporting applications; working closely with the data team to facilitate governance, administration and technical integrations with data sources.
Bachelor's degree in Mathematics, Business, Finance, Computer Science or related disciplines and 3+ year's technical work experience in ETL development, preferably for large, complex data sets OR equivalent combination of education and experience. Master's preferred. Strong experience with SQL and database management systems and data modeling required to aggregate, gather and manipulate data [stored procedures, functions and triggers].Experience writing moderate to complex SSRS reports and 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, design and architecture 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. Excellent project management skills 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 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. Healthcare experience preferred but not required
Licensure, Certifications, and Clearances:
UPMC is an equal opportunity employer. Minority/Females/Veterans/Individuals with Disabilities