Location: Pittsburgh, PA (Hybrid)
Classification: Exempt
Status: Full-Time
Reports to: Manager, IT Quality Assurance (QA)
PurposeThe 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 EnvironmentThis 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 DemandsWhile 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!