1 to 25 of 29 Star Schema Jobs in England

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

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

development Proven experience building batch and streaming data pipelines Experience implementing Medallion Architecture and Lakehouse patterns Strong understanding of data modelling techniques (dimensional, star schema, data vault) Experience with CI/CD, Infrastructure as Code and DevOps practices, Git-based source control and deployment pipelines Strong understanding ...

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

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

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

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

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

Python and statistical modelling techniques. Experience working with Snowflake or similar cloud-based data warehouse technologies. Understanding of data modelling principles, including dimensional and star schema modelling. Experience with Power BI and data visualisation best practices. Familiarity with CI/CD processes, version control, testing, and software development ...

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

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

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 datasetsStrong communication skills with the ability to work with non-technical stakeholdersNICE TO HAVEHands ...

with Microsoft Fabric, Azure Databricks and Azure Data Factory. Solid knowledge of Delta Lake, Medallion Architecture, PySpark and SQL. Expertise in dimensional modelling and star schema design. Advanced Power BI development, including DAX and semantic modelling. Experience with Azure security, governance, DevOps and CI/CD practices. Proven ...

Proven ETL development and data pipeline experience. Solid understanding of data warehousing principles and best practices. Experience with dimensional modelling, including concepts such as star schema, semantic models, tabular models and Kimball methodologies. Exposure to DAX development. Experience working across complex data environments and multiple stakeholders. Strong problem ...

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

data warehouse projects Experience working with Power BI, Tableau, Qlik, Cognos, or similar BI platforms Strong understanding of data modelling concepts , including facts, dimensions, star schemas, semantic models, and reporting architectures Experience working with Kimball-style dimensional modelling methodologies Experience designing, supporting, or validating semantic data models for reporting ...

will have strong commercial experience with: SQL Server and SQL development. ETL development and data pipeline engineering. Data warehousing principles and dimensional modelling. Star schema, Kimball methodologies, semantic models, and tabular models. DAX. Working within fast-paced delivery environments. Communicating effectively with both technical and non-technical stakeholders. ...

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

Isio’s DBA strategy. Working with relevant stakeholders. Own and maintain the database architecture for Isio's data warehouses and connected operational systems, including schema design, indexing strategy and query optimisation. Operational and technical responsibility for the data systems. Define and enforce database backup schedules, test restore procedures … maintain database health. Monitor database performance, capacity, and availability; proactively address bottlenecks and plan for data growth. Manage database change control processes, including schema version control and change-freeze enforcement across systems. Work closely with data and solution architects providing technical expertise and design leadership for the delivery ...

visualisation and back-end modelling Excellent SQL skills for querying, transforming, and structuring data Strong understanding of data modelling principles, including concepts such as star schema, Kimball methodology, and semantic modelling Experience developing and maintaining DAX measures and calculations Confidence engaging with stakeholders and translating business requirements into ...

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

including transactional, analytical and relational models. Experience working with data models across multiple technologies, including RDBMS and APIs. Strong experience producing ERDs, data models, star schemas, data dictionaries, taxonomies and ontologies. Experience managing metadata repositories and using metadata to support data lineage, integration and impact analysis. ...