Overview
On Site
USD 99,000.00 - 148,500.00 per year
Full Time
Skills
Data marts
Reporting
Data engineering
Data Analysis
System integration testing
Design documentation
Test estimation
Leadership
Business requirements
Technical drafting
Data modeling
Test plans
Test scenarios
Data quality
Test-driven development
Test management
JIRA
QA management
IT project management
Root cause analysis
Business development
Project management
Agile
IT management
Design
Test scripts
Regression analysis
Smoke testing
Balanced scorecard
Manual testing
Computer science
Quality assurance
Testing
Microsoft Azure
Data Lake
Storage
Database
Database design
Snow flake schema
Star schema
Slowly changing dimensions
Unix
Shell
SQL
Scripting
Regression testing
Communication
Health care
Data warehouse
Informatica
Test cases
Extract
transform
load
Specification
Mapping
Documentation
Data
Analytics
Cloud computing
Continuous improvement
Software development
Python
Object-Oriented Programming
Configuration Management
Content management
Change management
Job Details
JOB DESCRIPTION
Your Role
The Data Services Quality Engineering team is part of the BSC Data & Analytics Organization. We provide testing services for Data & Analytics projects that involve data within the enterprise from the various sources through intake layers into down downstream data marts. The Quality Enginer, 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:
QUALIFICATIONS
Your Knowledge and Experience
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-CM1
Your Role
The Data Services Quality Engineering team is part of the BSC Data & Analytics Organization. We provide testing services for Data & Analytics projects that involve data within the enterprise from the various sources through intake layers into down downstream data marts. The Quality Enginer, 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
QUALIFICATIONS
Your Knowledge and Experience
- Requires a bachelor's degree, preferably in Computer Science, or equivalent experience and minimum 5 years of prior relevant experience
- 5 years of Quality Engineering experience, with 4 years of experience in Data Warehousing preferred
- Requires 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-CM1
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.