Apply on Employer Site

PANTHERx Rare Pharmacy · 3 weeks ago

Data Quality Assurance Engineer

Pittsburgh, PA

Full-time

Hybrid

Entry, Mid Level

2+ years exp

PANTHERx Rare Pharmacy is the nation’s largest rare disease pharmacy, dedicated to providing high-quality outcomes for patients. The Data Quality Assurance Engineer will be responsible for advancing and executing data QA policies, collaborating with teams to understand business requirements, and ensuring high-quality deliverables.

BiotechnologyHealth CareMedicalPharmaceutical

Culture & Values

Responsibilities

Collaborates with teams across the organization to understand the business requirements and creates testing documentation

Develops test strategies, test approaches and test documentation to support the business needs

Creates data profiling and data mapping documents to support testing requirements

Contributes to testing frameworks using PySpark and validates data, reports, and dashboards with various checks

Monitors and reports defects and contributes to the defect triage calls

Designs test data to validate the accuracy of transformation and logic between layers

Spearheads dashboard and ETL Result testing and verification

Establishes data quality rules & checks based on data completeness & data transformation logic

Qualification

Data Quality AssuranceSQLETL TestingAzure Cloud ServicesTest AutomationData AnalysisDimensional ModelingBI ToolsProblem-solvingCommunication Skills

Required

Bachelor's degree in Computer Science, Information Technology, or a related field

Knowledge of data testing processes and methodology

Minimum of two (2) years experience in data quality testing, design and implementation of mixed Cloud/on-prem solution

Minimum of two (2) years experience in creating data profiling, data mapping & SQL

Minimum of two (2) years experience using management systems (Azure DevOps, ADF Orchestration, etc.), Azure Cloud Data Services (ADLS Gen 2, ADF) and Microsoft Azure DataBricks

Experience in Test Automation using Python (Pandas, Pyspark, Pytest,), Github API testing, and Jenkins

Strong experience in ETL (cleansing and normalizing source data, transformation, and loading) reports and dashboard testing

Excellent experience in executing data pipeline and testing

Understanding of DWH concepts, Dimensional modeling

Experience in business requirements participation and documentation of data quality requirements, data analysis and validation