1 to 25 of 29 Star Schema Jobs in London

Snr Data Modeller

Hiring Organisation
SSA Digital Recruitment
Location
London, United Kingdom
Employment Type
Contract
Contract Rate
£580 - £600/day
/1day a month Leeds or London Office Contract - 12 mths Rate £(Apply online only)pd Skills - Data Modelling, SQL, Dimensional Modelling, Data Warehousing, Star Schema, Snowflake Schema, Data Products, Kimball, Data Architecture, GCP We're looking for an experienced Data Modeller to help shape and standardise … purpose. What we're looking for: Strong Data Modelling experience across conceptual, logical and physical models. Expertise in relational modelling, dimensional modelling, Star Schema, Snowflake Schema and Data Warehousing. Strong SQL skills and understanding of data structures, relationships and transformation. Experience with Kimball, Inmon, 3NF and Data ...

Analytics Engineer

Location
Greater London, England, United Kingdom
Five Guys. WHAT YOU'LL DO Build and look after the semantic layer Own the models the business reports from. Design and maintain dimensional (star schema) models in the Fabric gold layer and Power BI semantic models. Write and maintain the measures and business logic in the semantic … evolving. YOUR EXPERIENCE Solid experience in analytics engineering, BI development or a similar data role. Strong SQL and dimensional data modelling (Kimball/star schema). Strong Power BI experience: semantic models, DAX and performance tuning. Comfortable with Git-based workflows and pull requests. Able to work with ...

Microsoft Fabric Data Engineer

Location
Greater London, England, United Kingdom
PySpark, Spark SQL, T-SQL and KQL, optimizing Delta tablesAdd data quality checks, validation rules, logging and alerting to data pipelinesBuild enterprise semantic models (star schema) using Direct Lake, Import or DirectQuery as specified in the architectureWrite efficient DAX measures, calculation groups and Power Query (M) transformationsBuild reports ...

Senior Data Engineer – Azure Databricks

Location
Greater London, England, United Kingdom
skills for transformations, data modelling, and debugging data issues Experience building and supporting ingestion pipelines end to end Understanding of data modelling for analytics (star schema, facts/dimensions) and how schema changes affect downstream users Exposure to layered data architectures (e.g. bronze/silver/gold ...

AI Data Engineer: NLP & LLM ETL in Snowflake/Azure

Location
City Of London, England, United Kingdom
varied unstructured content into structured meta-data; Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs; Solid ETL development, reporting knowledge based off intricate understanding of business process and measures; Knowledge of Snowflake ...

Data Engineer (AI) - London

Location
City Of London, England, United Kingdom
varied unstructured content into structured meta-data. Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs. Solid ETL development, reporting knowledge based off intricate understanding of business process and measures. Knowledge of Snowflake ...

Microsoft Fabric Solution Architect

Location
Greater London, England, United Kingdom
plus years in a solution architect roleOne-plus year of Microsoft Fabric experienceTwo-plus years of Power BI experience: enterprise semantic model design, star schema modeling, DAX concepts, performance and capacity management and tenant administrationEnough hands-on ability to validate prototypes, review pipelines, notebooks, semantic models ...

Senior Data Analyst

Location
Greater London, England, United Kingdom
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 ...

Senior Data Engineer

Hiring Organisation
Munich Re
Location
Greater London, United Kingdom
Employment Type
Full Time
within the insurance industry, ideally with exposure to Delegated Authority and/or Large Single Risk/Specialty business Familiarity with dimensional modelling concepts (star schemas, slowly changing dimensions) as applied within a modern lakehouse environment Thought Leaders: You are seen as an expert in your field and will ...

Senior Fabric Engineer

Location
Greater London, England, United Kingdom
Warehouse) Azure Data Services (Synapse, Data Factory, Data Lake) SQL (advanced) and Python/Spark for data transformation Strong understanding of data modelling (e.g. star schema) Experience building scalable data pipelines for large datasets Experience in financial services data environments (desirable) #J-18808-Ljbffr ...

Junior Analytics Engineer

Location
City Of London, England, United Kingdom
internship or academic project. Foundational SQL, with a willingness to build proficiency in optimising data models. Basic familiarity with data modelling concepts such as star schema or dimensional modelling. Exposure to Databricks, Microsoft Fabric, Azure Synapse or Snowflake. Awareness of Power BI or other BI tools. Curiosity about ...

Senior BI Analytics Engineer

Location
Greater London, England, United Kingdom
Snowflake ) Proven experience with dbt (modelling, testing, documentation) Experience building dashboards in Looker ( LookML is a strong plus) Solid understanding of data modelling concepts (star schema, dimensional modelling) Experience working with large-scale datasets Strong communication skills with the ability to work with non-technical stakeholders NICE ...

