19 of 19 Star Schema Jobs in London

solutions that enable data-driven decision making. Key responsibilities include: Designing and developing Power BI dashboards and reports Building robust semantic models using Star Schema principles Developing advanced DAX measures and Power Query transformations Optimising report performance, datasets and refresh processes Integrating data from SQL Server, Azure, Databricks … practices Skills & Experience Strong commercial experience with Power BI Desktop & Service Advanced DAX, Power Query (M) and SQL skills Strong data modelling expertise using Star Schema Experience delivering performant enterprise reporting solutions A solid understanding of ETL and data warehousing concepts Excellent stakeholder engagement and communication skills Experience ...

develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability Partner with Data … solutions in production environments Advanced Power BI expertise, including semantic modelling, DAX, Power Query, and performance optimisation Excellent data modelling skills with experience of star schema and dimensional modelling techniques Strong SQL skills, including complex query writing, data validation, and performance tuning Experience working with enterprise data warehouses ...

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 ...

high-quality, trusted data products across the business. Key Responsibilities Define and own enterprise-wide data architecture standards, including Data Vault, semantic layer frameworks, star schema modelling patterns, and Snowflake design conventions. Design scalable integration patterns for legacy and modern data sources, ensuring strong governance, reconciliation, auditability … field. At least 4 years of hands-on Snowflake architecture and design experience. Proven expertise in Data Vault 2.0 and dimensional modelling methodologies, including Star Schema design. Strong knowledge of dbt and source control practices using GitHub. Experience integrating enterprise data platforms with AWS services and broader cloud ...

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 ...

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 ...

platform, with Power BI preferred; Tableau or Qlik acceptable depending on environment. Strong SQL skills and solid understanding of data modelling concepts, including star schemas, measures/metrics design and performance optimisation. Demonstrated ability to standardise KPIs and reporting approaches across multiple geographies, teams or business units. Strong communication ...

high-performance solutions aligned with your target data architecture. Master Data Modeling Techniques: Apply expertise in various data modeling approaches, including 3NF, Data Vault, Star Schema, and One Big Table (OBT). Clearly articulate the benefits and trade-offs of each method and optimize their implementation within columnar ...

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. ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

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 ...

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 ...

multiple platforms. Support the adoption of AI-enabled capabilities within the data ecosystem. Required Technical Skills Snowflake (expert level) Cortex AI (Snowflake Cortex AI) Star Schema Data Modelling Market Data integration and management Time-Series Data engineering and modelling Dbt (Data Build Tool) Claude Code Data warehousing ...

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 ...

Python in a modern data environment Experience working with cloud-based data platforms such as a lakehouse architecture Understanding of data modelling principles, including star schemas and data transformation Ability to work independently in a fast-moving and evolving environment Comfortable collaborating across teams and reviewing or guiding others ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Ability to independently drive the discovery phase, moving from a vague business problem to a structured ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Ability to independently drive the discovery phase, moving from a vague business problem to a structured ...

with the Standardized data layer practises (Medallion architecture) Exposure to Aurora Postgres and MongoDB Skills in designing efficient data models including normalization, denormalization, and schema design and an understanding around relational and star schemas. #J-18808-Ljbffr ...