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 Data Integration Developer/Sr Data Integration Developer you are responsible for overall development life cycle leading to successful delivery and support of Alpha Data Platform Services to clients.
Responsibilities:
1. As a Data Integration Developer/Sr Developer, you will be hands-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.
2. You will conduct query performance tuning/optimizations and data loads to meet the SLAs for both batch and real-time data uses cases.
3. Part of your role will ned you to investigate problems and work on your own to solve and innovate clear and concise solutions.
4. 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.
5. 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.
6. Leverage SQL query debugging and defect issue resolution processes to conduct root cause analysis while working with multiple business/IT stakeholders.
Qualifications:
Education:
7. 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:
8. A minimum of 6-10 years of experience in data integration/orchestration services
9. Strong Data warehousing Concepts, ETL tools such as Talend Cloud Data Integration tool
10. Strong SQL knowledge and debugging skills is a must
11. Experience in service architecture and providing data driven solutions for client requirements
12. Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning
13. Exposure to the financial domain knowledge is considered a plus
14. Prior experience with State Street and Charles River Development (CRD) considered a plus
15. Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus
16. Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus
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.