Senior Software Engineer at State Street Bank and Trust Company in Quincy, Massachusetts, responsible for designing, building, and managing scalable cloud-based applications using Azure, Snowflake, Cosmos DB, and the Enterprise Servicing Platform (ESP). Daily tasks include developing end-to-end data pipelines, ETL processes, and reports with tools like SSIS, SQL Server Reporting Services (SSRS), and Airflow. The role involves collaborating closely with technology and business teams to ensure efficient data integration and curation. Candidates must have a strong background in multi-platform enterprise application architecture, relational databases such as SQL Server and Oracle, and extensive experience in the financial industry. Proficiency in SQL scripting, version control tools like Git, and Agile methodologies is essential, along with solid knowledge of data warehousing concepts and dimensional modeling.
Skills
Azure
Snowflake
DBT
Airflow
Cosmos DB
SQL Server
Oracle
Teradata
T-SQL
PL/SQL
BTEQ
Git
SVN
SSIS
FastLoad
MultiLoad
ESP
Data Warehousing
Dimensional Modeling
Agile Development Methodologies
SSRS
IRD
What you'll do
Design and build end-to-end data pipelines including ingestion, integration, and curation.
Develop scalable data pipelines and ETL processes on Azure, Snowflake, and Cosmos DB.
Create ETL/ELT processes using SQL, PL/SQL on the Enterprise Servicing Platform (ESP).
Develop reports using SSRS and other reporting tools as required.
Hands-on experience with ETL tools like SSIS for job development and maintenance.
Maintain in-depth knowledge of data warehousing concepts and dimensional modeling practices.
Work independently while adhering to Agile Development Methodologies.
What we're looking for
5+ years of IT/Software Development experience in the financial industry.
Solid knowledge and hands-on experience with multi-platform enterprise application architecture.
Proficiency in SQL scripting (T-SQL, PL/SQL) and relational databases (SQL Server, Oracle).
Hands-on development experience with ETL tools like SSIS, FastLoad, and utilities such as DBT, Airflow.
Strong understanding of data warehousing concepts, dimensional modeling, and best practices.
Experience in designing and deploying scalable data pipelines on cloud-based infrastructure using Azure and Snowflake.
Proven ability to work independently and collaborate effectively with various teams and stakeholders.
Market check
Salary context
This
$178,131–$180,000
range sits above
61%
of similar postings on FindRole.
Peer median band
$123,000–$208,700
Median floor and ceiling across peers.
Typical midpoint (25–75%)
$137,500–$184,900
Middle half of comparable postings.
Based on 240 comparable postings.*
* 240 is the maximum number of comparable postings sampled.
Employer
About State Street
State Street Corporation is one of the world''s largest custodian banks and asset managers, providing investment servicing, investment management, and investment research to institutional investors. Industry: Financial Services & Asset Custody
State Street currently has
134 open roles
on FindRole.
Listed pay typically runs
$110,000–$180,000
across 131 roles with salary data.