Blue Shield of California
Data Quality Engineer, Senior
Blue Shield of California, Oakland, California, United States,
Your Role
The Data Services Quality Engineering team is part of the BSC Data & Analytics Organization. We provide testing services for Data & Analytics projects. The data is sourced from various internal and external applications and loaded to the consumption layer. The Quality Engineer, Senior, will report to the IT Manager. In this role you will be working with Data & Analytics, Data Engineering, Data Analysis, Application, and Business teams.
Your Work
In this role, you will:
Develop test scenarios and underlying test scripts (Functional and SIT) based on provided requirements/design documentation and business input
Attend requirement sessions and evaluates 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
Have proficiency working in Agile methodology
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
Have the ability at applying advanced professional principles and concepts to complex work assignments Participate and present in automation code reviews
Assess suitability of manual test cases for automation
Your Knowledge and Experience
Requires a bachelor's degree, preferably in Computer Science, or equivalent experience and a minimum of 5 years of prior relevant experience
5 years of Quality Engineering experience, with 4 years of experience in Data Warehousing preferred
Prefers 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 etc.
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
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
Analyzing and writing testing cases based on ETL specifications/ Source-to-Target Mapping documents
Knowledge of data & analytics in cloud
Demonstrate a mindset of continuous improvement in process/technology etc.
Experience with coding in python or any other object-oriented programming language is preferred
Pay Range
The pay range for this role is: $ 99000.00 to $ 148500.00 for California.
Note
Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.
#LI-EB1
The Data Services Quality Engineering team is part of the BSC Data & Analytics Organization. We provide testing services for Data & Analytics projects. The data is sourced from various internal and external applications and loaded to the consumption layer. The Quality Engineer, Senior, will report to the IT Manager. In this role you will be working with Data & Analytics, Data Engineering, Data Analysis, Application, and Business teams.
Your Work
In this role, you will:
Develop test scenarios and underlying test scripts (Functional and SIT) based on provided requirements/design documentation and business input
Attend requirement sessions and evaluates 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
Have proficiency working in Agile methodology
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
Have the ability at applying advanced professional principles and concepts to complex work assignments Participate and present in automation code reviews
Assess suitability of manual test cases for automation
Your Knowledge and Experience
Requires a bachelor's degree, preferably in Computer Science, or equivalent experience and a minimum of 5 years of prior relevant experience
5 years of Quality Engineering experience, with 4 years of experience in Data Warehousing preferred
Prefers 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 etc.
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
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
Analyzing and writing testing cases based on ETL specifications/ Source-to-Target Mapping documents
Knowledge of data & analytics in cloud
Demonstrate a mindset of continuous improvement in process/technology etc.
Experience with coding in python or any other object-oriented programming language is preferred
Pay Range
The pay range for this role is: $ 99000.00 to $ 148500.00 for California.
Note
Please note that this range represents the pay range for this and many other positions at Blue Shield that fall into this pay grade. Blue Shield salaries are based on a variety of factors, including the candidate's experience, location (California, Bay area, or outside California), and current employee salaries for similar roles.
#LI-EB1