Hybrid Data Quality Assurance Engineer

at PANTHERx Rare Pharmacy

• Job title: Data Quality Assurance Engineer
• Job type: Full Time
• Experience level: Junior, Mid level
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, Cloud, ETL, Jenkins, Pandas, PySpark, Python, SQL, Tableau
• Location requirements: Hybrid, Pittsburgh, United States

About the role

• Data Quality Assurance Engineer at PANTHERx, focusing on data quality assurance in healthcare. Collaborating across teams to ensure high-quality data deliverables and optimal patient care.

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.

Requirements

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

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!