1 to 25 of 33 Star Schema Jobs in England

models, dashboards and reports. Develop scalable dimensional data models (fact and dimension tables) to support analytical reporting. Design and optimise enterprise semantic models using star schema methodologies. Develop advanced DAX measures, calculations and KPIs to support business reporting requirements. Optimise Power BI datasets and semantic models to maximise … Strong experience designing dimensional data models for enterprise analytics. Excellent knowledge of Microsoft Fabric architecture. Advanced experience with DAX and enterprise semantic modelling using star schema design. Strong experience tuning and optimising Power BI semantic models. Advanced knowledge of Power Query , including transformation optimisation and diagnostics. Strong ...

pipeline development on Azure and SQL Server. Hands-on orchestration experience with SSIS, SQL Agent, and Azure Data Factory. Solid data modelling, ideally star schema design. Experience implementing data quality checks and testing (DBT or similar). Comfortable with Git and GitHub in a CI/CD workflow. … pipelines for structured and unstructured data. Help develop and maintain a modern data architecture, including optimising on-prem data warehouses. Design performant data models (star schema) and apply data transformations. Implement data observability, testing, and validation checks (such as DBT tests) to protect data integrity. Set up dynamic ...

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

such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). Solid understanding of data warehousing and data modelling techniques (Star Schema, Snowflake Schema). Familiarity with security frameworks (GDPR, HIPAA, ISO 27001, NIST, SOX, PII) and AWS security features (IAM, KMS, RBAC ...

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

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

business analysis, data analysis and data cataloguing to identify and document data requirements. Proficient use of enterprise data platforms, semantic models and dimensional modelling (star schemas, fact/dimension tables). Proficient in data architecture principles, ETL processes and data pipeline concepts. Experience with data cataloguing tools ...

reporting and analytics. • Partner with stakeholders to understand requirements, validate assumptions and shape how data should be modelled. • Apply strong data modelling practices, including star schemas and Kimball methodologies. • Support the management of the lakehouse, including incremental loads, snapshotting and data quality. • Contribute to the relationship with Databricks ...

documentation, and managing a project structure Ability to translate business logic and organisational rules into data model design Experience building curated or semantic layers — star schemas or similar Excellent communication skills — able to work closely with non-technical stakeholders to understand and codify their data needs Outstanding attention ...

decision-making. Key Responsibilities End-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/ ...

decision-making. Key Responsibilities End-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/ ...

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

managed service period What We're Looking For Expert SQL and data modelling; you build and maintain modular, analytics-ready data models (dimensional, star schema) that serve BI tools, AI agents, and automated reports. BigQuery preferred; Snowflake, Redshift, or Postgres transferable Cloud and pipeline fluency; comfortable navigating … BigQuery, IAM, GCS, CLI) and managing end-to-end ELT pipelines using tools like Fivetran, Airbyte, or dbt; you handle connector config, sync scheduling, schema management, and failure handling without hand-holding Python and AI tooling; you write scripts to automate provisioning and data quality checks ...

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

best practices across client environments. Provide technical leadership and architectural guidance to engineering teams. Design and optimise data models including 3NF, Data Vault, Star Schema, and OBT approaches. Partner with stakeholders to develop data strategies aligned to business objectives. Collaborate with engineering and data science teams to deliver ...

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