Data Quality Assurance Engineer

at  Delta Dental of Washington

Are you passionate about being the gate keeper of quality in data that powers business operations and analytics? Does building quality assurance framework for an evolving data platform make you excited?
We are searching for a Data Quality Assurance Engineer to join our Data Engineering team. This team is building data products, processes and services at scale and setting the pace for the overall oral health payer industry in the way data is acquired, processed and provisioned. As a Data QA Engineer, you will start with ensuring consistency and trust in data and the underlying platforms for our consumers and then progress to raise the bar of quality. You will build framework to support testing needs of a data environment that is rapidly scaling and diversifying to help our growing user base make dynamic business decisions and solve their ever-evolving problems.
At Delta Dental of Washington our vision is that all people can enjoy good oral and overall health, with no one left behind. We succeed because of a shared commitment to a set of values that guide everything we do – for our customers, for our communities, and for each other. We are Accountable. We lean in with Courage. We stay Curious. We are Inclusive. We act with Integrity.
We offer a highly competitive medical, dental and vision plans as well offering an 8% 401k match and all employees start accruing vacation and sick time from their very first day. We empower employee development through our tuition reimbursement plan, professional development plans, and employee-led communities.
The pay range for this position In Western Washington varies between $81,900.00 – $116,550.00, and for Eastern Washington varies between $67,470.00 - $96,015.00. Washington Dental Service and its affiliates, including Delta Dental of Washington and Arcora Foundation intends to offer the selected candidate a base pay within this range, dependent on job-related, non-discriminatory factors such as experience. Base pay will also be adjusted based on the candidate’s geographic location.

Essential Responsibilities include the following: The list of responsibilities listed is not intended to be comprehensive. Washington Dental Service and its affiliates, including Delta Dental of Washington and Arcora Foundation reserve the right to change the responsibilities at any time with or without notice.

• Review and design test coverage plan from functional and design specifications with an understanding of the deliverables and their business application to ensure that validated deliverables meet all requirements.
• Develop, document and maintain functional test cases and other test aspects such as creating the test data, data validation and create repeatable regression tests and automation of tests where possible.
• Participate in and help lead testing including Functional Testing, Results Validation, Regression Testing, System, Integration Testing and User Acceptance Testing.
• Execute and evaluate manual or automated test cases and report test results through regular communication to the team regarding status, issues and risks.
• Build unit testing and system testing framework towards test automation.
• Analyze data trends, draw conclusions and recommend direction as it applies to defect resolution and possible data quality issues.
• Actively take initiative to find answers, collaborating with the business and teammates to identify all facets of an issue and generate a solution.
• Perform regression tests and build test scripts for data integrations/ETL, data marts, Data Warehouse, Operational Data Store, stored procedures (and reports if necessary).
• Track and report progress of test efforts.
• Mentoring and training of other employees as needed.

Experience, skills, and education do you need to have to succeed in the position: The requirements listed below are representative of the knowledge, skill, and/or ability required to successfully perform the essential functions of the position.

• 3+ years of Data Engineering QA or BI QA technical experience
• 3+ years SQL development skills are required – with a strong working knowledge of T-SQL (including complex joins, data modeling, data mapping, stored procedures)
• Experience in testing on Cloud data platforms like Snowflake, Redshift, Big Query etc
• 3 + years’ experience in database testing in Microsoft SQL Server or other DBMS environment using SQL, including designing and manipulating test data, validating stored procedures, views & triggers.
• Experience in testing ETL based on SSIS packages and/or Stored Procedures
• Hands on with any new gen ETL tools (eg, Matillion, Glue, DBT etc) is a plus.
• Hands on experience with Python to build test framework.
• Experience in Quality Management Software and Processes
• Experience working on an agile environment and working with tools like ADO, Jira etc.
• Knowledge of relational and dimensional data models and exposure to event driven data model
• Ability to understand and create test plans from specifications or verbal communications.
• Ability to combine input from multiple sources to build comprehensive test plans.
• Ability to effectively and professionally articulate and translate, both orally and in writing, technical language to non-technical customers.
• Ability to think in the abstract and identify potential pitfalls.
• Ability to work and think independently and collaborate with others as necessary.
• Excellent conceptualization, analytical and logic skills.
• Strong collaborative, listening and communication (both written and verbal) skills.
• Automated testing design and implementation.

Washington Dental Service and its affiliates, including Delta Dental of Washington and Arcora Foundation is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c

Essential Responsibilities include the following: The list of responsibilities listed is not intended to be comprehensive. Washington Dental Service and its affiliates, including Delta Dental of Washington and Arcora Foundation reserve the right to change the responsibilities at any time with or without notice.

• Review and design test coverage plan from functional and design specifications with an understanding of the deliverables and their business application to ensure that validated deliverables meet all requirements.
• Develop, document and maintain functional test cases and other test aspects such as creating the test data, data validation and create repeatable regression tests and automation of tests where possible.
• Participate in and help lead testing including Functional Testing, Results Validation, Regression Testing, System, Integration Testing and User Acceptance Testing.
• Execute and evaluate manual or automated test cases and report test results through regular communication to the team regarding status, issues and risks.
• Build unit testing and system testing framework towards test automation.
• Analyze data trends, draw conclusions and recommend direction as it applies to defect resolution and possible data quality issues.
• Actively take initiative to find answers, collaborating with the business and teammates to identify all facets of an issue and generate a solution.
• Perform regression tests and build test scripts for data integrations/ETL, data marts, Data Warehouse, Operational Data Store, stored procedures (and reports if necessary).
• Track and report progress of test efforts.
• Mentoring and training of other employees as needed

Experience, skills, and education do you need to have to succeed in the position: The requirements listed below are representative of the knowledge, skill, and/or ability required to successfully perform the essential functions of the position.

• 3+ years of Data Engineering QA or BI QA technical experience
• 3+ years SQL development skills are required – with a strong working knowledge of T-SQL (including complex joins, data modeling, data mapping, stored procedures)
• Experience in testing on Cloud data platforms like Snowflake, Redshift, Big Query etc
• 3 + years’ experience in database testing in Microsoft SQL Server or other DBMS environment using SQL, including designing and manipulating test data, validating stored procedures, views & triggers.
• Experience in testing ETL based on SSIS packages and/or Stored Procedures
• Hands on with any new gen ETL tools (eg, Matillion, Glue, DBT etc) is a plus.
• Hands on experience with Python to build test framework.
• Experience in Quality Management Software and Processes
• Experience working on an agile environment and working with tools like ADO, Jira etc.
• Knowledge of relational and dimensional data models and exposure to event driven data model
• Ability to understand and create test plans from specifications or verbal communications.
• Ability to combine input from multiple sources to build comprehensive test plans.
• Ability to effectively and professionally articulate and translate, both orally and in writing, technical language to non-technical customers.
• Ability to think in the abstract and identify potential pitfalls.
• Ability to work and think independently and collaborate with others as necessary.
• Excellent conceptualization, analytical and logic skills.
• Strong collaborative, listening and communication (both written and verbal) skills.
• Automated testing design and implementation