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 Architect's responsibility is to design, develop and support ETL process and tools. The ETL/Data Architects is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into Prodigo's data systems.
•Propose new ideas with focus on quality and continuous improvement.
•Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
•Performs unit tests on all processes and prepares required programs/scripts.
•Document all technical and system specifications for all ETL processes.
•Collaborate with all stakeholders to gather required data to execute all ETL programs to deliver solutions to satisfy stakeholders needs.
•Coordinate with team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities.
•Plan, coordinate, develop, test and support ETL processes, including architecting table structure and building ETL processes.
-Bachelor's 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 preferredWorking 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