Data Quality Engineer, Senior

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. 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 Qualifications 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 About the Team Blue Shield of California's mission is to ensure all Californians have access to high-quality health care at a sustainably affordable price. We are transforming health care in a way that genuinely serves our nonprofit mission by lowering costs, improving quality, and enhancing the member and physician experience. To fulfill our mission, we must ensure a diverse, equitable, and inclusive environment where all employees can be their authentic selves and fully contribute to meet the needs of the multifaceted communities we serve. Our continued commitment to diversity, equity, and inclusion upholds our values and advances our goal of creating a healthcare system that is worthy of our family and friends while addressing health disparities, promoting social justice, and integrating health equity through our products, business practices, and presence as a corporate citizen. Blue Shield has received awards and recognition for being a certified Fortune 100 Best Companies to Work, Military Friendly Employer, People Companies that Care, a Leading Disability Employer, and one of California's top companies in volunteering and giving. Here at Blue Shield, we strive to make a positive change across our industry and communities - join us Our Values: Honest . We hold ourselves to the highest ethical and integrity standards. We build trust by doing what we say we're going to do and by acknowledging and correcting where we fall short. Human . We strive to be our authentic selves, listening and communicating effectively, and showing empathy towards others by walking in their shoes. Courageous . We stand up for what we believe in and are committed to the hard work necessary to achieve our ambitious goals. Our Workplace Model: Blue Shield of California is dedicated to making work-life balance a reality. Whether you prefer to work in an office or from home, we understand flexibility is more important than ever. That's why Blue Shield is a hybrid company, offering you the opportunity to decide where you can do your best and most meaningful work. Two ways of working: Hybrid (our default) and office Hybrid - In a business unit approved office a few times per year to 3 days per week, on average Office - In a business unit approved office 4 days a week, on average. If the role you're applying for is deemed an "Essential Role," the company has determined that the role can only be performed in a Blue Shield office or in the field and would require your to meet the office worker classification. Physical Requirements: Office Environment - roles involving part to full time schedule in Office Environment. Due to the current public health emergency in California, Blue Shield employees are almost all working remotely. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of work day. Please click here for further physical requirement detail. Equal Employment Opportunity: 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.