24 of 24 Permanent Star Schema Jobs in London

Layer assets and analytics-ready datasets for enterprise consumption Building and maintaining data pipelines and transformation frameworks using dbt Designing dimensional data models and Star Schema structures Contributing to a rapidly evolving Data & AI capability What We're Looking For Essential Experience Excellent commercial experience with Snowflake Experience … delivering data solutions within Wealth Management, Asset Management, Investment Management or Financial Services environments Excellent understanding of Star Schema/dimensional modelling Strong experience with dbt Strong SQL and data engineering capability Strong data quality, lineage and governance experience Exposure to market data platforms and financial data ingestion ...

Snowflake Building and maintaining data pipelines and transformation frameworks using dbt Working with complex market, investment and risk datasets Designing dimensional data models and Star Schema structures Supporting portfolio suitability and regulatory reporting initiatives Implementing data quality, validation and governance controls Working closely with investment, risk and business … Leveraging modern engineering practices and AI-assisted development tools What We're Looking For Essential Experience Strong commercial experience with Snowflake Excellent understanding of Star Schema/dimensional modelling Experience with dbt Strong SQL and data engineering capability Experience working with time-series market data Exposure to market ...

Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

working with the Azure data stack (Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI engineering skills: data modelling (star schemas), advanced DAX, Power Query/M, performance tuning and RLS, alongside sound engineering discipline, PBIP/TMDL source format, Git-based version control, pull ...

reporting) using Azure services Work hands-on with tools including ADF, Synapse, ADLS and Microsoft Fabric Develop and optimise dimensional data models (Kimball/star schema) for analytics and reporting Provide technical guidance and support to BI Developers during delivery (non-managerial) Contribute to Power BI/semantic ...

similar modern cloud‐based analytics and data platforms. Strong experience designing and governing analytical data models using recognised patterns such as Medallion Architecture, star schema, and snowflake schema. Experience leading technical teams, mentoring engineers, and establishing engineering standards and delivery practices. Experience developing and implementing data quality, monitoring ...

query optimisation and working with the Azure data stack(Data Factory, Synapse/Fabric, SQL-based semantic layers). Advanced Power BI: data modelling (star schemas), advanced DAX, Power Query/M,performance tuning, RLS and deployment via pipelines. Astrong understanding of Power BI engineering discipline: PBIP/TMDLsource ...

Server, CosmosDB, Azure Data Factory, Purview, Synapse, Event Hub, Azure Databricks/Fabric) Extensive data modelling experience: both normalised relational models and de-normalised Star Schema/dimensional models Excellent relational database design skills with expertise in diagnosing and optimising performance across SQL Server, PostgreSQL, and cloud databases ...

stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time-series … Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. Strong SQL and analytical problem-solving skills. ...

Fabric. Experience delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills including star schema, fact tables, dimensions and semantic modelling. Strong Power BI skills including DAX and Power Query. Strong SQL skills and experience working with ...

delivering finance reporting and analytical solutions. Experience building Power BI reports and dashboards directly from Microsoft Fabric. Strong data modelling skills, including semantic models, star schema design, fact tables and dimensions. Strong Power BI experience, including DAX and Power Query. Strong SQL skills and experience working with multiple ...

accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business definitions Data quality … warehouses Strong commercial awareness Excellent understanding of financial reporting principles Experience partnering with Finance teams Strong SQL expertise Excellent dimensional modelling skills Experience designing star schemas Experience building enterprise reporting platforms Strong understanding of data governance Excellent stakeholder management skills Ability to communicate complex technical concepts to non-technical ...

building and designing products that use both real-time and batch data at scale, and an understanding of the underlying data architecture (e.g. lakehouse, star schema). Ability to write and validate SQL queries, and to trace data flows end-to-end to ensure data quality. Awareness ...

experience where appropriate, with a clear understanding of when SQL is the preferred solution. Experience designing robust data models using methodologies such as Kimball, Star Schema or Data Vault. Strong understanding of CI/CD, Infrastructure as Code and modern software engineering practices within data platforms. Experience building ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

team spirit Nice-to-Have Data Governance & Quality Hands-on experience with: Data Quality Data Governance practices Familiarity with modelling approaches such as: Star Schema OBT Knowledge of modern architectures: Medallion Lambda Kappa Experience building or contributing to cloud-based data platforms AWS preferred Familiarity with: S3 Glue ...

infrastructure using Trino/Presto and open table formats like Apache Iceberg or Delta Lake. Advanced Data Modeling: Deep expertise in Medallion Architecture patterns, Star Schemas, and processing semi‐structured financial data logs (JSON/Avro). Robust ETL/ELT Orchestration: Expert proficiency in data transformation engines (such ...

expert in Azure Databricks and Medallion Architecture Strong skills in PySpark, Python, Delta Lake and Unity Catalog Knowledge of Kimball data modelling, such as star schema, snowflake, etc. Strong SQL skills A flexible approach to getting things done with a focus on quality solutions This is an urgent ...

coding assistant experience in a professional setting Financial services background preferred; BCBS 239 awareness advantageous Desirable skills include: Data Vault 2.1 alongside Kimball/Star-schema modelling Data mesh, data product ownership and federated governance Knowledge graph platforms (Neo4j, Neptune) or knowledge of OWL, RDF and exposure ...

architecture across the organisation. Your Skills & Experience You will have strong commercial experience in: Data Architecture and Data Modelling in enterprise environments. Dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Designing semantic or curated data layers within modern cloud platforms. Medallion Architecture and Azure Data Lakehouse environments. ...

towards predictive and prescriptive analytics capabilities. YOUR SKILLS AND EXPERIENCE: You will bring strong capability in: Enterprise Data Architecture and Data Modelling. Dimensional modelling, star schemas, fact and dimension modelling, and Kimball methodologies. Designing logical, physical and analytical data models across complex environments. Azure Data Lakehouse and Medallion Architecture ...

prescriptive analytics. Your Skills & Experience You will bring strong commercial experience in: Data Architecture and Data Modelling within large-scale enterprise environments. Dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Designing and implementing Medallion Architecture frameworks. Building curated semantic layers within modern cloud data platforms. ...

govern enterprise-wide data models across bronze, silver and gold layers within a Medallion Architecture. Create scalable curated data models using dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Define semantic data layers, modelling standards, and governance frameworks to improve consistency, quality, and reusability. Manage logical … capabilities. YOUR SKILLS AND EXPERIENCE: Strong hands-on experience in Data Architecture and Data Modelling within enterprise-scale environments. Excellent knowledge of dimensional modelling, star schemas, semantic layers, and Kimball methodologies. Experience designing and implementing curated data models within cloud-based data platforms. Strong understanding of logical, physical, transactional ...