What are the responsibilities and job description for the Quality Engineer, Senior position at Blue Shield of CA?
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 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
External hires must pass a background check/drug screen. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws.