Job Description
What we are looking for
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.
As Alpha Data Service(ADS) Implementation Consultant, you will be an integral player of the Charles River implementation team. ADS Consultants include all aspects of a consulting project, from installation of n-tier software and integration with third party systems to DR/HA design to document and perform technical training for the Alpha client. This role is a highly technical role and spans ETL/ELT data pipelines, Snowflake DWH, CI/CD deployment Pipelines and data-readiness(data quality) design, bespoke extensions and implementation.
Why this job is important to us
The team you will be joining is a part of Charles River Development (or CRD), that became a part of State Street in 2018. CRD helps create enterprise investment management software solutions for large institutions in the areas of institutional investment, wealth management and hedge funds. Together we have created the first open front-to-back platform - State Street Alpha, that was launched in 2019. Join us if delivering next generation infrastructure, using emerging technologies like AI and Blockchain sounds like a challenge you are up for.
What you are responsible for
- As ADS consultant, 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 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.
Education and Experience
- Bachelor’s degree or above with 13+ years on industry experience preferably in data warehousing and services
- Experience on Microsoft Azure cloud and Snowflake SQL, database query/performance tuning.
- Enterprise Data Management and Data Warehousing principles are all an advantage
- Strong Data warehousing Concepts, ETL tools such as Talend Cloud Data Integration tool.
- Experience with Qlik Replicate and Compose tools(Change Data Capture) tools is considered a plus
- 2-3 years of experience with cloud based (AWS, S3, Azure and Snowflake) data services
- Prior experience with active directory entitlement solutions (e.g. Cloakware, Sailpoint or other third party)
- 5-7 years’ working with SQL; (RDBMS, OLAP, DW)
- 3-5 years’ working knowledge of IT network architecture (Firewall, VPN) and related components for data sharing and file delivery (Enterprise Bus, NDM, Golden Gate, MQ, SFTP)
- 3-5 years’ experience working with infrastructure teams (networking, security, cloud services) as well as application teams on the delivery, access enablement and support of foundational and common cloud service capabilities
- Experience facilitating workshops with technology & business teams to identify requirements, make decisions quickly, seek alignment and/or mitigate risk
- Demonstrated people leadership skills; managing multiple directs and building global support teams
- Exposure to Autosys and UNIX scripting a plus
- Ability to thrive in a high-energy, fast-paced environment where tactical and strategic initiatives are driven in parallel, and requirements continue to evolve
- Effective communicator – can summarize succinctly and can provide details when needed
- Team oriented – capable of working in a global setting
- Strong Microsoft Office skills especially in Excel, Word, PowerPoint
- Self-motivated, charismatic and able to influence others at all levels of an organization
State Street's Speak Up Line
