Senior Engineer, ETL & Java, AVP

Summary

Charles River Development (CRD) is the FinTech division of State Street. Together with State Street's Middle and Back-office services, Charles River's cloud-based Front Office technology forms the foundation of the State Street Alpha® Platform, the first front-to-back solution in the industry. The Alpha Data Platform, lets you load, enrich and aggregate investment data. Leveraging this, our clients will be able to manage multi-asset class data from any service provider or data vendor for a more holistic and integrated view of their holdings. This platform reflects State Street's years of experience servicing complex instruments for our global client base and our investments in building advanced data management technologies. As the Talend Principal ETL Developer you are responsible for overall development life cycle leading to successful delivery and support of Alpha Data Platform Services to clients. Ability to integrate Spring Boot microservices into your Talend solution and should be able to develop micro-services as needed.

Responsibilities

• As a ETL Java Developer/Sr Developer, hands-on experience on ETL data pipelines, Snowflake data warehouse, CI/CD deployment Pipelines and data-readiness (data quality) design, development, implementation and address code or data issues.
• You will conduct query performance tuning/optimizations and data loads to meet the SLAs for both batch and real-time data uses cases.
• Part of your role will need you to investigate problems and work on your own to solve and innovate clear and concise solutions.
• As a global team, leverage your collaborative experience to work across regions (APAC, EMEA, and North America) to come up with design standards, high-level design solutions document, cross training and data onboarding activities.
• You will partake in the creation of artifacts to align with the global SDLC process, Governance clearance, conduct peer code reviews and Unit Test Results, be involved in Code deployments, and create Confluence Jira/Kanban stories.
• Leverage SQL query debugging and defect issue resolution processes to conduct root cause analysis while working with multiple business/IT stakeholders.
• You will take part in support activities for client implementations and deliver solutions to improve operations.
  
  

Qualifications

Education:

• B.S. degree (or foreign education equivalent) in Computer Science, Engineering, Mathematics, and Physics or other technical course of study required. MS degree strongly preferred.
  
  

Experience

• A minimum of 12 - 17 years of experience in ETL Integration & Java Development.
• Knowledge on Talend Studio R2022 and higher
• Strong Data warehousing concepts, data modelling and data quality
• Strong SQL knowledge and debugging skills is a must
• Strong experience using any ETL reference projects and external Java libraries
• Experience in service architecture and providing data driven solutions for client requirements
• Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning
• Experience using Microsoft Azure tooling like Azure Key Vault, Blob Storage, etc.
• Exposure to the financial domain knowledge is considered a plus
• Prior experience with State Street and Charles River Development (CRD) considered a plus
• Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus
• Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus
  
  

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you'll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Job ID: R-796207