SDET - Quality/Automation Engineer - Data Warehouse

ROLE:

• Defines the testing strategy and approach to validate new or enhanced functionality implemented by teams.
• Collaborates with team members to decompose functional and nonfunctional requirements into test scripts and scenarios.
• Determines test dependencies including QA test environment, QA tools, training, build and deployment plans, intra-team dependencies, and communication processes.
• Creates and executes manual and automated test scripts to validate the acceptance criteria defined within the epics and user stories implemented by team members.
• Develops manual test cases for all functional and non-functional requirements and collaborates with development team members to identify candidates for test case automation.
• Identifies risks impacting the timely delivery of a given product and collaborates with team members to prepare mitigation strategies.
• Executes smoke, functional, integration, and non-functional test scripts as part of the product/application delivery lifecycle.
• Collaborates with team members to investigate the root cause of failed manual or automated test scripts.
• Creates defects with detailed information pertaining to the failed test case/scenario with supporting documentation (screenshots, environment details, log files, etc.).
• Collaborates with team members to identify existing manual and automated test scripts that will be impacted through the development of new features and capabilities.
• Shares feedback with the team members pertaining to the quality of sprint deliverables during retrospectives.
• Manages the remediation of defects raised throughout the development lifecycle and creates supporting quality reports that are shared with stakeholders.
• Develops testing protocols and standards to improve end-to-end testing outcomes and shares and adopts best practices with the center of excellence (CoE) and other Quality Engineers.
• Creates test data to support the execution of functional and nonfunctional testing activities.
• Develops and executes automated test scripts to accelerate team velocity through the reduction of manual testing efforts.
• Builds automated test framework and tools to automate the regression testing and perform functional, integration and load testing across Data Platform services and applications.
• Maintains the automated testing suite and accompanying framework for a given product.
• Shares test automation practices with engineers to promote “shift left” testing disciplines and practices (incorporate testing earlier in development) within a team.
• Collaborates with product team members (e.g., Product Owners, Data architects, and Engineers) to define the automating testing approach/strategy for a given product/application.
• Collaborates with team members (e.g., DevOps Engineers, Data architects) to incorporate new automated test scripts into the continuous integration pipeline.
• Creates and executes test cases to verify that data meets quality standards and business requirements.
• Conducts regular checks and audits to identify data issues like inaccuracies, inconsistencies, and missing values.
• Documents data quality findings and providing reports to leadership and stakeholders.
• Communicates technical concepts to non-technical audiences both in written and verbal form.

REQUIRED:

• 5 years experience testing Data Warehouse solutions and reporting; SQL & ETL as well as knowledge of Java, C#/.NET or Python
• Data Warehouse solutions - Must be able to demonstrate a solid understanding / hands-on experience testing data warehouse solutions, including end-to-end knowledge from the backend ETL processes through to reporting.
• Test automation - Must be able to provide strong examples of hands-on experience implementing automation framework and developing automated testing.
• Manual - Also must have manual testing experience beyond basic test cases, including performance testing, report testing and aspects such as layout or UI/UX validation, etc.
• Coding skills - Ability to implement scripting / write code using Java, C#/.Net or Python
• SQL - Must have strong core knowledge of SQL and the ability to adequately answer standard SQL questions expected for this role.

Recommended

• BA/BS in Computer Science, Engineering, or equivalent software/services experience.
• Experience working with Azure DevOps.
• Exposure to the retail industry.
• Experience with UX, BI solutions, such as Power BI, Looker Studio.
• Experience working with Data Engineering technologies - GCP/Azure.
• Experience working in GCP/Azure data platforms and systems.
• Excellent verbal and written communication skills.
• Proficient in Google Workspace applications, including Sheets, Docs, Slides, and Gmail.

Required Documents

• Cover Letter
• Resume

Pay Ranges:

• Level 3 - $130,000 - $160,000
• Level SR - $150,000 - $190,000, Bonus and Restricted Stock Unit (RSU) eligible
• Level Staff - $180,000 - $225,000, Bonus and Restricted Stock Unit (RSU) eligible

We offer a comprehensive package of benefits including paid time off, health benefits - medical/dental/vision/hearing aid/pharmacy/behavioral health/employee assistance, health care reimbursement account, dependent care assistance plan, short-term disability and long-term disability insurance, AD&D insurance, life insurance, 401(k), stock purchase plan to eligible employees.

Location: Hybrid in Issaquah, WA onsite minimum 3 days per week.