20 of 20 Star Schema Jobs in England

Redshift. Implementing a Medallion architecture (bronze, silver, gold). Using DBT to model data, configure tables, and set up tests (including unit testing). Creating a data mart and star schema for financial and revenue reporting. Advising on orchestration best practices using Airflow. Optimising data pipelines for downstream BI tools (Power BI/Looker). This role won … a functioning data mart and reporting models, not dashboarding. YOUR SKILLS & EXPERIENCE The successful candidate will have: Strong SQL and DBT experience. Familiarity with Kimball methodology, dimensional modelling, and star schema design. Proven experience with Redshift or Snowflake. Strong background in cloud-based data environments (AWS preferred). Hands-on experience with Airflow for orchestration. (Nice-to-have More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

and lead analytics projects from onboarding through delivery in a collaborative, fast-growing environment. Analytical Data Engineer Job Overview Cleanse and transform data sets to create one-to-many star schema models from multiple sources. Define fact and dimension tables based on requirements, enabling users to drill down and explore data independently. Proactively search for and review data … outcomes. Develop and deliver advanced analytical dashboards using Sisense, Quicksight, and Power BI, tailored to user needs. Provide technical guidance on data structures from APIs to ensure alignment with star schema models. Support the Lead Solutions Architect on best practices for go-live within client Microsoft environments. Work directly with clients during onboarding, running workshops, gathering requirements, clarifying More ❯

and loading (ETL) processes, leveraging tools such as Talend, Informatica, Matillion, Pentaho, MuleSoft, Boomi, or scripting languages (Python, PySpark, SQL). 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). Strong analytical skills to More ❯

metadata management Performance Tuning : Partitioning, caching, Spark job optimization Cloud Architecture : Infrastructure-as-code, monitoring, automation Finance Domain Knowledge : Experience with financial systems and reporting Data Modelling : Kimball methodology, star schemas Retail Experience : Preferred but not essential About the Team We're a collaborative data function made up of BI Developers and Data Engineers. We work end-to-end More ❯

the wider data culture. Key Responsibilities: Design and deliver robust data pipelines using Databricks, Azure Data Factory, and Azure SQL. Build and enhance enterprise data warehouse models (facts, dimensions, star schemas). Collaborate with BI and Analytics teams to translate requirements into engineering solutions. Drive adoption of modern DevOps practices (CI/CD, cost optimisation, automation). Advocate for … solutions. Essential Skills: 5 years' experience in Data Engineering. Strong expertise in Databricks, Azure Data Factory, Azure SQL, and Azure Synapse/DW. Solid understanding of dimensional modelling (Kimball, Star Schema) and EDW solutions. Experience working with structured and unstructured data. Familiarity with cloud and DevOps practices - ie Azure, CI/CD pipelines, scaling, cost optimisation. Strong problem More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

Experience managing large and complex datasets, with a strong command of SQL for cloud-based environments (Fabric, Snowflake, BigQuery, Redshift, etc.). A solid understanding of data modelling techniques (star schema, data vault, dimensional modelling). Proficiency in Excel-based data workflows for various Agile Retail projects. Hands-on experience with data pipeline orchestration tools (Airflow, dbt, Prefect More ❯

Excel based analysis towards automated or semi-automated solutions. Experience in translating business requirements whilst also enhancing their ask by providing and explaining useful additional analysis. Expert knowledge of star schema modelling including dimensional data modelling, the identification of dimensions, facts, measures and hierarchies. Advanced experience developing analytics using Microsoft Power BI and/or other data visualisation More ❯

implementing enterprise-scale data architecture in complex environments Deep understanding of data modelling techniques-including conceptual, logical, and physical modelling Strong expertise in Kimball methodology and dimensional modelling (e.g. star schema design) Experience with modern cloud data platforms, ideally including Microsoft Azure, Databricks, and associated tools (e.g., Azure Data Factory, Azure SQL, Synapse) Familiarity with modern data engineering More ❯

implementing enterprise-scale data architecture in complex environments Deep understanding of data modelling techniques-including conceptual, logical, and physical modelling Strong expertise in Kimball methodology and dimensional modelling (e.g. star schema design) Experience with modern cloud data platforms, ideally including Microsoft Azure, Databricks, and associated tools (e.g., Azure Data Factory, Azure SQL, Synapse) Familiarity with modern data engineering More ❯

relational databases (preferably postgres); working with Change Data Capture is a bonus. Data modelling knowledge, breaking down backend logic to understand and form a holistic data model (ie 3NF, star schema, Data Vault). Strong experience with Python, TypeScript or Java (a significant amount of work will be in Java - it is not expected for you to know … as code" practices. Good understanding of DevOps practices, Infrastructure as Code & Continuous Integration/Continuous Deployment. Desirable Experience extracting, loading and transforming large data sets (>100GBs). Experience with schema evolution tools such as flyway or liquibase. Experience with AWS (S3, IAM, RDS). Translate internal data user needs into building BI Dashboards to answer their key business questions. More ❯

making. A successful Lead Azure Data Engineer should have: Strong experience with Databricks, Azure Synapse, Delta Lake, and pipeline orchestration. Hands-on with ETL/ELT processes, data modeling (star schema), SQL, Python, and data governance tools (e.g., Purview, Unity Catalog). Experience implementing AI/ML solutions in Databricks or similar platforms. Knowledge of data observability, monitoring More ❯

ensure data accuracy, quality, and security. What you’ll bring: Proven BI or Data experience with strong Power BI, DAX, and Power Query skills. SQL and data modelling expertise (star schema design). Strong Excel skills and knowledge of relational databases. Excellent problem-solving and communication skills, with high attention to detail. Experience with SSRS/SSIS/ More ❯

and configure incremental loads with built-in unit testing. Support data pipeline orchestration with Airflow and work with AWS cloud tools. Help deliver a production-ready Data Mart with star schema design to power business reporting and dashboards (PowerBI experience a plus). Skills & Experience: Strong SQL expertise and hands-on experience with DBT. Familiarity with Kimball dimensional More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

to the business. What you’ll be doing Designing and delivering Power BI dashboards that are accurate, intuitive and widely adopted across the business. Building and maintaining semantic models (star schema, relationships, hierarchies) to create a single source of truth. Ability to read SQL Code Implementing Row-Level Security (RLS) and governance controls to ensure the right people More ❯

when needed Excellent requirements, Epics, User Stories and Acceptance Criteria specification Managing agile product backlogs in scrum Process and requirements modelling Data Modelling of financial data and CUBE/Star Schema Data Analysis Reconciliation Defect triage and classification of bug prioritisation and severity Financial modelling and statutory reporting platforms Knowledge and Experience Experience of finance software implementations and More ❯