Full-Time
Data Engineer Lead
Software Engineering & Development
Posted on 9/11/2026
State Street
10,001+ employees
Asset management and custody for institutions
Compensation Overview
$130k - $212.5k/yr
Company Historically Provides H1B Sponsorship
Princeton, NJ, USA + 1 more
More locations: Quincy, MA, USA
Hybrid
Four days on-site per week and one day remote.
Bachelor's
 Data & Analytics (1) |
|---|
Get referred to State Street
See people who can refer or advise you
- Hands-on experience with Azure services such as Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure SQL Database, and related services.
- Hands-on experience designing Snowflake data-ingestion pipelines into a data warehouse.
- Strong experience in data engineering, including data-pipeline development, extract, transform, and load (ETL) or extract, load, and transform (ELT) processes, and data modeling.
- Strong proficiency in SQL and experience with programming languages such as Scala or Java.
- In-depth knowledge of SQL and experience with relational and non-relational databases such as Snowflake, Teradata, SQL Server, and Oracle.
- Knowledge of data-warehousing concepts, dimensional modeling, and best practices.
- Experience working in a multi-developer environment using version control such as Git and SVN.
- A bachelor's degree in a computer or IT-related subject.
- At least 12 years of overall IT industry experience.
- At least 8 years of overall data-pipeline and data-warehousing experience.
- At least 5 years of experience as a data engineer, focused on designing and implementing data solutions with Azure Databricks and Snowflake.
- At least 5 years of cloud-based development experience, including Azure services, Azure DevOps, Kubernetes, and Docker.
- Effective written and oral professional communication.
- Experience working in the financial industry.
- Experience with agile development methodology.
- Design, develop, and maintain data pipelines in Azure for ingesting, transforming, and loading data from various sources into centralized Azure data lakes, Databricks Delta Lake, and Snowflake as the data warehouse, while ensuring data quality and integrity.
- Implement efficient ETL and ELT processes and develop transformations to clean, aggregate, and enrich raw data for downstream analysis and consumption.
- Integrate data from diverse sources to provide a unified view of information.
- Design and implement efficient data models and database schemas for structured and unstructured data, optimizing storage and access for performance and scalability.
- Apply modern data-processing principles and pipeline tools to streamline data import and transformation and reduce manual intervention.
- Integrate with other State Street systems, implement cross-system access, and implement entitlement solutions including role-based access control (RBAC) and attribute-based access control (ABAC).
- Work with cross-functional teams to understand data requirements and translate them into technical solutions.
- Monitor data pipelines, troubleshoot issues, and ensure data integrity and security.
- Implement data-quality controls and validation processes to identify and rectify data anomalies, inconsistencies, and errors.
- Collaborate with stakeholders to define and enforce data-governance standards and policies.
- Identify performance bottlenecks in data pipelines and database systems and optimize queries, data structures, and infrastructure configurations for performance and scalability.
- Implement security measures to protect sensitive data and comply with data-privacy regulations, and address data-security vulnerabilities and risks.
- Collaborate with data scientists, analysts, and software engineers to deliver data solutions.
- Document data-engineering processes, data flows, and system configurations.
- Identify opportunities to improve data-engineering practices and contribute to the evolution of data infrastructure.
- Support the development team by managing multiple database and server instances, implementing complex queries with proper tuning, providing input on data-impacting designs, and managing Azure data infrastructure including Data Lake, Data Warehouse, and Synapse.
- Azure certifications such as Azure Data Engineer Associate or Azure Solutions Architect.
- Experience with ESP.
State Street provides asset management and custody banking services for institutional investors worldwide, with State Street Global Advisors managing portfolios and offering advisory services. It generates revenue from asset management fees, transaction fees, and custody/administration fees, plus income from its own investments and lending activities. The company differentiates itself through its global scale and focus on institutional clients, offering integrated asset management, custody, administration, research, and trading across a broad network. Its goal is to help institutional clients meet their financial objectives by delivering comprehensive investment, risk management, and custody solutions on a global platform.
Company Size
10,001+
Company Stage
IPO
Headquarters
Boston, Massachusetts
Founded
1792
Get referred to State Street
See people who can refer or advise you
Simplify's Take
What believers are saying
- July 2026 Q2 revenue hit $4.0 billion, up 17%, with record servicing fees.
- August 2026 hired Pete Dorsey and Jalil Rasheed to accelerate wealth and Singapore growth.
- 2026 ETF launches in Australia and the U.S. show product breadth beyond plain-vanilla indexing.
What critics are saying
- Expenses rose 10% in Q2 2026, while headcount fell 3% and restructuring continued.
- March 31, 2026, legal and regulatory contingencies totaled $53 million, including coal antitrust litigation.
- Passive ETF commoditization and custodial pricing pressure can hollow State Street’s fee base by 2027.
What makes State Street unique
- State Street runs $54.5 trillion AUC/A, pairing custody scale with asset management.
- September 2, 2026, UC backed State Street’s record UCBG ETF with $2.5 billion.
- State Street uses Apex, Blackstone, and tokenization to extend custody into wealth.],
- upsides:[
- Q1 2026 revenue rose 16%; servicing wins added $56 million and $365 billion AUC/A.
- August 2026, State Street launched UCBG, its largest U.S.-listed ETF debut.
- July 2026, State Street raised guidance after record revenues, inflows, and 500-basis-point operating leverage.
Help us improve and share your feedback! Did you find this helpful?
Benefits
Health Insurance
Dental Insurance
Vision Insurance
Life Insurance
Disability Insurance
Flexible Work Hours
Remote Work Options
Professional Development Budget
Tuition Reimbursement
Paid Holidays
Employee Referral Bonus
Company News
State Street Corporation has acquired a 5.49% voting stake in Inghams Group Limited, becoming a substantial shareholder effective 4 September 2026. The investment firm and its subsidiaries hold relevant interest in 20,410,450 ordinary shares. The stake is held through multiple State Street entities, including State Street Bank and Trust Company, SSGA Funds Management Inc., State Street Global Advisors Trust Company, and State Street Global Advisors Australia Limited. These interests encompass securities lending arrangements, collateral securities, and investment management authority. State Street filed Form 603 on 8 September 2026, disclosing the initial substantial holding. The filing, authorised by Alok Maheshwary, lists various registered holders linked to the interests, including American Century Investment Management, Aware Super, Alaska Retirement Management Board, and several other financial institutions.
Catch the latest updates from Australia's premier stock exchange & market indices.
Catch the latest updates from Australia's premier stock exchange & market indices.
Catch the latest updates from Australia's premier stock exchange & market indices.
State Street IM makes largest u.s.-listed ETF launch. State Street Investment Management announced the launch of the State Street(R) SPDR(R) UC Investments 90/10 Endowment Strategy Index ETF ("UCBG"), a new asset allocation ETF developed in collaboration with UC Investments ("UC"), the investment arm of the University of California and the index provider for the fund. The launch is backed by a $2.5 billion investment from UC, making it the largest ever U.S.-listed ETF launch.[1] The fund seeks to track the UC Investments 90/10 Endowment Strategy Index, which combines broad U.S. equity exposure with short-duration investment-grade corporate bond exposure. The index allocates 90% of its weight to the S&P 500(R) Index, representing large-cap U.S. equities, and 10% to the S&P U.S. Investment Grade Corporate Bond 1-3 Year Index, which includes U.S. dollar-denominated investment-grade corporate bonds with maturities between one and three years. UC and S&P Dow Jones Indices developed the custom index, which was inspired by UC's $7.9 billion Blue and Gold Endowment Pool, a long-term public markets strategy that since its inception seven years ago, has been the best performing product within UC's $236 billion investment portfolio.[2] The strategy reflects UC's conviction that low-cost, liquid, diversified public markets exposure can deliver compelling long-term returns while avoiding the complexity and illiquidity of traditional endowment models. By bringing this philosophy into an ETF wrapper, UCBG offers long-term investors access to UC's approach, which was previously available only within the institution's portfolio and directly to employees of its 10 campuses and six medical centers through its retirement savings program, the nation's second-largest public defined contribution program, behind only the federal government. "At UC Investments, we focus on building long term, cost-effective portfolios to support our hundreds of thousands of UC students, faculty, staff, and alumni for generations to come," said Jagdeep Singh Bachher, the University of California's Chief Investment Officer. "This record-breaking ETF launch makes our institutional investment philosophy available to a broader community of investors through the transparency, efficiency and accessibility of the ETF structure, while staying true to the principles that have guided our investment approach." The ETF builds on State Street's longstanding relationship with UC Investments. Today, State Street Investment Management provides asset management services to UC Investments' $236 billion[3] portfolio across pension, endowment, and other assets, while State Street Bank and Trust Company provides custody and other investment services. "Our relationship with UC Investments spans more than two decades and has always been driven by innovation. With this launch, we are bringing an endowment-inspired strategy to a far broader range of investors, delivered with the low cost and transparency that make ETFs so powerful," said Ronald O'Hanley, Chairman and Chief Executive Officer of State Street Corporation. "This partnership demonstrates what's possible when a leading asset owner and asset manager work together to turn a successful institutional investment strategy into an accessible solution for investors," said Yie-Hsin Hung, President and Chief Executive Officer of State Street Investment Management. "It reflects our commitment to helping clients extend their investment priorities to new markets and investor communities." And receive exclusive articles on securities markets The 2026 Global Markets Choice Awards are here! Nominations are officially OPEN for the celebration of excellence in global capital markets trading & technology. Nominate below: https://www.jotform.com/form/260086385121150 Delaware Life Insurance Company is becoming the first insurance carrier to offer an index that contains cryptocurrency, adding the BlackRock U.S. Equity Bitcoin Balanced Risk 12% Index to its fixed index annuity (FIA) portfolio. As the digital assets industry pushes toward Franklin Templeton is expanding its tokenized fund suite, signaling growing institutional demand for blockchain-based fund infrastructure and regulated investment products moving onchain. Read the full article below: $50 billion in active ETF inflows helped fuel a record year for @BlackRock 's iShares business, as investors continue to lean into active strategies.