Data Integration Developer, Assistant Manager

Title: Data Integration Developer – Assistant Manager

Department: Alpha Data Platform

Reports To: Data Integration Lead, Engineering

Summary:

State Street Global Alpha Data Platform , lets you load, enrich and aggregate investment data. Alpha 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.

Reporting to the Alpha Development delivery manager in <>, Data Integration  Developer is responsible for overall development life cycle leading to successful delivery and support of Alpha Data Platform(ADP) Services to clients.

Responsibilities:

• As a Data Integration Developer, be hands-on ETL/ELT data pipelines (Talend DI), Snowflake DWH, CI/CD deployment Pipelines and data-readiness (data quality) design, development, implementation and address code or data issues.

• Experience in designing and implementing modern data pipelines for a variety of data sets which include internal/external data sources, complex relationships, various data formats and high-volume.

• Experience and understanding of ETL Job performance techniques, Exception handling,

• Query performance tuning/optimizations and data loads meeting the runtime/schedule time SLAs both batch and real-time data uses cases.

• Demonstrate strong collaborative experience across regions (APAC, EMEA and NA) to come up with design standards, High level design solutions document, cross training and resource onboarding activities.

• Good understanding of SDLC process, Governance clearance, Peer Code reviews, Unit Test Results, Code deployments, Code Security Scanning, Confluence Jira/Kanban stories.

• Strong attention to detail during root cause analysis, SQL query debugging and defect issue resolution by working with multiple business/IT stakeholders.

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 5 - 8 years of experience in data integration/orchestration services, data architecture, design, development and implementations and providing data driven solutions for client requirements

• Experience in Snowflake DWH SQL, SQL server database query/performance tuning.

• Strong Data warehousing Concepts, ETL tools such as Talend Cloud Data Integration tool.

• Exposure to the financial domain knowledge is considered a plus.

• Cloud Managed Services such as source control code Github, MS Azure/Devops is 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 Factset, Opturo, Bloomberg, Reuters, MSCI and other Rating agencies is a plus.

Supervisory Responsibility:

☒ Individual Contributor      ☐ Team Lead             ☐ Manager of Managers

Travel:

May be required on a limited basis.