Data Engineer

Location
Greater London, England, United Kingdom
Strong SQL skills for data extraction, transformation and analysis Working proficiency in Python or PySpark for data processing Strong understanding of data modelling (e.g. star schemas and dimensional modelling) and data warehousing concepts, including how to structure data for downstream analytics Strong Power BI skills, including DAX, data modelling ...

Data Architect | 3-Month Contract | Outside IR35 | £550-£600/day | Hybrid (London)

Location
Greater London, England, United Kingdom
reporting and analytics capabilities through the design of Gold Layer and Semantic Models, supporting executive reporting, financial reporting, enterprise KPIs, dimensional modelling, and star-schema based data structures. The organisation is currently progressing a strategic migration from Azure Synapse to Microsoft Fabric, making experience with modern Microsoft data … Quality Data Lineage, Source-to-Target Mapping and Transformation Design Data Cataloguing tools such as Microsoft Purview Gold Layer, Semantic Modelling, Dimensional Modelling and Star Schemas Microsoft Azure and Microsoft Fabric (Fabric Desirable) Excellent stakeholder management and business-facing communication skills Data Architect | 3-Month Contract | Outside IR35 ...

BI Developer (12-18 month FTC)

Location
Greater London, England, United Kingdom
building and maintaining ETL processes and data pipelines - Solid understanding of data warehousing concepts and dimensional modelling - Experience working with semantic models, tabular models, star schemas, Kimball methodologies, or similar data modelling approaches - Exposure to SSAS, DAX, and BI solution development - Experience working across different data architectures and technology ...

Senior Manager, Data Engineering

Location
Greater London, England, United Kingdom
/Sub, and Cloud Scheduler* Experience with Infrastructure as Code (Terraform) for provisioning and managing cloud resources.* Solid understanding of data modelling techniques (star schema, dim/fact architecture, slowly changing dimensions).* Comfortable with Git (GitHub, branching strategies, pull requests) and CI/CD (Cloud Build ...

Commercial Finance – Analytics & BI Developer

Location
Greater London, England, United Kingdom
source, query and validate data for reporting or analytics. Proven hands-on experience designing and building Power BI semantic models from scratch, including star-schema design and DAX, and delivering reporting solutions through to production release Evidence of preparing or transforming data using an ETL or data-preparation ...

Data Analyst

Hiring Organisation
Arcas Technology Ltd
Location
London, City of London, United Kingdom
Employment Type
Permanent
Salary
£45000 - £50000/annum
bring Around 2 to 3 years’ experience in a data analyst or similar role Strong Power BI skills, including DAX and data modelling (star schema, fact and dimension tables) Good SQL skills Advanced Excel (Power Query, pivots, lookups) A proactive, curious approach, with the confidence to engage with ...

Senior Analytics Engineer

Location
Greater London, England, United Kingdom
system observability, and experience with source control tools like GitHub. Hands on experience with dbt or similar transformation tools. Strong data modelling principles, including star schema, and best practices for building scalable data assets that can be used in BI and other user facing tools. Experience working with ...

Senior Software Engineer II - Data Onboarding & Reporting

Location
Greater London, England, United Kingdom
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 ...

Business Intelligence Specialist

Location
Greater London, England, United Kingdom
Microsoft BI technologies. Responsibilities Design, develop, implement, and maintain business intelligence using Microsoft BI technologies. Understand and implement data modeling using best practices and star schema design. Analyze complex data from multiple sources including SQL Server databases and Analysis Services Tabular models. Collaborate with business analysts and subject ...

Python Engineer Data Domains

Location
Greater London, England, United Kingdom
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 ...

Data Engineer - Senior Manager

Location
Greater London, England, United Kingdom
Platform: BigQuery, Cloud Run, Cloud Functions, Cloud Storage, Pub/Sub and Cloud Scheduler. Terraform: provisioning and managing cloud infrastructure as code. Data modelling: star schemas, dimension/fact architecture and slowly changing dimensions. Git and CI/CD: branching, pull requests and automated delivery using Cloud Build ...

Data Architect-Snowflake/DBT/Azure

Location
City Of London, England, United Kingdom
marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs). Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong ...

Data Modeler

Location
City Of London, England, United Kingdom
clients’ enterprise data architectures. Our clients are increasingly building multiple data products, each serving different business needs and each needing its own schema, but all sharing common business entities, definitions and datasets. You’ll design the models for individual products while making sure they stay consistent, interoperable and reusable … Design logical and physical data models for multiple data products, balancing product-specific requirements with enterprise-wide consistency. Build dimensional models, including star schemas, fact tables and dimensions. Identify shared business entities, common datasets and conformed dimensions that can be reused across data products. Engage directly with business stakeholders ...