Senior Database QA Automation Engineer, AVP

Charles River Development (CRD) is the FinTech division of State Street. Together with State Street’s Middle and Back‑office services, Charles River’s cloud‑based Front Office technology forms the foundation of the State Street Alpha® Platform, the first front‑to‑back solution in the industry. Our vision is to be the world’s leading investment platform, shaping the future of the industry and driving innovation, resilience, efficiency and growth. The CRD Engineering organization is moving from monolithic software to next‑generation cloud‑based technology using Microsoft Azure, Kafka, Snowflake and more. Industry momentum has seen CRD grow over 135% in headcount over the last five years, and we continue to grow.

Summary: Work as a senior member of a Scrum team to execute the overall quality plan for one of Charles River’s products. Provide support and assistance to customers and other teams within Charles River. The candidate should be a sharp automation engineer with strong problem‑solving skills and a solid software testing foundation.

Responsibilities:

• Work closely with the scrum master, product owner, architect, business analysts, product specialists, developers and other project team members to assist in carrying out the software quality responsibilities of the Scrum team.
• Create comprehensive test automation scripts from business requirements and functional specifications documents for product features of moderate complexity.
• Execute manual and automated functional, integration, regression, and performance tests.
• Maintain automated and manual test script libraries for functional, integration, regression, and performance testing.
• Align with the Software Development Life Cycle practices and comply with Information Security and Data Governance practices.
• Interpret results of automation tests and document software defects in an issue‑tracking system; proactively communicate issues with developers and other project team members.
• Provide testing leadership by identifying opportunities for improvement in the Scrum team’s QA methodology, innovate by researching and recommending new approaches to automation of testing, including use of Artificial Intelligence.
• Adhere to a testing schedule to ensure efficient and effective product delivery.
• Actively participate in the agile software development process by attending all daily stand‑ups, sprint planning, backlog grooming, and retrospectives.
• Participate in “testathon” activities as required by releases.
• Guide and mentor junior staff in proper creation of automated test scripts.

Qualifications:

• 6 – 9 years of experience in software testing in a process‑driven technology environment.
• Demonstrated experience programming with Java, C#, SQL, Python and shell scripting languages such as PowerShell and Bash.
• Experience writing complex SQL queries for data validation.
• Experience in database performance testing and optimization.
• Understanding of database security best practices.
• Demonstrated experience implementing automation tests with industry‑relevant tools.
• Demonstrated experience implementing and executing automation test scripts against web, native/desktop applications, APIs and batch applications.
• Demonstrated experience using test cases, scripts, and automated test tools for verifying requirements on multi‑tier applications.
• Demonstrated ability translating business requirements into comprehensive functional and technical test plans.
• Effective written and verbal communication.
• Employees are expected to work from the office per country‑specific company guidelines.

Education: B.S. degree (or foreign education equivalent) in Computer Science, Engineering, Mathematics, Physics or other technical course of study or Business with an MIS background; M.S. degree strongly preferred.

Employment type: Full‑time

Seniority level: Senior

E‑EO Statement: State Street is an equal‑opportunity and affirmative‑action employer. We consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.