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
Staff Software Engineer
Hybrid
5,000+ Employees
5+ years of experience
Finance · Enterprise SaaS
This job posting may no longer be active. You may be interested in these related jobs instead:

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

Charles River Development, a State Street company, is seeking an experienced ETL Developer to join their implementation team. This role is crucial in implementing Charles River's IMS suite for clients, focusing on technical expertise in ETL development, particularly with Talend and Snowflake integration.

The position offers an opportunity to work with State Street's Alpha platform, the first open front-to-back investment management platform. The role combines technical expertise in ETL processes, data warehousing, and integration with business understanding in the financial services sector.

As an ETL Developer, you'll be responsible for designing and implementing data pipelines, ensuring data quality, and optimizing performance across environments. The role requires strong technical skills in Talend, Snowflake, SQL, and Java, along with experience in cloud platforms and messaging systems.

The ideal candidate will have 5+ years of experience in the Financial/Software Services industry, with strong technical capabilities and excellent communication skills. The position offers competitive compensation ($100,000 - $160,000 annually) and comprehensive benefits including medical care, insurance plans, and development opportunities.

Working at State Street provides exposure to cutting-edge technology in financial services, including AI and Blockchain. The company values diversity and inclusion, offering a collaborative environment where employees can grow professionally while contributing to significant financial technology solutions.

This hybrid role allows for flexible work arrangements but requires 25-35% travel to client sites throughout the United States and Canada. The position represents an excellent opportunity for experienced professionals looking to advance their careers in financial technology while working with a global leader in investment services.

Last updated 2 months 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
  • 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
Vision Insurance
Dental 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?