This role can be based out of Boston, New York , New Jersey, PA, and California - Los Angeles - San Francisco.

What we are looking for

As a ETL Developer you will be an integral player of the Charles River implementation team. ETL Developers brings technical expertise and direction to implementation teams, ensuring proper implementation of Charles River’s IMS suite at our clients. Technical implementations include all aspects of a consulting project, from installation of n-tier software and integration with third party systems to DR/HA design to documenting and performing technical training for the client. This role is a highly technical role and spans XML messaging, Charles River web services API, ETL tool usage, database administration task, Java and or C# programming.

Why this job is important to us

The team you will be joining is a part of Charles River Development (or CRD), that became a part of State Street in 2018. CRD helps create enterprise investment management software solutions for large institutions in the areas of institutional investment, wealth management and hedge funds. Together we have created the first open front-to-back platform - State Street Alpha, that was launched in 2019. Join us if delivering next generation infrastructure, using emerging technologies like AI and Blockchain sounds like a challenge you are up for.

What you will be responsible for

• Lead and manage multiple technical initiatives, potentially on multiple projects simultaneously.
• Develop with a result-driven approach while maintaining implementation schedules.
• 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 across environments.
• Implement data quality checks, exception handling and data lineage.
• Collaborate with other developers and analysts understand requirements and deliver high-quality solutions.
• Create and maintain technical documentation for ETL processes and data architecture.
• Participate in functional and technical requirements gathering and review.
• Create, test, and correct inbound and outbound interfaces.
• Collaborate with team members including business analysts, project managers, and customer staff.
• Serve as a technical expert in implementation projects.
• Contribute to the technical documentation.

What we value

• Experience with Talend ETL tool
• Strong experience working with snowflake including data loading, performance tuning, and SQL development
• Proficiency in SQL and understanding of relational and dimensional data modeling
• Experience in working with cloud platforms Azure/AWS/GCP is plus
• Familiarity with version control tools like Git
• Java and C# programming
• Windows and Unix (Linux)
• Knowledge of ETL tools such as Kettle and Talend
• Familiar with at least one SCM (Perforce would be a plus)
• XML and XSLT
• Understanding of ERDs
• Tomcat configuration and optimization
• N-tier application architecture
• SOAP/XML and messaging software like MQ Series, MSMQ, Sonic MQ, Open JMS, Kafka
• In-depth knowledge of one of the following RDBMS: Oracle or MS SQL Server
• Perl
• Self-motivated and Self-driven
• BS/MS in Computer Science or equivalent field.
• Ability to work in a dynamic, fast-paced, team environment
• Experience in methodology-based solution delivery and managing customers’ expectations
• Problem solving skills and ability to recognize long term solutions across multiple projects
• Must be detail-oriented and have the ability to multi-task.
• Self-starter, able to work both independently and as part of a team
• Excellent communication skills (verbal and written); good interpersonal skills; ability to gather and understand requirements in the financial sector; solid client interaction skills

Strong preference

• System integration using ETL tools - Talend / Kettle
• Financial services industry experience - required
• Previous consulting background
• Previous Investment Software experience
• Experience with Azure and Snowflake 
• Previous OMS/buyside implementation experience

Education & Preferred Qualifications:

• A BA/BS degree in a business or technical field including Finance, Economics, Engineering or Computer Science.
• A minimum of 5 + years of progressively responsible experience in the Financial / Software Services industry (Financial market information systems background preferred).
• The ability to travel to client sites throughout the United States and Canada as well as the ability to work effectively when remote from clients.
• Travel 25-35% is typical and but may exceed that in any given year.

Key words: Fixed Income, Derivatives, FX, Equities, Market Data, Security Master, Reference Data, Buyside, Front-Office, Middle-Office, Performance Measurement.

About State Street

What we do: State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world.  From technology to product innovation we're making our mark on the financial services industry.  For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people.  We provide investment servicing, data & analytics, investments research & trading and investment management to institutional clients.

Work, Live and Grow: We make all efforts to create a great work environment.  Our benefits packages are competitive and comprehensive.  Details vary in locations, but you may expect generous medical care, insurance and savings plans among other perks.  You'll have access to flexible Work Program to help match your needs.  And our wealth of development programs and educational support will help you reach your full potential.

Inclusion, Diversity, and Social Responsibility: We truly believe our employees' diverse backgrounds, experience and perspective are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients.  We warmly welcome the candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality.  Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader.  You will have tools to help balance your professional and personal life, paid volunteer days, matching gift program and access to employee networks that help you stay connected to what matters to you.

State Street is an equal opportunity and affirmative action employer.

Discover more at www.StateStreet.com/careers 

Salary Range:

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.