8 of 8 Permanent Snowflake Schema Jobs in London

DAX, M, advanced modelling techniques, DirectQuery, and Import. Strong SQL skills, with the ability to write complex queries for analysis and integration. Experience in dimensional modelling, including star and snowflake schema design. Demonstrated capability in time-travel and snapshot reporting methodologies. Practical experience with integrating data from Dataverse and Databricks into reporting workflows. Experience & Knowledge Proven experience as More ❯

ETL/ELT pipelines using SQL and Python Integrate internal/external data sources via APIs and platform connectors Model and structure data for scalable analytics (e.g., star/snowflake schemas) Administer Microsoft Fabric Lakehouse and Azure services Optimise performance across queries, datasets, and pipelines Apply data validation, cleansing, and standardisation rules Document pipeline logic and contribute to business More ❯

standards for clients across financial services and energy, helping to shape data strategies and improve architecture maturity. ROLE AND RESPONSIBILITIES Design and deliver relational (3NF) and dimensional (star/snowflake) data models Define modelling frameworks and best practices across client engagements Work closely with architecture teams to ensure alignment with data strategies Support metadata management, governance, and documentation processes More ❯

such as ERWin, Sparx, or RSA Your Skills and Experience 2-4 years of experience in data modelling or data architecture Exposure to relational and dimensional modelling (3NF, star, snowflake) Strong SQL and data warehousing knowledge Experience in financial services or consulting is highly desirable Strong communication and stakeholder engagement skills More ❯

into a more engineering-focused position, someone who enjoys understanding the business context just as much as building the data solutions behind it. You'll work extensively with Python , Snowflake , SQL , and dbt to design, build, and maintain scalable, high-quality data pipelines and models that support decision-making across the business. This is a hands-on, collaborative role … s confident communicating with data, product, and engineering teams, not a 'heads-down coder' type. Top 4 Core Skills Python - workflow automation, data processing, and ETL/ELT development. Snowflake - scalable data architecture, performance optimisation, and governance. SQL - expert-level query writing and optimisation for analytics and transformations. dbt (Data Build Tool) - modular data modelling, testing, documentation, and version … build, and maintain dbt models and SQL transformations to support analytical and operational use cases. Develop and maintain Python workflows for data ingestion, transformation, and automation. Engineer scalable, performant Snowflake pipelines and data models aligned with business and product needs. Partner closely with analysts, product managers, and engineers to translate complex business requirements into data-driven solutions. Write production More ❯

Masters What will you be doing? As the Analytics Engineer, you'll be at the center of how data flows across Decentralized Masters. You'll architect and own our Snowflake data warehouse, design automated data pipelines from marketing platforms, CRM systems, and payment tools, and build dashboards that turn complex data into clear, actionable insights for our leadership team. … engineering, SQL development, and business intelligence, offering a chance to make a direct impact on company-wide decision-making as we scale from $50M to unicorn status. Key Responsibilities Snowflake Data Warehouse Management Architect and manage our Snowflake environment (schemas, warehouses, users, roles) Design and implement data models using Bronze → Silver → Gold layer architecture Write advanced SQL to … transform, clean, and aggregate data from multiple sources Optimize query performance and costs in Snowflake Implement data governance and security best practices Data Pipeline & Integration Management Configure and maintain ETL/ELT tools (Fivetran, Airbyte, or similar) to sync data into Snowflake Connect data sources: HubSpot (CRM/marketing), ad platforms (Meta, Google, TikTok), Stripe (payments), and analytics More ❯

initiatives Your Skills and Experience 5+ years of experience in data modelling or architecture, ideally within financial services or consulting Strong knowledge of relational and dimensional design (3NF, star, snowflake) Proficient in ERWin, Sparx, or similar tools Experience working with semi-structured data (JSON, XML, Parquet) Excellent communication and client-facing skills More ❯

landscapes (MDM, CRM, ERP, Cloud DWH) through pragmatic and scalable architectural blueprints. Cloud Data Platform Leadership Design and implement high-performance cloud data platforms (AWS, Azure, Google Cloud, Databricks, Snowflake), overseeing data modelling, integration, transformation, and DevOps pipelines. Integrated Solution Architecture Design seamless integrations between cloud data platforms, AI/GenAI platforms, and business-critical systems (e.g., MDM, CRM … as a Data Architect, leading design and implementation of complex cloud-based data ecosystems. Solid engineering background with hands-on data platform implementation experience (AWS, Azure, GCP, Databricks, or Snowflake). Proven ability to evaluate data architecture decisions, influence business and IT stakeholders, and define strategic data direction. Strong understanding of coding best practices, code quality tools (e.g., SonarQube More ❯