SSGA Architecture Scrum Master and Business Analyst (Finance)

StateStreet Global Advisors (SSGA) is seeking a Senior Database Engineer to join their technology-focused Database Engineering (DBE) team which is a collaborative group of engineers dedicated to ensuring the performance, security and scalability of the organization's data infrastructure. DBE team strives to create seamless and efficient data solutions to empower teams across the organization to leverage data for decision making and innovation.

Job Overview:
You will contribute as a seasoned member of a dynamic team to architect, design, develop and implement enterprise solutions for data, cloud, storage, access provisioning, replication and analytics while ensuring the guard rails for security, stability, and scalability are upheld.
You will be responsible for enterprise level development, testing, and maintenance of various implementations within the architecture team supporting 100+ applications within the IT department servicing front, middle and back office applications

Must-Have Skills:

Strong database platform knowledge including OLAP (Redshift/Databricks/Snowflake), OLTP (Postgres/Oracle/SQL Server/Sybase) and NoSQL(DynamoDB/MongoDB) data platforms.

Proficient in Data Design and Modelling for OLTP and OLAP applications for optimal performance, minimal redundancy and data integrity.

Development : Python and shell scripting, database development and optimization techniques including indexing, partitioning, materialization, as well as OLAP techniques such as star models, data distribution, sorting, vacuum, materialization, dynamic tables.

Aware of column store, compression methods.

Adhere to coding standards, write CRUD SQL, Bulk Approach for OLAP, MicroBatch workloads, able to understand modern ingestion processes, hot/cold approaches.

Ability to code stored procedures, UDFs multi language and ability to use dynamic and/or structured/semi-structured data types (e.g., XML/JSON). Understand triggers and insight into complex features such as change-data-capture, streaming.

Guide Application teams in writing of database code, validation rules, data quality.

Performance Tuning & Maintenance : Experience with backup and recovery, managing large data sets, and ongoing maintenance of changes (version control), archival and purging strategies. Technical documentation, creating SOPs and migration plans.

Monitoring & Troubleshooting critical processes in Production and knowledge of modern observability techniques such as Open Search, Grafana, Splunk. Ability to understand Disk I/O. CPU, Memory, and other internal resource utilization.

Cloud computing expertise: Familiarity with one or more major cloud platforms (AWS, Azure, GCP) and their database services.

Data Migration & Replication : Architecting and deploying GoldenGate replication on cloud platforms, optimizing performance and scalability for large data volumes.

Building robust data pipelines using GoldenGate to replicate data between different cloud databases (e.g., Oracle, PostgreSQL, MySQL) across multiple regions.

Identifying and resolving performance bottlenecks within GoldenGate replication, including tuning network settings and database configurations.

Passion for learning new technologies, collaborative mindset and a sense of accountability.

Nice-To-Have Skills:

Data modernization techniques : Externalization, follow Medallion Architecture of raw/curated/gold (aka silver/bronze/gold), Lake strategy and usage, Serverless, and Producer-consumer conceptualization.

Workflow Orchestration: Ability to understand end to end data pipelines, use of tools such as Airflow, CICD process and use of Git.

Security Management knowledge including understanding of role-based access, groups and grouping privileges, use of external systems for vaults. Ability to define standards and access controls, user management and various access methods.

Data Security - implement security measures to ensure best practices are followed and protect sensitive data during data pipeline/replication process and access control mechanisms such as Data Encryption, auditing, and logging.

Experience in Enterprise level Data Virtualization/Fabric

About State Street Global Advisors:

For nearly four decades, State Street Global Advisors has been committed to helping financial professionals and those who rely on them achieve their investment objectives. We partner with institutions and financial professionals to help them reach their goals through a rigorous, research-driven process spanning both active and index disciplines. We take pride in working closely with our clients to develop precise investment strategies, including our pioneering family of SPDR ETFs. With millions* in assets under management, our scale and global footprint provide access to markets and asset classes, and allow us to deliver expert insights and investment solutions.
State Street Global Advisors is the investment management arm of State Street Corporation.
* Assets under management were $2.67 trillion as of September 30,2017. AUM reflects approx. $36 billion (as of September 30, 2017) with respect to which State Street Global Advisors Funds Distributors, LLC (SSGA FD) serves as marketing agent; SSGA FD and State Street Global Advisors are affiliated.

Salary Range:
$130,000 - $205,000 Annual

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

Job Application Disclosure:

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

State Street's Speak Up Line Salary Minimum: 130000Salary Maximum: 205000