> Markdown version of [/jobs/ext/3248564-future-interest-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/3248564-future-interest-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Future Interest Analytics Engineer - **Company:** Kaluza Ltd. - **Location:** Edinburgh, UK - **Contract:** Permanent contract - **Skills:** Data Analysis, Code Reuse, Data Architecture, Data Infrastructure, Data Integrity, Data Transformation, Data Structures, Data Warehousing, Database Development, Software Debugging, Performance Tuning, SQL Databases, Sql Optimization, Star Schema, Databricks - **Published:** September 26, 2026 - **Apply:** https://www.totaljobs.com/job/analytics-engineer/kaluza-job108047681 ## About the Role * Advanced SQL Mastery: You are an expert in writing, tuning, and debugging complex SQL. You understand window functions, CTEs, and query execution plans inside and out. * Stakeholder Management: Proven ability to communicate technical concepts to non-technical audiences and manage competing priorities from multiple business units. * Engineering Mindset: A focus on writing clean, modular, and reusable code. Nice-to-Haves * Data Modelling Expertise: Practical experience with Star Schema and Kimball methodologies. * Modern Data Stack: Experience using Databricks for processing and dbt for transformation workflows. * Global Delivery: Experience building data products designed for multi-region or multi-client environments. ## Description As an Analytics Engineer, you will play a pivotal role in architecting the foundation of our global reporting capabilities. Your primary focus over the coming year will be the design and implementation of a high-performance, scalable dimensional model built to serve multiple global clients. This role is not just about moving data; it is about the sophisticated translation of complex schema designs into production-ready SQL. You will be the bridge between abstract data architecture and the high-performance scripts that power our business intelligence., * Dimensional Model Architecture: Lead the transition to a robust, multi-tenant dimensional model. You will be responsible for ensuring the architecture is scalable enough to onboard several major global clients without compromising performance. * Expert SQL Development: Translate complex schema designs into high-quality, performant SQL scripts. You will own the logic that transforms raw, disparate data into structured clean tables. * Global Scalability: Design and optimise data structures that handle high volume and variety, ensuring that our data infrastructure evolves ahead of our expanding international client base. * Stakeholder Translation: Act as a key technical partner for business stakeholders. You must be able to navigate complex requirements from various departments and translate them into technical specifications and elegant data models. * Data Integrity & Performance: Rigorously test and optimise SQL queries and data transformations to ensure "single source of truth" reliability and lightning-fast query response times for end-users. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Introduction to sCrypt - a smart contract language for Bitcoin SV](https://www.wearedevelopers.com/videos/24-introduction-to-scrypt-a-smart-contract-language-for-bitcoin-sv) - [Fully Orchestrating Databricks from Airflow](https://www.wearedevelopers.com/videos/336-fully-orchestrating-databricks-from-airflow) - [Kotlin Multiplatform - True power of native code reuse](https://www.wearedevelopers.com/videos/4-kotlin-multiplatform-true-power-of-native-code-reuse) - [Cutting LLM Costs Without Cutting Quality: How to Beat Proprietary LLMs with Fine-Tuned Open Source](https://www.wearedevelopers.com/videos/100151-cutting-llm-costs-without-cutting-quality-how-to-beat-proprietary-llms-with-fine-tuned-open-source) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [7 Most Popular Web Developer Jobs in Europe](https://www.wearedevelopers.com/magazine/163-7-most-popular-web-developer-jobs-in-europe)