Connect with us icon Connect With Us

Data Administrator- Prodigo

Description

Purpose:
As a member of the Data + Analytics team, the Data Administrator [DA] will develop processes to stage, transform and ingest data from multiple sources into the Prodigo Data Warehouse. Data will be consumed in interactive visualizations in the form of Dashboards and performance analytics within Prodigo's BI (Business Intelligence) platform as well as through the use of Prodigo's global item data repository. The Data Administrator will create new applications/visualizations for the data, develop enhancements to the data and fix inaccuracies in existing data to meet business requirements, data quality standards and support application development requirements. Additionally, the Data Administrator meets with stakeholders to understand business / end user requirements; using this information to define and develop technical specifications for data processing design, data storage and validating data across Prodigo's chain of custody. The DA troubleshoots and resolves issues in the data and supporting applications; working closely with the data team to facilitate governance, administration and technical integrations with data sources.

Responsibilities:

  • Helps scope and develop database solutions to compile data for identification, enrichment and analysis into interactive Dashboards and reports within BI tools and the Prodigo global item data repository.
  • Collaborates with all stakeholders to gather required data to execute all ETL programs to deliver solutions to satisfy stakeholders needs.
  • Organizes data and implements analytic data marts and business intelligence views for performance monitoring, measurement, evaluation vs. forecasts, and financial measures.
  • Ensures accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution.
  • Plans, coordinates, develops, tests and supports ETL processes, including architecting table structure and building ETL workflows.
  • Coordinates with team for all new projects and maintains effective awareness of all production activities.
  • Document all technical and system specifications for all ETL processes.
  • Performs unit tests on all processes and prepares required programs/scripts.
  • 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.
  • As requested, provides data consultation in support of business and technology initiatives.
  • Ability to develop and maintain collaborative relationships with peers and colleagues across the organization, including senior management, technical staff and executives.

 

Qualifications

Bachelor's degree in Mathematics, Business, Finance, Computer Science or related disciplines and 3+ year's technical work experience in ETL development, preferably for large, complex data sets OR equivalent combination of education and experience. Master's preferred. Strong experience with SQL and database management systems and data modeling 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. 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, design and architecture 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. Excellent project management skills 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 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. Healthcare experience preferred but not required

Licensure, Certifications, and Clearances:

UPMC is an equal opportunity employer. Minority/Females/Veterans/Individuals with Disabilities

Location: Cranberry Township, PA, United States
Job ID: 51314645

UPMC is an equal opportunity employer.
Minority / Females / Veterans / Individuals with Disabilities