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 skills, from knowledge of Extract, Transform and Load processes to creating meaningful business requirement documents. At its core, the ETL/Data Architects responsibility is to design, develop and support ETL process and tools. The ETL/Data Architect's is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into Prodigo's data systems.
Bachelors degree in Computer Science, Information Systems or equivalent combination of education and relevant experience 5+ years work experience in ETL development, preferably for large, complex data sets. Healthcare experience preferred. 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 [Power BI, Tableau] to interpret data into business goals and effectively present meaningful KPIs to all stakeholders.
Licensure, Certifications, and Clearances:
UPMC is an Equal Opportunity Employer/Disability/Veteran