Data Quality Assurance Engineer

 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.