8 of 8 Dimensional Modelling Jobs in the South East

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

hybrid role.Key Responsibilities: Design, build, and maintain data solutions using Microsoft Fabric. Develop and optimise data pipelines, Lakehouses, and Data Warehouses. Create and maintain dimensional data models and semantic models. Support Power BI reporting and analytics requirements. Ensure data quality, performance, security, and governance. Collaborate with business stakeholders … deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge of ETL/ELT processes ...

Scala for data processing and automation. Experience with BI and visualisation tools such as Power BI, Tableau, or Looker. Understanding of data warehousing concepts, dimensional modelling, and modern data architecture. Experience integrating APIs and third-party SaaS platforms. Must have excellent stakeholder management and communication skills, with ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

reporting layer within the data warehouse using SQL Create and maintain reporting tables and views Work closely with data engineers to ensure outputs follow dimensional modelling best practices Investigate and resolve data quality issues, ensuring outputs reconcile with source systems Improve performance across both SQL queries and Power … Service, including publishing, workspace management, and scheduled refreshes Advanced T-SQL skills, including views, stored procedures, CTEs, and window functions Solid understanding of data modelling concepts such as fact and dimension tables, and star schemas Desirable Experience Experience with Azure Synapse or similar cloud data platforms Knowledge of Power ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...

will have the following skills and experience: Strong commercial SQL capability Experience with Power BI, Looker or similar modern BI tools Confidence working with dimensional models and semantic layers Comfortable engaging directly with stakeholders and translating business questions into analytics solutions Experience rebuilding or rationalising BI estates rather than ...

interacts with these technologies. Designing scalable enterprise architectures, not ad-hoc integrations. Modern Data Architecture Lakehouse, data mesh, ELT/ETL patterns, MDM and dimensional modelling. Steering the "doers" in the team-architecting the solution, not building it yourself. Team & Practice Growth Mentoring and guiding a growing data team. … DevOps pipelines and Agile delivery. Experience with ML, generative AI and cognitive services. Expertise in lakehouse, data mesh, ELT/ETL, MDM and modelling techniques. Ability to guide delivery teams without being the hands-on builder. Willingness to travel for client sessions (primarily London). Ready to Take ...