Data Engineer Analytics, Assistant Vice President

State Street
London
1 day ago
Create job alert

This job is with State Street, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

We are seeking an Analytics‑focused Data Engineer to design and build trusted, analytics‑ready datasets on a modern AWS and Databricks data platform. This role is critical to enabling business intelligence, reporting, and advanced analytics by transforming raw data into well‑modeled, high‑quality, and performant analytics layers.
You will work closely with analytics, BI, finance, and product teams to ensure data is easy to consume, well understood, and reliable for decision‑making at scale.
Key Responsibilities
Analytics‑Ready Data Modeling
Design and implement analytics‑optimized data models (fact/dimension, star/snowflake schemas).
Build and maintain curated analytics layers (gold tables) in Databricks using Delta Lake.
Translate business requirements into clear, reusable datasets for dashboards and reports.
Support semantic consistency across metrics, dimensions, and KPIs.
Data Pipelines & Transformations
Develop and maintain ETL/ELT pipelines using Databricks (Spark SQL, PySpark).
Transform raw and intermediate data into clean, documented, and performant analytics datasets.
Implement incremental processing, partitioning, and optimization techniques for BI workloads.
Ensure pipelines are resilient, observable, and production‑ready.
AWS Analytics Platform
Leverage AWS services such as S3, Glue, Redshift, Lambda, and IAM to support analytics use cases.
Integrate Databricks with AWS storage and security services.
Monitor pipeline execution, performance, and cost for analytics workloads.
Data Quality, Metrics & Trust
Implement data quality checks, reconciliation logic, and anomaly detection for analytics data.
Validate accuracy of business metrics used in executive dashboards and reports.
Support data lineage, documentation, and metric definitions.
Partner with stakeholders to ensure a single source of truth for analytics.
BI & Analytics Enablement
Support downstream tools such as Power BI, Tableau, or similar BI tools.
Optimize datasets for dashboard performance and concurrency.
Collaborate with analysts to improve query patterns and data usage.
Enable self‑service analytics through well‑designed datasets and documentation.
Required Qualifications
5-8+ years of experience in data engineering or analytics engineering roles.
Strong experience with Databricks for analytics workloads.
Advanced proficiency in SQL (complex transformations, window functions, performance tuning).
Solid experience with AWS‑based analytics architectures.
Strong experience with data modeling for analytics.
Proficiency in Python or PySpark.
Experience supporting BI, reporting, and analytics teams.
Nice to Have
Experience with Analytics Engineering / ELT patterns.
Familiarity with dbt or similar transformation frameworks.
Experience supporting finance or executive reporting.
Knowledge of data governance, metric catalogs, or data discovery tools.
Experience with streaming data for near‑real‑time analytics.
Exposure to regulated or enterprise analytics environments.
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

Related Jobs

View all jobs

Data Engineer - Contract - 9+ Months

Senior Data Engineer

Data Engineer Lead (Openshift)

Data Engineer (18 Months FTC)

Data Engineer

Data Engineer (18 Months FTC)

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.