9 of 9 Permanent Dimensional Modelling Jobs in London

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

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

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

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

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