ADS Data Solution Architect, Vice President

State Street; Greater London; On-site; GBP 90,000 - 130,000; Full time

Job summary

State Street is seeking a senior data platform professional to analyze and shape the Alpha Data Services platform, enabling scalable ingestion, enrichment and delivery of investment data across multi-asset classes.

You will design data models, lead ETL development with Snowflake, Azure and CI/CD pipelines, and collaborate with ADS clients and onboarding teams to drive rapid implementation and data readiness.

Qualifications

• Bachelor’s Degree in CS/IT/Finance/Accounting.
• 10–15 years of experience in data integration, governance, service architecture and data modelling.
• Hands-on ETL, Snowflake, CI/CD pipelines and data-readiness design, development and implementation.
• Experience in designing and implementing relational data models for audit, time series, complex relationships and high-volume data.
• Strong SQL knowledge and data warehousing concepts; exposure to SDLC practices.

Responsibilities

• Provide analysis and input into designs of Alpha Data Services platform to support a rapidly-growing business at scale.
• Provide data solutions to ADS clients and support client implementation and onboarding teams.

Skills

SQL

ETL

Snowflake

CI/CD

Data Modelling

Azure

Qlik Replicate

Kafka

Pentaho

Talend

Education

Bachelor's Degree

Tools

Pentaho

Talend Cloud Data Integration

Qlik Replicate

Job description

Job Description

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

Responsibilities Include:

Provide analysis and input into designs of Alpha Data Services platform to support a rapidly-growing business on a massive scale. Provide data solutions to ADS clients and support client implementation and onboarding teams.

Qualifications Include:

• Bachelor’s Degree in Computer Science, Information Technology, Finance, or Accounting
• 10-15 years of experience into data integration/orchestration services, data governance, service architecture and data modelling role
• Experienced hands-on ETL, Snowflake, CI/CD Pipelines and data-readiness design, development and implementation
• Experience in designing and implementing relational data models for a variety of data sets which include audit, time series, complex relationships, and high-volume
• Experience and understanding of system performance and profiling techniques of complex data model for storage and consumption
• Exposure to the business data domains like Holdings, Transactions, Security Reference data, Performance and Attribution, ESG etc.
• Demonstrated ability to rationalize problems and use judgment and innovation to define clear and concise solutions
• Demonstrate strong collaborative experience
• Good understanding of SDLC practices
• Experience on Azure and Snowflake architect/design/development is plus
• Experience with Qlik Replicate and Compose tools(Change Data Capture) tools is considered a plus
• Strong Data warehousing Concepts, ETL tools like Pentaho/Kettle, Talend Cloud Data Integration tool and Kafka.
• Strong SQL knowledge is a must.
• Exposure to the financial domain is considered a plus
• Cloud Managed Services like MS Azure/Devops is considered a plus
• Prior experience with State Street and Charles River Development (CRD) considered a plus
• External systems such as Bloomberg, Reuters, Rating agencies and Benchmark data providers

Key Attributes Include:

• Team player with professional and positive approach
• Flexible and can adapt easily to changing/evolving role requirements
• Creative, innovative and able to think outside of the box
• Strong attention to detail
• Self-motivated & self-sufficient
• Effective communicator both written and verbal
• Brings a high level of energy with enthusiasm to generate excitement and motivate the team
• Able to work under pressure with tight deadlines and/or multiple projects
• Experience in negotiation and conflict resolution

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, investment 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 you 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, experiences 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.

Discover more at StateStreet.com/careers

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Job ID: R-794853