Data Analyst, Associate 2

As a Data Analyst at State Street, you will play a crucial role in the development, enhancement, and maintenance of Risk and Resiliency applications within an Agile Scrum team. Your contribution will involve designing, developing, testing, and validating database solutions for Infrastructure Management applications. Additionally, you will be responsible for developing ETL pipelines using tools like Databricks and Snowflakes and optimizing SQL queries to enhance performance for BI and OLTP systems. Your role will also include investigating and resolving data issues promptly and participating in all phases of the database software development lifecycle. Key Responsibilities: - Design, develop, test, and validate database solutions for Infrastructure Management applications - Develop ETL pipelines using Databricks and Snowflakes - Write, optimize, and debug complex SQL queries; apply performance tuning techniques for BI and OLTP systems - Investigate and resolve data issues promptly - Participate in all phases of the database SDLC - Develop stored procedures, functions, cursors, and packages using Oracle PL/SQL - Apply strong data modeling concepts and database performance tuning stra…