Data Quality Engineer, Senior

California Physicians' Service - Oakland, CA

Full-time - Mid Level

Oakland, CA

Insurance Carriers and Related Activities

About the position

The Senior Data Quality Engineer will be part of the Data Services Quality Engineering team within the BSC Data & Analytics Organization. This role focuses on providing testing services for Data & Analytics projects, ensuring data integrity and quality as it is sourced from various applications and loaded into the consumption layer. The position involves collaboration with multiple teams including Data Engineering, Data Analysis, and Business teams, and requires a strong understanding of testing methodologies and automation frameworks.

Responsibilities

• Develop test scenarios and underlying test scripts (Functional and SIT) based on provided requirements/design documentation and business input.
• Attend requirement sessions and evaluate requirements for testability.
• Create traceability from development hand off through testing.
• Participate in design sessions to understand implications of design to testing.
• Provide test estimates for large initiatives as requested under the guidance of testing leadership.
• Review Business Requirement Document (BRD), Technical Design Document (TDD), Data Model, Source-to-target mapping document (STTM).
• Prepare Test Plans, Test Scenarios, Test Data, Test Cases, Test Scripts based on BRD, TDD, STTM.
• Review test artifacts with business users and technical team.
• Maintain test cases in test management system and track defects in JIRA.
• Conduct daily defect calls with IT PM, Development team and Business team.
• Provide test reports/status to Test Lead, IT PM and discuss roadblocks if necessary.
• Perform root-cause analysis for the defects/issues and provide solution if required.
• Follow best practices and maintain quality assurance standards.
• Work closely with cross-functional counterparts in business, development, release and project management.
• Provide overall technical leadership across multiple projects simultaneously.
• Have thorough understanding of automation frameworks and ability to design, develop and maintain automation framework.
• Execute and maintain test scripts in the automation framework for regression and smoke testing of various BSC applications.
• Participate and present in automation code reviews.
• Assess suitability of manual test cases for automation.

Requirements

• Bachelor's degree in Computer Science or equivalent experience.
• Minimum of 5 years of prior relevant experience in Quality Engineering.
• 5 years of Quality Engineering experience, with 4 years of experience in Data Warehousing preferred.
• At least 1 year of experience in Cloud Data Platform Testing with Azure Data Lake Storage (ADLS) Gen2 and data pipeline development using DBT Cloud/Core tool on Snowflake DB.
• Knowledge of ETL processes, Relational Database Design Methods (Snowflake/Star Schema), Slowly Changing Dimensions.
• Ability to analyze error logs in UNIX, update Shell scripts, and create SQL scripts.
• Ability to perform automated regression testing in all non-production environments.
• Excellent written and oral communication skills.

Nice-to-haves

• Healthcare domain experience is preferable but not required.
• Preferred experience working on at least one large data warehouse project/initiative.
• Hands-on experience in using Informatica or similar ETL tool.
• Experience with coding in python or any other object-oriented programming language.

Benefits

• Competitive salary based on experience and location.
• Opportunities for professional development and continuous improvement.