Data Engineer Analytics, Assistant Vice President
State Street · London, England, GB
We are seeking an Analytics‑focused Data Engineer to design and build trusted, analytics‑ready datasets on a modern AWS and Databricks data platform.
Job description
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 workl...