ETL Developer, Senior - Prodigo

Description

Purpose:
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.

Responsibilities:

• Troubleshooting - Assist in determining the cause of data problems and degraded performance related issues; determining a solution using sound judgment to implement the appropriate actions to correct.
• Participates in the on-call support rotation.
• Educate end users (where applicable) in the use of data assets with an understanding where data originates, resides and is shared.
• Participate in code reviews; troubleshoot and resolve production issues.
• Propose new ideas with focus on quality and continuous improvement.
• 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 sets, to execute all ETL programs and to deliver data solutions that satisfy stakeholders? needs.
• Solid understanding of database design, scripting and query strategies to provide suggestions for optimal performance; automating processes where appropriate.
• Coordinate with team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities.
• Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
• Design, develop, test and deploy data integration [ETL] solutions based on business requirements.

Qualifications

-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