1 to 25 of 30 Permanent Star Schema Jobs in the UK excluding London

insights into enterprise grade, productionised reporting. What You'll Do Own the Gold Layer: Build and optimize high-performance Power BI semantic models and star-schema architectures within a Unified, AI-powered analytics platform Productionize Reports: Review, refine, and promote reports from domain workspaces (Finance, Financial Crime, Marketing … security (RLS). What You Bring Significant hands on experience productionising Power BI reports and managing live estates. Deep expertise in DAX, dimensional modelling (star schema), and layered data architectures. Demonstrable excellence with SQL Exposure to Microsoft Fabric, Azure Synapse, or Azure Data Factory High technical rigor ...

join a UKRI data initiative, enhancing, expanding and improving an existing enterprise data warehouse. The role requires strong hands-on experience with Kimball and star schema modelling, together with the SQL/data skills to take new source data and integrate it into an existing warehouse model. This ...

join a UKRI data initiative, enhancing, expanding and improving an existing enterprise data warehouse. You'll need strong hands-on experience with Kimball and star schema modelling , together with the SQL/data skills to take new source data and integrate it into an existing warehouse model. … requirements Strong experience with Kimball and star schema data modelling Experience enhancing and expanding existing enterprise data warehouses Proven ability to take source data and integrate it into an existing warehouse model Strong SQL and data skills Good understanding of enterprise data warehouse environments Strong stakeholder engagement ...

/ELT processes and large-scale data solutions. Strong understanding of data warehouse, data lake and Lakehouse architectures, including data modelling techniques such as star schema and dimensional modelling. Experience building secure, scalable and high-performing data platforms that support reporting, analytics and business intelligence requirements. Desirable experience ...

maintain reusable data sets and semantic models that support reporting and insight requirements. Apply good-practice data modelling techniques, including dimensional modelling and star schema design where appropriate. Work with business users to understand data requirements and translate them into scalable technical solutions. Data Migration & System Implementation Support ...

Server, Azure SQL Database and T-SQL. Experience with ETL/ELT and data integration tools, ideally Informatica. Strong understanding of dimensional modelling, including Star Schema. Experience optimising BI models, queries and reporting performance. Understanding of Power BI Service administration and governance. Experience working in an agile environment, ideally ...

https://www.mclh.co.uk/careers/employee-benefits/) What you will be doing Design, develop and maintain Power BI semantic models, including star schemas, relationships, calculated measures and DAX. Develop clear, intuitive and well-organised Power BI reports and dashboards, as well as maintaining and improving existing … measures, filter context and relationships. Good SQL development skills, including joins, aggregations, and window functions. Good understanding of dimensional modelling, including facts, dimensions and star-schema design. Experience working with relational databases and data warehouse environments. Strong attention to detail and a disciplined approach to validating the accuracy ...

Strong practical knowledge of modern data engineering tools, frameworks and best practice. Good understanding of data architecture principles and concepts such as medallion architecture, star schemas and slowly changing dimensions. Awareness of machine learning techniques and their application within a data environment would be beneficial. Knowledge of GDPR, data ...

data from APIs, databases, CRM, ERP and third party platforms • Support both batch and real time data processing • Develop semantic models and work with Star Schema and Kimball modelling • Implement CI/CD and automated deployment of data solutions • Build monitoring, data quality, lineage and observability into data ...

automation. Hands-on experience with cloud platforms (AWS, Azure, GCP). Familiarity with Databricks Workflows and other orchestration tools. Knowledge of data modelling methodologies (star schemas, Data Vault, Kimball, Inmon). Familiarity with medallion architectures, data lakehouse principles and distributed data processing. Experience with version control tools (GitHub, Bitbucket ...

including experience writing complex queries and stored procedures Hands-on experience with Power BI, Tableau or a similar BI platform Experience building data models (star schema, dimensional modelling) - desirable Familiarity with ETL tools and processes Experience with Azure Data Factory, SSIS or similar - desirable Strong stakeholder management ...

optimisation Stakeholder engagement and requirements gathering Communicating technical concepts to non-technical audiences Designing scalable reporting solutions using best-practice methodologies such as Kimball, Star Schema, or Medallion Architecture Azure DevOps or CI/CD processes Azure Databricks Databricks Genie or AI-assisted analytics tools Microsoft Fabric Agile ...

Data & Analytics Use SQL, Dataverse, Salesforce and other business data sources to support reporting and analytics requirements. Design and maintain efficient data models using star-schema and reporting best practices. Use Power Query and other transformation tools to cleanse, shape and prepare data for analysis. Develop trusted ...

will include: Designing, developing and maintaining Power BI dashboards and reports aligned with business requirements Building and optimising semantic models using best practices including star schema and DAX optimisation Developing and managing data pipelines within Microsoft Fabric using Dataflows Gen2, Lakehouse and Warehouse Translating stakeholder requirements into scalable ...

implementation to KPI standards. Semantic and dimensional data modelling - design comprehensive models from different source systems using state of the art modelling techniques, Kimbal, star schema and modern modelling tooling and automation of modelling. Data visualisation - ability to design clear, accurate, executive-ready outputs using tools such ...

support decision-making Strong SQL skills and hands-on experience with analytics and visualisation tools (Power BI preferred) Nice to have Experience with star schema and multi-dimensional data modelling Proficiency in Python Experience with dbt and/or Snowflake Let's connect. Let's grow. #J ...

strong hands-on experience with PySpark. Proven experience working with Databricks and Lakehouse architectures. Strong understanding of dimensional modelling, including fact tables, dimension tables, star schemas and semantic layers. Experience developing curated, analytics-ready datasets for business intelligence and analytics consumption. Ability to translate complex business requirements into well ...

reports from Excel or Tableau into Power BI. Exposure to modern data platforms (e.g. Microsoft Fabric, Azure). Understanding of data modelling concepts (e.g. star schema). Experience working within a centralised data or BI function. Interest in developing stakeholder management and analytical capability further. Benefits We believe ...

building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt Significant database experience in Snowflake and/or Oracle Star schema/dimensional modelling. Excellent SQL skills Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions ...

Power BI Strong working knowledge of Git/version control, CI/CD pipelines, and Python for automation Solid understanding of star schemas and Kimball methodologies Experience supporting advanced Power BI models (DAX and Power Query) Exposure to ML/AI concepts (e.g. scikit‐learn, TensorFlow) or an interest ...

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

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

Azure Data Engineer you should have experience of: Strong experience developing in SQL from creating database models from scratch Solid understanding of Data Warehousing (star schema, fact/dimension design) Expert in writing efficient TSQL code Proficient in query optimization, partitioning and index design. Good understanding of data ...

Azure Data Engineer you should have experience of: Strong experience developing in SQL from creating database models from scratch Solid understanding of Data Warehousing (star schema, fact/dimension design) Expert in writing efficient TSQL code Proficient in query optimization, partitioning and index design. Good understanding of data ...

Azure Data Engineer you should have experience of: Strong experience developing in SQL from creating database models from scratch Solid understanding of Data Warehousing (star schema, fact/dimension design) Expert in writing efficient TSQL code Proficient in query optimization, partitioning and index design. Good understanding of data ...