Data Quality Assurance Engineer

Pantherx Specialty Llc

Pittsburgh (Allegheny County)

Hybrid

USD 90,000 - 130,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical insurance
Dental insurance
Vision insurance
Health savings account
Flexible spending accounts
401K with employer matching
Life insurance
Short/long term disability
Employee Assistance Program
Paid time off
Paid holidays

Job summary

PANTHERx Rare Pharmacy is seeking a Data Quality Assurance Engineer to advance data QA policies, validate reports and dashboards, and ensure high-quality deliverables in a hybrid Pittsburgh environment.

The role emphasizes collaboration across teams, testing frameworks using PySpark, and expertise in ETL testing, data profiling, and data mapping to support critical disease data workflows.

Qualifications

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • 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.

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.

Skills

Data testing processes
SQL
PySpark
Python
Azure DevOps
ADF Orchestration
Azure Data Services
Databricks
ETL testing
Data quality
Dashboard/testing requirements

Education

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

Tools

Azure DevOps
ADF Orchestration
Azure DataBricks
GitHub API
Jenkins

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.

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.

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!

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Quality Assurance Engineer
Data Quality Assurance Engineer

PANTHERx Rare Pharmacy • Pennsylvania

Hybrid
USD 90,000 - 130,000
Hybrid/remote option
401K with employer matching
Full benefits package
+1
Quality Assurance Engineer
Quality Assurance Engineer

Pantherx Specialty Llc • Pittsburgh

Hybrid
USD 65,000 - 110,000
Medical, dental, vision coverage
401K with employer matching
Paid time off
Software Engineer
Software Engineer

Pantherx Specialty Llc • Pittsburgh

Hybrid
USD 85,000 - 125,000
Medical insurance
Dental & Vision
401K with employer matching
+5
Software Engineer
Software Engineer

PANTHERx Rare Pharmacy • Robinson (PA)

Hybrid
USD 85,000 - 125,000
Healthcare benefits
401K with employer matching
Paid time off
Senior Application Solutions Engineer
Senior Application Solutions Engineer

Pantherx Specialty Llc • Pittsburgh

Hybrid
USD 110,000 - 140,000
Medical Insurance
401K Matching
Paid Time Off
Senior Business Analyst
Senior Business Analyst

Pantherx Specialty Llc • Pittsburgh

Hybrid
USD 90,000 - 120,000
Medical
Dental
Vision
+4
Senior Data Steward
Senior Data Steward

Pantherx Specialty Llc • Pittsburgh

Hybrid
USD 110,000 - 150,000
Medical, dental, vision benefits
401K with employer matching
Generous paid time off
Senior Data Engineer
Senior Data Engineer

PANTHERx Rare Pharmacy • Pittsburgh

Hybrid
USD 120,000 - 180,000
Hybrid, remote and flexible on-site
Medical, dental, vision benefits
401K with employer matching
+2
Senior Business Analyst
Senior Business Analyst

PANTHERx Rare, LLC. • Pittsburgh

Hybrid
USD 90,000 - 130,000
Medical, dental, vision
401(k) with employer matching
Paid time off
+2
Lead Software Engineer
Lead Software Engineer

PANTHERx Rare Pharmacy • Robinson (PA)

Hybrid
USD 120,000 - 160,000
Hybrid/remote work schedules
Comprehensive benefits package
Generous PTO and holidays