7 of 7 Permanent Star Schema Jobs in London

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 ❯

in ETL/ELT processes and best practices Experience with data visualization tools (Quick sight) Required Skills Strong analytical and problem-solving abilities Excellent understanding of dimensional modelling and star schema design (Facts, dimensions, SCD type 2) Experience with agile development methodologies Strong communication skills and ability to work with cross-functional teams Background in data governance and 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 ❯

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 ❯

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 ❯