23 of 23 Permanent Dimensional Modelling Jobs in England

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

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

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

requirements, designing architectures, guiding build teams, and ensuring solutions are secure, well-governed, and ready for production. You will combine strong engineering fundamentals (data modelling, integration, analytics) with practical Generative AI delivery (for example, retrieval‐augmented generation), and you will communicate clearly with both technical and non‐technical stakeholders. … where required), with an engineering mindset around testing, readability, and performance. Strong analytics capability across the Microsoft BI stack (Power BI, semantic modelling, governance and performance), with experience modernising from legacy MSBI where applicable. Demonstrable understanding of enterprise data concepts: dimensional modelling, lakehouse/warehouse patterns, metadata ...

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

etc.) Design reliable ingestion processes from APIs, databases, and file-based sources Apply best-practice pipeline design patterns for resilience and re-runnability Data Modelling & Analytics Enablement Design analytical data models that are performant, maintainable, and business-friendly Apply dimensional modelling techniques for BI and reporting … joins, optimisation) Hands-on Python for data processing and pipeline development Experience with Microsoft Fabric and Power BI (datasets, semantic models) Understanding of data modelling for analytics and reporting Familiarity with CI/CD, testing, version control, and data quality practices Exposure to data mesh/domain-oriented data ...

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

teams to deliver high-quality, trusted data products that support analytics, reporting, and emerging AI initiatives. Key Responsibilities Define and own enterprise-wide data modelling standards, including Data Vault, semantic layers, Star Schema patterns, Snowflake object hierarchies, and governance frameworks. Design scalable integration architectures for legacy platforms, including AS400 … implementing solutions within Snowflake. Demonstrated success delivering enterprise-scale data transformation programmes and modernising legacy data environments. Deep expertise in Data Vault 2.0, Kimball dimensional modelling, and Inmon methodologies, with the ability to select the right approach for varying business requirements. Advanced knowledge of dbt and Git-based ...

learning solutions, including generative AI and responsible AI approaches. Knowledge of modern data architecture patterns including lakehouse, data integration, ETL/ELT, MDM, and dimensional modelling. Familiarity with enterprise application integration and low-code platforms. Experience with software delivery lifecycle practices, DevOps, deployments, migrations, and production support. Strong Agile ...

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

join a rapidly growing practice and take your career to the next level. Responsibilities Conduct user requirements analysis and facilitate business process design and modelling workshops with client subject matter experts Identify gaps, issues and reporting risk areas as part of an implementation team Translate business processes and requirements … managerial, technical and business stakeholders Understand and manage priorities, scope, timelines, objectives and key milestones Required Skills and Experience Background in business, finance, multi-dimensional modelling, data analytics, business intelligence or consulting Strong analytical and problem-solving capabilities Proven experience with Anaplan, including model design, implementation and optimisation ...

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

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