Data Integration Developer

Data Integration Developer

Posted 2 days ago by 1758205642

Negotiable
Undetermined
Hybrid
Dublin, County Dublin, Ireland

Summary: The Data Integration Developer role at State Street involves leading the development life cycle for the Alpha Data Platform, focusing on ETL/ELT data pipelines and ensuring data quality. The position requires collaboration across regions to establish design standards and support the delivery of data services to clients. The developer will also address code and data issues while implementing modern data pipelines for various data sets. This role is critical for enhancing the management of multi-asset class data for Alpha Clients.

Key Responsibilities:

  • Develop and support ETL/ELT data pipelines, Snowflake DWH, and CI/CD deployment pipelines.
  • Design and implement modern data pipelines for diverse data sets from internal and external sources.
  • Optimize ETL job performance, handle exceptions, and ensure data loads meet SLAs.
  • Collaborate with teams across regions to establish design standards and conduct resource onboarding.
  • Participate in SDLC processes, including code reviews, testing, and security scanning.
  • Conduct root cause analysis and resolve defects by collaborating with business and IT stakeholders.

Key Skills:

  • 4-10 years of experience in data integration/orchestration services and service architecture.
  • Proficiency in Microsoft Azure cloud and Snowflake SQL, including performance tuning.
  • Experience with ETL tools such as Talend Cloud Data Integration.
  • Familiarity with Qlik Replicate and Compose tools is a plus.
  • Strong SQL knowledge and debugging skills.
  • Exposure to financial domain knowledge and third-party data providers is advantageous.
  • Experience with cloud managed services like GitHub and MS Azure/DevOps.
  • Prior experience with State Street and Charles River Development is a plus.

Salary (Rate): £380.00 daily

City: Dublin

Country: Ireland

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Data Integration Developer – HIRING ASAP

Start date: ASAP
Duration: 4 Months
Location: 1-2 days per week in the Dublin office. 3-4 days per week remote.
Rate: €400 - €446 per day

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, you’d be 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/Sr Developer, be hands-on ETL/ELT data pipelines, 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 includes 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.
  • Demonstrated ability to rationalize problems and use judgment and innovation to define clear and concise solutions.
  • 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.

Experience:

  • A minimum of 4-10 years of experience into data integration/orchestration services, service architecture and providing data driven solutions for client requirements.
  • Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning.
  • Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus.
  • Strong Data warehousing Concepts, ETL tools such as Talend Cloud Data Integration tool is must.
  • 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.
  • Prior experience with State Street and Charles River Development (CRD) considered a plus.
  • Experience in tools such as Visio, PowerPoint, Excel.
  • Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus.
  • Strong SQL knowledge and debugging skills is a must.