Connect with us icon Connect With Us

Data Quality Analyst, Intermediate - Prodigo Solutions

Description

The Data Quality Analyst will join the larger Data Warehouse Development team. Data Quality Analysts examine complex data and turn it into information and insight to inform business decisions. They also monitor performance and quality control plans to identify any issues or ways to improve client deliverables and database designs. This role will collaborate with database developers to implement effective automation processes by developing test scripts for customer scenarios and acceptance criteria. This role will also participate in Research and Development (R&D) on emerging Database Technologies. The position involves writing SQL queries within Prodigo's Data Warehouse and MDM platform so data can be mined for quality control and accuracy.
 
This role suits people who enjoy working with datasets and numbers have an aptitude for computer systems and software along with strong diagnostic and analytical abilities (root cause analysis).

Responsibilities:
  • Where required, document organizational processes and maintain the organization's knowledge base.
  • Protect the integrity and confidentiality of all data and information through physical and electronic measures.
  • Establish and maintain defect tracking system that tracks reported defects.
  • Develop and execute test scripts for delivered product. Develop and execute application load tests for developed data solutions.
  • Assist in the development of project quality test plans. Document system test plans, test cases, test scripts and test summary reports ensuring the delivered product meets the requirements of the documented use cases (user stories). Assist/consult with programmers in their development of unit test and integration test development.
  • Verify work product traceability to project deliverables; verifying that data deliverables are traceable to the Design Specification and satisfy the documented business requirement(s) and acceptance criteria.
  • Provide service to the Prodigo data team, support teams and client community by ensuring the quality of our product is consistent with the organization's quality objectives.
  • Prioritize Business Needs. Data quality analysts work with management to prioritize business and information needs and identify new processes that will improve the systems in place and define new opportunities.
  • Review Data Statistics and Exception Reports. This role involves filtering and cleaning data by reviewing computer reports and performance indicators to correct any code problems and check the efficiency of the data collection and transformation processes in place.
  • Influence design of Processes, Systems, and Databases. This role involves working with database developers to implement data structures for more effective data collection and storage, as well as performing data analytics and other strategies to optimize the efficiency and quality of the data being collected.
  • Interpret Data. Data quality analysts interpret data and analyze the results using statistical techniques. They provide an ongoing quality assessment on work outputs showing the effects of different ETL processes, data transformations and observed trends or issues which are raised with the technology team and/or senior management.

Qualifications

  • Education and Training:
    • Typically, has completed a four-year academic degree including courses in computer programming, systems analysis, system development, or systems engineering OR has acquired Core IT skills and knowledge via practical experience.
    • 3-4 years of work experience in software Quality Assurance testing required.
    • Demonstrated commitment to continuing education; keeping up with advances in technology, software tools, and analytical methods is a must.
  • Capabilities:
    • Strong analytical abilities.
    • Be able to condense complex data into digestible information for use in other parts of the business and have an aptitude for numbers.
    • Strong technical expertise.
    • Data quality analysts work with statistical packages and programming codes, so they must be technically adept and able to work with data models and master data software.
    • Interpersonal skills.
    • This role involves working with different departments and as part of a team, so excellent interpersonal and communication skills are important to work effectively with others.
    • Problem-solving skills.
    • Identifying issues or ways to improve systems that are already in place is a key job function, so data quality analysts must be critical thinkers who can successfully troubleshoot and solve problems
    • Strong understanding of data management and supporting database query tools:
      • Programming languages (SQL, XML, Python, ETL frameworks [SSIS])
      • Statistical packages (Excel)
      • Data reporting tools (Power BI)
Flexible work arrangments available

Licensure, Certifications, and Clearances:

UPMC is an Equal Opportunity Employer/Disability/Veteran

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

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