25 of 25 Star Schema Jobs in England

develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability Partner with Data … solutions in production environments Advanced Power BI expertise, including semantic modelling, DAX, Power Query, and performance optimisation Excellent data modelling skills with experience of star schema and dimensional modelling techniques Strong SQL skills, including complex query writing, data validation, and performance tuning Experience working with enterprise data warehouses ...

high-quality, trusted data products across the business. Key Responsibilities Define and own enterprise-wide data architecture standards, including Data Vault, semantic layer frameworks, star schema modelling patterns, and Snowflake design conventions. Design scalable integration patterns for legacy and modern data sources, ensuring strong governance, reconciliation, auditability … field. At least 4 years of hands-on Snowflake architecture and design experience. Proven expertise in Data Vault 2.0 and dimensional modelling methodologies, including Star Schema design. Strong knowledge of dbt and source control practices using GitHub. Experience integrating enterprise data platforms with AWS services and broader cloud ...

high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. Ensure robust data governance, security ...

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design, database layers, and data mart development Knowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment ...

scale. Key Responsibilities: Data platform ownership: Lead the design, operation, and evolution of our SQL Server data warehouse. Establish best practice standards for schema design and performance tuning in SQL Server/SSMS. ETL/ELT & integration: Define and manage pipelines (e.g., SSIS & Power Query) that consolidate sources including … experience delivering Power BI models and dashboards (DAX, Power Query, RLS, performance). ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly within reporting ...

using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisationAdvanced data modelling including dimensional modelling, star schema design, database layers, and data mart developmentKnowledge of BI solution delivery methodologies including requirements and discovery, Agile delivery, testing, deployment, and post-production ...

APIs and native connectors Own data quality, monitoring, and governance across the platform Design and implement dimensional data models (fact/dimension tables, star schema) Build and maintain Power BI semantic models with DAX, KPIs, and row-level security Deliver dashboards and reporting across commercial, marketing, and operational ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

Python skills Solid understanding of Lakehouse architecture and data management principles Hands-on experience with Azure (Data Factory, Databricks, Synapse, Storage, DevOps) Experience designing Star Schema data models for Power BI 5+ years' experience building data platforms in a commercial setting Nice to have: Real-time pipeline experience ...

documentation for all data warehouse and data engineering related processes. Able to document using approaches such as Entity Relationship diagrams, Data Flow Diagrams or Star Schema Diagrams. Develop detailed technical designs, SOPs, and post-incident reports to support continuous improvement. Keep documentation up to date to minimise recurrence ...

near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best work starts with ...

enterprise-wide decision-making.Key ResponsibilitiesEnd-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design.Platform & Integration Strategy: Architect Power BI integration with Azure/AWS cloud ...

automation specialist or similar role. Strong proficiency in Power BI Desktop, Power BI Service, and Power Query. Solid understanding of data modelling concepts, including star schema, relationships, and normalisation. Experience with DAX (Data Analysis Expressions) for creating complex measures and calculations Familiarity with Power BI best practices, security ...

improve a lakehouse architecture, supporting ingestion, transformation, and consumption layers. Create robust, well-structured data models using best practice approaches such as Kimball and star schema. Work closely with business stakeholders to translate requirements into clear, usable data assets. Support and enhance the Power BI reporting layer, including semantic ...

Azure Data Platform technologies and modern Lakehouse architectures Databricks, Unity Catalog and Delta Lake PySpark, Databricks, SQL Medallion Architecture implementation Data modelling approaches including Star Schema and Data Vault Data governance, security and access management Why This Opportunity Greenfield data transformation programme Full ownership of enterprise data architecture ...

experience with business intelligence tools, data modeling, data staging, and data extraction processes, including data warehouse and cloud infrastructure. Experience with multi-dimensional design, star schemas, facts and dimensions. Experience and demonstrated competencies in ETL development techniques. Experience in data warehouse performance optimization. Experience on projects across a variety ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

Strong interpersonal skills; ability to translate complex data architecture into clear language for Business Analysts and non-technical stakeholders. Duties Data Modelling Standard: defining Star Schema patterns, Snowflake object hierarchies, and modelling conventions that serve as the Group-wide standard for all data products. Cross-Cloud Orchestration : Design ...

Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks Must have skills Informatica PowerCentre (preferably ...

coding assistant experience in a professional setting Financial services background preferred; BCBS 239 awareness advantageous Desirable Skills Data Vault 2.1 alongside Kimball/Star-schema modelling Data mesh, data product ownership and federated governance Knowledge graph platforms (Neo4j, Neptune) or knowledge of OWL, RDF and exposure ...

level SQL and deep mastery of dbt (data build tool) or similar orchestrators, coupled with a thorough understanding of Kimball dimensional modelling principles and star schema layouts. AI Native Mindset: A progressive understanding of how automated AI agents consume data structures, and practical familiarity with utilising generative ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Design and architect a scalable position-keeping service for blockchain networks, supporting internal and external tokenized, detokenized, and hybrid ...

requirements in banking. Proficient in BigQuery, Vertex AI, Dataflow, and Pub/Sub. Strong understanding of relational, NoSQL, and analytical data modeling (e.g., Star Schema, Data Vault, etc.). Ability to independently drive the discovery phase, moving from a vague business problem to a structured ...

modular transformations and facilitate analytics. You will ensure trust in metrics, performance at scale, and effective stakeholder enablement. Key responsibilities Modelling and ELT: design star schemas and domain marts; implement tests (schema, data, freshness), documentation, and incremental strategies. Metrics governance: Define and version business metrics (owners, contracts, change ...