Data Quality Assurance Engineer (333013)

PANTHERx Rare Pharmacy; Pennsylvania; Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid/remote option

401K with employer matching

Full benefits package

Paid time off

Job summary

PANTHERx Rare Pharmacy in Pittsburgh, PA seeks a Data Quality Assurance Engineer to advance data QA policies, test data, dashboards, and ETL processes. You will collaborate across teams to ensure data integrity and quality of reports and transformations.

The role emphasizes testing frameworks using PySpark, SQL data profiling, and Azure cloud services, with hybrid work options and strong benefits. Bachelor's in CS/IT required.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Knowledge of data testing processes and methodology.
• 2+ years in data quality testing, design and implementation of mixed Cloud/on-prem solution.
• 2+ years creating data profiling, data mapping & SQL.
• 2+ years 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 ETL experience—cleansing, transforming, loading data and testing dashboards/reports.
• Understanding of DWH concepts, dimensional modeling.
• Experience in documenting data quality requirements and validating data analyses.

Responsibilities

• Collaborates with teams to understand business requirements and creates testing documentation.
• Develops test strategies, approaches, and documentation to support business needs.
• Creates data profiling and data mapping documents for testing needs.
• Contributes to testing frameworks using PySpark and validates data, reports, and dashboards with checks.
• Monitors and reports defects and participates in defect triage calls.
• Designs test data to validate transformation and logic between layers.
• Leads dashboard and ETL result testing and verification.
• Establishes data quality rules and checks based on data completeness and transformation logic.

Skills

Data quality testing

Python (Pandas, PySpark)

SQL

Azure Data Services

ETL testing

Test automation

Documentation

Data profiling

Education

Bachelor’s degree in Computer Science / IT

Tools

Azure DevOps

ADF Orchestration

Azure DataBricks

Power BI

Tableau

Job description

7,000 Diseases - 500 Treatments - 1 Rare Pharmacy

PANTHERx is the nation’s largest rare disease pharmacy, and we put the patient experience at the top of everything that we do.

If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don’t need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients.

We Are Seeking Team Members Who

Are inspired and compassionate problem solvers; Produce high quality work; Thrive in the excitement of the ever-challenging environment of modern medicine; and Are committed to achieving superior health outcomes for people living with rare and devastating diseases.

At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases.

Join the PANTHERx team, and define your own RxARE future in healthcare!

Location: Pittsburgh, PA (Hybrid)

Classification: Exempt

Status: Full-Time

Reports to: Manager, IT Quality Assurance (QA)

Purpose

The Data Quality Assurance Engineer must possess strong technical knowledge and experience in data quality assurance. This role requires excellent communication and problem-solving skills and must be able to think critically to evaluate and analyze reports, dashboards and exports. This position will be responsible for advancing and executing data QA policies and procedures, adhering to company standards, and monitoring the process to ensure a high quality of deliverables.

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.

Required Qualifications

• 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.

Preferred Qualifications

• Minimum of two (2) years experience in a data QA role
• Experience in BI Tools like MS Power BI and Tableau.
• Excellent problem-solving and troubleshooting skills.
• Excellent verbal and written communication skills.

Work Environment

This position operates in a home and professional office environment. When in-office this role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines, and communications via MS Teams.

Physical Demands

While performing the duties of this job, the employee is regularly required to sit, see, talk, or hear. The employee frequently is required to sit; stand; walk; use hands and fingers to handle or feel; and reach with hands and arms. Visual acuity is necessary for tasks such as reading, observing surroundings, and working with various forms of data. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions of the job.

Benefits

Hybrid, remote and flexible on-site work schedules are available, based on the position. PANTHERx Rare Pharmacy also affords an excellent benefit package, including but not limited to medical, dental, vision, health savings and flexible spending accounts, 401K with employer matching, employer-paid life insurance and short/long term disability coverage, and an Employee Assistance Program! Generous paid time off is also available to all full-time employees, as well as limited paid time off for part-time employees. Of course we offer paid holidays too!

Equal Opportunity

PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.