We invite you to join the Greycroft Talent Network

Leverage our network to build your career.
Tell us about your professional DNA to get discovered by any company in our network with opportunities relevant to your career goals.

Lead DW/BI Quality Assurance Engineer

Sapphire Digital

Sapphire Digital

Quality Assurance
Morristown, NJ, USA · Boston, MA, USA
Posted on Tuesday, August 8, 2023

The Lead DW/BI Quality Assurance Engineer will be required to collaborate in an Agile context with Data Engineers, Business Analysts, Business Partners, and Managers in our Zelis Advanced Data Analytics team to develop, maintain and implement test plans to minimize defects and to assure solutions adhere to business requirements.


  • Review and analyze business requirements to produce comprehensive, and well-structured test strategy and test cases.

  • Design/Execute test plans, test scenarios, test cases/scripts for data.

  • Design, Develop and Execute automated scripts using our test automation framework.

  • Perform manual and automated testing, which may include exploratory, system, regression, compatibility, system, and integration testing.

  • Document test procedures, analysis, and results

  • Work directly with the Data Warehouse, Business Intelligence and Data Engineering teams to ensure all work is thoroughly tested.

  • Collaborate with Project Test Leaders to define test data needs for the testing effort.

  • Participate in relevant Agile Ceremonies: Daily Stand-Ups, Backlog Grooming, Sprint Planning, Sprint Reviews and Retrospectives

  • Perform QA processes and deliverables in an Agile/Scrum environment.


8+ years of testing experience with 4 years experience in Data Integration, ETL and Data Warehouse testing.

Test automation frameworks and utilization of appropriate test methodologies and tools for testing KPIs, reports, dashboards, and data warehouses.

Performance, load, functional, regression, and system level testing.

Analyze Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Technology experience required:

  • Cloud technology (Snowflake, Azure and/or AWS).

  • Advanced SQL queries to validate ETL and Business Intelligence processes.

  • Data flow and develop test strategy for ETL, ELT Data warehouse and Business Intelligence testing.

  • Data Analysis to track a data element from source through transformation to target.

Preferred Skills:

  • Bachelor’s/Master preferred.

  • Healthcare experience.

  • Technical & testing experience preferred:

    • Snowflake or similar Cloud MPP Columnar DB

    • AWS, Azure

    • DBT or similar ELT/ETL platform.

    • JIRA, TFS, GIT, Azure DevOps (CI/CD)

    • BI

  • Experience working with offshore teams.

As a leading payments company in healthcare, we guide, price, explain, and pay for care on behalf of insurers and their members. We’re Zelis in our pursuit to align the interests of payers, providers, and consumers to deliver a better financial experience and more affordable, transparent care for all. We partner with more than 700 payers, including the top-5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, over 4 million providers, and 100 million members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and a comprehensive navigation through adjudication and payment platform to manage the complete payment process.

Commitment to Diversity, Equity, Inclusion, and Belonging
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.

Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We encourage members of traditionally underrepresented communities to apply, even if you do not believe you 100% fit the qualifications of the position, including women, LGBTQIA people, people of color, and people with disabilities.

Accessibility Support

We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email TalentAcquisition@zelis.com

SCAM ALERT: There is an active nationwide employment scam which is now using Zelis to garner personal information or financial scams. This site is secure, and any applications made here are with our legitimate partner. If you’re contacted by a Zelis Recruiter, please ensure whomever is contacting you truly represents Zelis Healthcare. We will never asked for the exchange of any money or credit card details during the recruitment process. Please be aware of any suspicious email activity from people who could be pretending to be recruiters or senior professionals at Zelis.