At Prodigo Solutions, we help create health care supply chain innovations that will impact the lives of patients in meaningful ways while reducing the overall cost of care. Prodigo's data integration projects require a wide set of technical skills; from understanding business requirement and user stories to building Extract, Transform and Load processes for our Data Warehousing initiatives.At its core, the ETL/Data Developer's responsibility is to design, build and support ETL processes using data management best practices and tools. The ETL/Data Developer is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into Prodigo's data systems.
-5+ years work experience in ETL development, preferably for large, complex data sets.
-Working proficiency in SQL 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.
-Strong problem-solving skills for data management with a willingness to roll up one's sleeves to get the job done.
-Excellent organizational and analytical skills with strong technical abilities.
-Skilled at working effectively with cross functional teams in a matrix organization.
-Excellent written and verbal communication skills.
-Experience with data visualization tools [PowerBI, Tableau] to interpret data into business goals and effectively present meaningful KPIs to all stakeholders.
-Healthcare experience preferred.
-Bachelor's degree in Computer Science, Information Systems or equivalent combination of education and relevant work experience.
Licensure, Certifications, and Clearances:
UPMC is an Equal Opportunity Employer/Disability/Veteran