Data Analyst, Associate - Prodigo

Description

Purpose:
As a member of the Data + Analytics team, the Data Analyst [DA] will develop processes to stage, transform and ingest data from multiple sources into the Prodigo Data Warehouse. Data will be used in operational systems, Prodigo's global item data repository, as well as, consumed in interactive visualizations in the form of Dashboards and performance analytics within Prodigo's BI (Business Intelligence) platform. The DA meets with stakeholders to understand business / end user requirements; using this information to define and develop data processing design, data storage and data validation across Prodigo's chain of custody. During the data design, the DA will build processes to validate data sets to ensure data integrity and fix inaccuracies in existing data to meet business requirements, data standards and support application development requirements. Additionally, The DA troubleshoots and resolves issues in the data and supporting applications; working closely with the data team to facilitate root cause analysis, data queries and technical integrations with data sources.

Responsibilities:

• Coordinates with team for all new projects and maintains effective awareness of all production activities.
• Ensures accuracy & integrity of data through analysis, coding, writing clear documentation & problem resolution.
• Plans, coordinates, develops, tests and supports ETL processes, including supporting architecting table structure and ETL workflows.
• Document all technical and system specifications for all ETL processes.
• Troubleshoot and resolve production data related issues.
• Participates in on-call project support rotation.
• Ability to develop and maintain collaborative relationships with peers and colleagues across the organization, including senior management, technical staff and executives.
• Propose new ideas with focus on quality and continuous improvement of data quality.
• Designs, develops and generates ad hoc reports and analysis by querying customer database using analytical tools; publishing validated, relevant metrics to evaluate operational effectiveness.
• Collaborates with all stakeholders to gather required data to execute all ETL programs to deliver solutions to satisfy stakeholders needs.
• Performs unit tests on all processes and prepares required programs/scripts.

Qualifications

-Bachelor's degree in Mathematics, Business, Finance, Computer Science or related disciplines.

-At least 2-3 year's technical work experience in data analyisis, preferably for large, complex data sets.

-Strong experience with SQL and performace tuning. Required to aggregate, gather and manipulate data [stored procedures, functions and triggers].

-Experience writing moderately complex 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 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.

-Experience with project management/ownership 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 in Python or NLTK [Natural Language ToolKit] strongly preferred.

-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; must be comfortable communicating with internal and external stakeholders.

-Healthcare experience preferred but not required.

Licensure, Certifications, and Clearances:

UPMC is an Equal Opportunity Employer/Disability/Veteran