Remote

Quality Engineer, Data

CPS Solutions, LLC
$90,000-$110,000 depending on experience plus bonus potential
life insurance, vision insurance, 401(k)
United States
Mar 17, 2025
Quality Engineer, Data CPS Solutions Home-based/remote The Quality Engineer, Data will work with the Data Engineering team to develop/run test scripts across all data pipelines to track and validate data from end to end. They will also be able to automate scripts to perform daily monitoring and validation to catch anomalies and prevent drift. This is different than traditional test automation engineers in that they are not automating a path through a UI but are developing targeted tests around large-scale data movement to verify Extract/Transform/Load (ETL) requirements and performance. Must be able to work in the US without sponsorship or restrictions Schedule: 40+ hours a week, generally Monday-Friday, Day Shift with weekend or evenings as needed to monitor data loads Salary Range: $90,000-$110,000 depending on experience plus bonus potential Primary Responsibilities: Works with Data Engineers to understand new stories under development and specific testing that is required for it. Develops test cases for individual stories as well as for entire releases. Performs ETL testing as part of story and release testing - following data sets through entire data lifecycle from end to end starting with raw source, data landing, cleansing, integration and transformation into data warehouse and testing to ensure data completed journey as intended Compares schemas (tables, views and stored procedures) across different environments to verify consistency and that the SDLC has been adhered to for deployments Utilizes SQL, ADF, Query Surge, Data Bricks, Pandas, Fabric, and other tools/libraries to develop, execute and schedule automated repeatable tests to ensure ETL quality does not stray Tracks and benchmarking Production nightly ETL refresh times and monitoring impacts of code changes to that time. Controls and validates data refreshes into test environments to ensure data sets are adequate for load and performance testing Documents and communicates all test results per SDLC requirements within each story and across a whole release. Performs other related duties as assigned. Required Qualifications: Bachelor's degreein computer science or a related field, or in lieu of degreerelated experience and education 5+ years of experience performing tests against very large datasets and developing, running, and deploying automation scripts in a production environment Strong Structure Query Language (SQL) skills including the ability to generate dynamic SQL to quickly develop and scale out queries to cover a large number of data objects Proficient Python development skills to setup automated test scripts Strong quality mentality - knowing common failure points, patterns and edge cases to test in ETL Experience with a full range of data testing (ETL, performance, load, etc.) Comfortable working with Azure tools (Azure Data Factory [ADF], Fabric, Data Bricks, etc.) Comfortable following a structured Software Development LifeCycle (SDLC) to capture/control all work/test cases/scripts using tools like Jira, Azure DevOps, Git Specialty Pharmacy and/or Healthcare experience preferred; aptitude for acquiring strong industry knowledge Ability to work under pressure, organize and prioritize responsibilities Ability to quickly grasp complex technical and business concepts and express them in clear language Self-motivated with the ability to work independently as well as part of a team Effective communication skills (both written and verbal) with internal and external clients Benefits: All employees enjoy a competitive salary, eligibility to participate in the 401(k) savings plan with a match. Full Time employees are also eligible for a comprehensive benefits package, including Medical, Dental and Vision Insurance, Time Off Plan, Company Paid Short- and Long-Term Disability, Basic and Supplemental Life Insurance, Medical Flex and Dependent Care Accounts and more. CPS Requirements: All employment offers are contingent upon successfully passing a pre-employment (post offer) background check, drug test and signed onboarding documents. Additionally, you may be required to provide medical records or have additional medical examinations/background checks that are a specific requirement of the location or position in which you are hired. This applies to internal transfers and status changes for internal CPS team members. CPS is also committed to a safe and drug free workplace. The use of marijuana for medical purposes accompanied by a prescription, even if permitted by state law, will not be considered acceptable for purposes of explaining a positive lab test result for marijuana. About CPS: Founded nearly 50 years ago and employing over 2,500 clinical, regulatory, and operational pharmacy professionals, CPS Solutions, LLC, is one of the nation's largest providers of pharmacy services to more than 800 hospitals and healthcare facilities nationwide. CPS helps clients tackle a variety of complex issues, such as operational efficiency, rising drug costs, regulatory & compliance, 340B, and specialty pharmacy strategy. CPS helps healthcare leaders drive best in class pharmacy operations through skill, expertise and proprietary technologies. For more information, visit https://www.CPS.com. We are an Equal Opportunity Employer and do not discriminate against any qualified employee or applicant for employment because of race, color, sex, age, national origin, ancestry, religious creed, sexual orientation, gender identity and/or expression, status as a veteran, mental or physical disability or any other federal, state or local protected class #LI-remote #CA-PC1