Taro Logo

ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

State Street is one of the largest custodian banks, asset managers and asset intelligence companies providing investment services worldwide.
New York, NY, USABerwyn, PA, USA
$100,000 - $160,000
Data
Senior Software Engineer
Hybrid
5,000+ Employees
5+ years of experience
Finance · Enterprise SaaS

Description For ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

State Street's Charles River Development division is seeking an experienced ETL Developer to join their implementation team. This role represents a unique opportunity to work with the Charles River IMS suite, focusing on technical implementations and integrations.

The position involves working with State Street's innovative front-to-back platform - State Street Alpha, launched in 2019. As an ETL Developer, you'll be responsible for designing and implementing data pipelines, working with Talend and Snowflake technologies, and ensuring proper integration with various third-party systems.

The role combines technical expertise with consulting responsibilities, requiring both strong programming skills and excellent communication abilities. You'll work on multiple projects simultaneously, leading technical initiatives and collaborating with cross-functional teams including business analysts, project managers, and customer staff.

Key technical aspects include working with Talend ETL tools, Snowflake cloud data warehouse, Java/C# programming, and various messaging systems like Kafka. The position requires experience with cloud platforms (Azure/AWS/GCP) and strong SQL skills.

The company offers comprehensive benefits including medical care, insurance plans, flexible work arrangements, and development opportunities. With State Street's global presence and focus on financial services technology, this role provides excellent exposure to cutting-edge financial technology implementations.

This position offers a competitive salary range of $100,000 - $160,000 annually and requires 25-35% travel. The role can be based out of multiple locations including Boston, New York, New Jersey, Pennsylvania, and California (Los Angeles/San Francisco), offering flexibility in terms of work location.

As part of Charles River Development, acquired by State Street in 2018, you'll be working with a leader in enterprise investment management software solutions, serving institutional investment, wealth management, and hedge fund sectors. The company's commitment to innovation, including emerging technologies like AI and Blockchain, makes this an exciting opportunity for a technical professional looking to advance their career in financial technology.

Last updated 2 hours ago

Responsibilities For ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

  • Lead and manage multiple technical initiatives across multiple projects
  • Design, develop, and maintain ETL Processes using Talend
  • Integrate various data sources into snowflake cloud data warehouse
  • Develop data pipelines for ingestion, transformation, and loading
  • Optimize ETL performance and troubleshoot data issues
  • Implement data quality checks, exception handling and data lineage
  • Create and maintain technical documentation
  • Participate in requirements gathering and review
  • Create, test, and correct inbound and outbound interfaces
  • Serve as a technical expert in implementation projects

Requirements For ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

Java
Kafka
PostgreSQL
  • Experience with Talend ETL tool
  • Strong experience with Snowflake including data loading and SQL development
  • Proficiency in SQL and understanding of relational data modeling
  • Experience in cloud platforms Azure/AWS/GCP
  • Java and C# programming skills
  • Knowledge of Windows and Unix (Linux)
  • Experience with XML and XSLT
  • Understanding of ERDs
  • Experience with SOAP/XML and messaging software
  • In-depth knowledge of Oracle or MS SQL Server
  • BS/MS in Computer Science or equivalent field
  • 5+ years of experience in Financial/Software Services industry
  • Excellent communication skills
  • Ability to travel 25-35%

Benefits For ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

Medical Insurance
Dental Insurance
Vision Insurance
401k
  • Medical care
  • Insurance plans
  • Savings plans
  • Flexible work program
  • Development programs
  • Educational support
  • Paid volunteer days
  • Matching gift program

Interested in this job?

Jobs Related To State Street - Charles River Development ETL Developer / Talend - Snowflake AVP - Front-Office / Investment Software Implementation

Senior Software Engineer, Data and Statistical Modeling (12-Month LTE)

Senior Software Engineer position at Gates Foundation focusing on data and statistical modeling for global health initiatives, offering competitive compensation and comprehensive benefits.

Senior Data Engineer

Senior Data Engineer position at LSEG, focusing on Snowflake/Python development for SwapAgent Reporting team, requiring 5+ years experience in system & database design.

Senior Database Engineer

Senior Database Engineer position at AIG focusing on enterprise database management, optimization, and modernization, offering competitive compensation and comprehensive benefits.

Senior Analytics Developer

Senior Analytics Developer position at LexisNexis, focusing on machine learning, data engineering, and analytics solutions, based in Farringdon.

Senior Analytics Developer

Senior Analytics Developer position at LexisNexis, focusing on data science, machine learning, and analytics solutions, with opportunities to work on cutting-edge AI technologies and enterprise-scale data projects.