17 of 17 Permanent Dimensional Modelling Jobs in the UK excluding London

from SSRS into Snowflake Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible) Redesign reporting structures to align with modern data modelling principles Define and Implement Best Practice Establish scalable standards for: Data modelling (e.g. dimensional modelling, layered architecture) Transformation workflows (ELT patterns … experience working with Snowflake (or similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles ...

Azure tools such as Data Factory and/or Fabric Data Pipelines Experience with Python or PySpark for data transformation Understanding of data modelling (dimensional modelling, medallion architecture) Strong communication skills and ability to work with non-technical stakeholders Desirable: Experience migrating from legacy systems (e.g. ...

progress Key Experience Strong SQL and Python, including query optimisation and window functions Hands-on experience with Databricks and Spark Strong understanding of data modelling (3NF, dimensional modelling, star/snowflake schemas, data vault concepts) Experience designing and operating ELT/ETL pipelines Familiarity with data quality ...

discipline Strong Python skills with production-level engineering experience Experience with tools/frameworks such as pandas, Polars, DBT Strong understanding of data warehousing, dimensional modelling and medallion architecture Hands-on experience with cloud platforms: AWS, Azure or GCP Experience with orchestration tools such as Airflow, Prefect ...

assets to deliver high-performing, low-latency analytics at scale. Provide technical guidance through code reviews and mentorship, raising standards across data modelling and visualisation. Your Skills and Experience Strong commercial experience in BI engineering, analytics engineering, or data engineering within a modern data stack. Advanced SQL capability, including … complex transformations, window functions, and performance optimisation. Proven experience working with cloud data warehouses such as Databricks, Snowflake, or BigQuery. Deep understanding of dimensional modelling techniques and tools such as dbt. Hands-on expertise with enterprise BI platforms, such as Power BI, Looker or Omni. Ability to communicate ...

Data Analyst plays a critical role in delivering high-quality analytical insight that drives decisions across AJ Bell. The role blends advanced analytics, data modelling, and stakeholder engagement to deliver solutions that are accurate, scalable, and aligned to our strategic data ambitions. The jobholder will support cloud transformation, adoption … Delivery & Technical Excellence Deliver high-quality analytical outputs for senior data leadership. Proactively deep dive and explore challenges to create recommendations Conduct data design, modelling and exploration to support trusted reporting. Perform data discovery to understand new and existing data sources. Produce compelling visualisations and dashboards using Power BI. ...

computer science, health information or a related discipline. Evidence of advanced specialist training and ongoing CPD in information management/BI (e.g., advanced SQL, dimensional modelling, data quality methods, Power BI/DAX or equivalent). Desirable Postgraduate qualification or equivalent evidence of advanced practice in analytics/ ...

requirements Deliver insights through reports and visualisations Translate business needs into technical solutions Maintain and enhance data platforms and analytics systems Build and manage dimensional data models Conduct testing, troubleshooting and performance tuning Evaluate and improve existing BI systems Collaborate with technical teams to integrate systems Create and maintain … also required. What you'll need to succeed Essential Skills & Experience Proven experience in a data-focused role Strong background in data warehousing and dimensional modelling Understanding of database management systems, OLAP and ETL frameworks Experience with cloud data platforms (ideally Microsoft Fabric) Familiarity with Power ...

roadmap, ensuring alignment with business objectives and the BI product strategy Establish architectural patterns and frameworks (such as Medallion architecture, data vault or dimensional modelling) for consistent implementation across data solutions Define and document standard business entities, metrics and KPIs to ensure consistency across reporting Work with Group … requirements include: Extensive experience in data architecture, with proven track record of designing and implementing enterprise-scale data solutions Deep expertise in data modelling techniques with strong SQL proficiency Good knowledge of cloud data platforms (AWS preferred: Redshift, Athena, S3, Glue, knowledge of Azure or GCP beneficial) and modern ...

looking for Essential skills and experience Strong, hands-on experience with Power BI development Advanced capability in DAX, Power Query and data modelling Proven experience delivering BI solutions within a structured IT environment Strong SQL skills Solid understanding of data warehousing and dimensional modelling Additional strengths Excellent ...

partnering closely with stakeholders across the organisation. The Role Support a major data platform migration, helping to build strong architectural foundations. Design and implement dimensional models and a robust semantic layer to enable trusted, self service analytics. Introduce and embed dbt as part of the transformation and modelling … where needed. Your Skills and Experience Strong commercial experience as a BI Data Architect or BI Engineer in modern analytics environments. Proven capability in dimensional modelling and designing semantic layers for BI tools. Hands on experience with Databricks and lakehouse style architectures. Working knowledge of Unity Catalog ...

processes that support scalable analytics and reporting Your Skills and Experience Strong commercial experience as a Data Engineer with solid foundations in SQL and dimensional modelling Experience working with Snowflake or similar cloud data warehouses such as BigQuery Good Python capability, including orchestration tools such as Airflow Proven ...

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

confident, data driven decisions. Key Responsibilities Design, build, and maintain analytics models that convert raw data into trusted, business-ready datasets. Own the full modelling lifecycle (staging → core → marts). Define and maintain consistent metrics, dimensions, and business logic. Implement testing, data quality checks, and SLAs to ensure reliability. … accurate, consistent, and actionable. A degree in Computer Science, Engineering, Maths, Economics, Data Science is desirable. Advanced SQL skills and experience with analytical/dimensional modelling. Practical experience with modern ELT tools (Dataform/dbt) and Git workflows. Knowledge of cloud data warehouses, ideally BigQuery. Familiarity with orchestration tools ...

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

Knowledge of Docker and containerisation Understanding of encryption techniques (Server Side and client-side) Familiarity with Amazon Textract and Comprehend Strong understanding of data modelling concepts, including dimensional models and slowly changing dimensions Additional Skills: Ability to translate customer requirements into functional technical solutions Familiarity with engineering best ...