1 to 25 of 59 Star Schema Jobs in the UK

never been a better time to join Smiths. Design, build and deploy interactive Power BI dashboards and reports. Develop robust data models using star schema and dimensional modelling principles. Create and optimise DAX measures for performance and scalability. Deliver ETL processes across SAP, databases and other data sources. … proficiency in DAX and Power Query (M). Strong SQL skills and experience with relational databases. Solid understanding of data modelling (Kimball/Star Schema). Hands‐on experience with SAP data (ECC, BW extracts). Knowledge of ETL processes and data pipelines. Strong analytical and problem‐solving ...

insights into enterprise grade, productionised reporting. What You'll DoOwn the Gold Layer: Build and optimize high-performance Power BI semantic models and star-schema architectures within a Unified, AI-powered analytics platformProductionize Reports: Review, refine, and promote reports from domain workspaces (Finance, Financial Crime, Marketing) into central … level security (RLS).What You BringSignificant 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 SQLExposure to Microsoft Fabric, Azure Synapse, or Azure Data FactoryHigh technical rigor and diplomatic communicationYou catch ...

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

e.g., PostgreSQL, MySQL) and experience with modern data warehousing solutions (e.g., Snowflake, BigQuery, Redshift, Synapse). Data Modeling: Knowledge of data modeling principles (e.g., star schema, snowflake schema, normalization). Programming: Proficiency in Python and/or Scala for data processing and pipeline development. Agentic workflows: Experience ...

Strong proficiency in SQL and Python Strong experience with AWS (Batch, Lambda, Glue, ECR, RDS, Redshift, S3) Experience in data warehousing, database design (e.g., star schema, snowflake schema), and data modelling. Excellent problem‐solving skills and the ability to work independently and as part of a team ...

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

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

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

transform data from SQL Server databases, REST APIs, SaaS applications and file‐based exports. Develop and optimise SQL transformations, stored procedures and Kimball‐style star‐schema data models. Build and support Power BI semantic models and the datasets behind dashboards used by teams across the business. Implement data ...

transform data from SQL Server databases, REST APIs, SaaS applications and file‐based exports. Develop and optimise SQL transformations, stored procedures and Kimball‐style star‐schema data models. Build and support Power BI semantic models and the datasets behind dashboards used by teams across the business. Implement data ...

practices, such as SOLID principals, structuring code, testing, IOC, etc. Strong repositories, CI/CD skills. Strong knowledge of Kimball data modelling, such as star schema, snowflake, etc. Strong SQL skills. Strong data analysis skills. Excellent written and verbal communication skills A demonstrable track record of getting stuff ...

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. Understanding of Power BI engineering discipline: PBIP/TMDL source ...

Design, implement and maintain scalable ETL/ELT pipelines, ensuring data quality, integrity and reconciliation throughout the migration. Develop and optimise data warehouse structures, star schemas and dimensional models to support business and regulatory reporting. Apply best practices for Snowflake performance tuning, query optimisation and cost efficiency. Implement automated … design, query optimisation, performance tuning and troubleshooting. Significant experience designing and delivering enterprise-scale ETL/ELT solutions. Strong understanding of data warehousing principles, star schema design, dimensional modelling and data architecture. Experience with data governance, data quality and reconciliation within enterprise environments. Familiarity with Git-based source ...

Redshift. Experience working with data ingestion techniques, including change data capture (CDC), REST API integrations and incremental loading. Understanding of data modelling approaches, including star schemas, medallion architecture and slowly changing dimensions. Experience with Git, version control and CI/CD pipelines. An understanding of Infrastructure as Code principles ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

/ELT solutions. Knowledge of Lakehouse and Data Warehouse architectures. Experience with Data Pipelines, Dataflows Gen2, and Notebooks. Understanding of data modelling techniques, including star schemas and dimensional modelling. Experience with Power BI semantic models and reporting. Knowledge of data governance, security, and performance optimisation. Experience using ...

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

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

experience building and optimising semantic or data models at scale, including window functions and complex business logic. Solid understanding of data modelling principles - star schema, dimensional modelling, DAX. Experience with Power BI and the Microsoft Power Platform, including building on top of central/curated data models. Familiarity ...

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