7 of 7 Permanent Star Schema Jobs in England

scalable, future-proof data architectures and provide technical leadership across transformation programmes: Architecture & Design: Design enterprise data architectures for Snowflake and Azure cloud ecosystems Create dimensional data models (star schema, snowflake schema, Data Vault) supporting analytics and BI Define data strategy and governance frameworks – lineage, cataloging, security, compliance Lead solution design for data warehouse, data lake … technical challenges Conduct architecture reviews and design authority for data solutions Mentor engineers on best practices in data modeling, performance optimization, and cloud architecture ESSENTIAL SKILLS: Data Modeling expertise - Star schema, dimensional modeling, Data Vault, logical/physical design Snowflake Cloud Data Platform - Architecture design, performance tuning, cost optimization, governance Azure Data Factory - Pipeline architecture, orchestration patterns, best More ❯

Requirements Essential: Strong experience with SSRS, SSIS, SSAS, and Power BI Advanced SQL Server capabilities: T-SQL, stored procedures, and performance tuning Experience designing and building data warehouses and star schemas Strong ETL experience using SQL Server SSIS Proficiency with Power BI, including DAX and Power Query Experience with Visual Studio and Microsoft BI development tools Familiarity with source More ❯

proficiency in SQL - writing and optimizing complex queries, joins, window functions, performance tuning. Experience with dbt (or equivalent) - building models, tests, documentation, version control. Understanding of data warehousing concepts (star schemas, snowflake, slowly changing dimensions, partitioning, clustering). Experience working in a modern data stack (e.g. BigQuery, Snowflake, Redshift, Databricks, etc.) Comfortable working downstream (with BI/analytics users More ❯

in a fast-moving environment. Ability to build good, professional relationships, both internally and externally as a representative of Reed In Partnership. Technical skills: Snowflake Scheme Design, Kimball Methodology, Star Schemas Programmes: Snowflake More ❯

design, implementation, and testing of 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 matter experts to gather requirements More ❯

Collaborate with stakeholders to understand requirements and deliver practical solutions. Ensure data quality and consistency across reporting pipelines. What We’re Looking For Power BI Expertise: Advanced data modelling (STAR schema, relationships, filter direction). Strong DAX skills for measures and calculations. Experience optimizing performance for large datasets. Excel Mastery: Advanced formulas (SUMIFS, COUNTIFS, text functions). Dashboard More ❯

Ensure documentation, data dictionaries, lineage, and governance standards are embedded across the team. Essential Skills Strong expertise with SQL , particularly Databricks SQL . Demonstrable experience designing data models (e.g., star schema) and scalable architecture. Knowledge of Azure Modern Data Warehouse tools: Synapse, Databricks, Delta Lake, Unity Catalog. Experience with pipeline orchestration (e.g., Synapse pipelines). Proven background in More ❯