State Street—Database Analyst, Officer

Job description

Description: The Database Analyst will support the day-to-day operation, stability, and readiness of end-to-end QA environments used to validate application releases, patches, hotfixes, integration workflows, automation runs, and client-like testing scenarios. The role requires hands-on ownership of database and cache readiness across Microsoft SQL Server, Oracle, Postgres, Cosmos DB, Snowflake, RocksDB, and Redis, with a strong emphasis on reliable test data, environment consistency, rapid troubleshooting and clear coordination with QA, Development, Release Management, and Platform teams. They will ensure environments are available, correctly configured, appropriately seeded, validated after deployments, and recoverable when test cycles encounter data, schema, connectivity, or cache-state issues. This candidate will also be a key contributor towards defining, deploying, and governing the unified data platform in the end-to-end QA environment. Key Responsibilities - Provide daily operational support for end-to-end QA, integration, patch, hotfix, release candidate, smoke test, automation, and client-like non-production environments. - Monitor database and cache readiness before, during, and after deployments, including validating connectivity, data availability, schema compatibility, permissions, job completion, and environment-specific configuration. - Serve as the primary database analyst for end-to-end environment related issues, triaging incidents, identifying root cause, coordinating fixes, and communicating status to stakeholders. - Support repeatable setup, teardown, refresh, and re-seeding activities so QA teams may execute tests against predictable and consistent baselines. - Maintain environment parity across supported QA and end-to-end landscapes, identifying drift in schemas, configuration, reference data, security grants, or cache state. - Define and own the unified data platform for QA including architecture, governance, component reusability, synthetic data generation, data shape simulation, and data readiness. - Enable self-service data capabilities across the broader end-to-end platform supporting the overall autonomous data provisioning for QA automation. - Design and scale reusable test data services for workflow-driven automation by building data components, data profiles, synthetic data generation, and autonomous provisioning capabilities across UAP. - Partner with pillar teams to enable data-aware, environment-independent workflow execution while ensuring data quality, security, governance, and CI/CD integration at enterprise scale. - DBA should have some QA familiarity with this, it’s not just a production DBA kind of thing, it is supporting QA standards and acting as a Data Steward. - The candidate must have experience in synthetic test data generation and data shape simulation, with the ability to seed realistic client-like datasets for QA workflows, automation, regression, and end-to-end testing Technical Environment / Qualifications - Required: Minimum 10 years of experience as a Database Analyst. - Hands-on experience support database environments in QA, UAT, integration staging and other non-production settings - Strong SQL skills including joins, data validation queries, data comparison, troubleshooting and ad hoc analysis - Practical experience with at least two of the following platforms: SQL Server, Oracle, Postgres, Cosmos DB, Snowflake, RocksDB, or Redis; willingness to learn the remaining platforms. - Ability to analyze data-flow issues across upstream and downstream systems, including batch jobs, workflow execution, and integration services. - Familiarity with cloud-hosted environments, Azure services, Kubernetes-based deployments, data pipelines, or workflow orchestration tools. - Proven ability to design and execute data-driven and workflow-driven automation test scenarios - Exposure to synthetic test data generation techniques (e.g. using Python, Faker libraries, or custom generators) - Strong understanding of test data management concepts, including data setup, teardown, and dependency handling - Experience integration automation with CI/CD pipelines - Experience working in data-intensive environments such as: Data Warehouses, Data Lakes, ETL / data pipeline systems - Strong experience writing complex SQL queries for large-scale data validation and reconciliation - Experience with data masking, anonymization, or production data scrubbing techniques, including maintaining referential integrity - Understanding of data security and data privacy best practices, especially related to handling sensitive or PII data About Charles River Development Charles River Investment management System in a platform that provides many Front-Office functions including Portfolio Management, Order Management and Execution, Compliance, Performance & Attribution, Modelling, Scenario Analysis, and Wealth Management. We are part of the State Street Bank. State Street is one of the largest custodian banks, asset managers, and asset intelligence companies in the world. From technology to product innovation, we’re making our mark in the financial services industry. For more than two centuries, we’ve been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investment research & trading, and investment management to institutional clients. Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary in location, but you may expect generous medical care, insurance and savings plans among other perks. You’ll have access to flexible Work Program to help you match your needs. And our wealth of development programs and educational support will help you reach your full potential. Inclusion, Diversity and Social Responsibility. We truly believe our employees’ diverse backgrounds, experiences and perspective are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift programs and access to employee networks that help you stay connected to what matters to you. State Street is an equal opportunity and affirmative action employer. Discover more at StateStreet.com/careers. Interested in learning more about us? Visit our www.statestreet.com www.crd.com LinkedIn page: State Street on LinkedIn About State Street Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future. As an Equal Opportunity 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. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement