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.
- 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.