Ofertas › Kaluza
Kaluza · London, United Kingdom · £54,000 - 70,000 per year
Salary: £54,000 - 70,000 per year Requirements: Advanced SQL mastery, including writing, tuning, and debugging complex SQL, with strong understanding of window functions, CTEs, and query execution plans. Proven ability to communicate technical concepts to non-technical audiences and manage competing priorities from multiple business units. A strong engineering mindset with a focus on writing clean, modular, and reusable code. Practical experience with Star Schema and Kimball methodologies is desirable. Experience using Databricks for processing and dbt for transformation workflows is desirable. Experience building data products for multi-region or multi-client environments is desirable. Existing right to work in the UK is required. Responsibilities: Architect the foundation of our global reporting capabilities. Design and implement a high-performance, scalable dimensional model for multiple global clients. Translate complex schema designs into production-ready SQL. Lead the transition to a robust, multi-tenant dimensional model. Own the logic that transforms raw, disparate data into structured clean tables. Design and optimise data structures that handle high volume and variety. Act as a key technical partner for business stakeholders and translate requirements into technical specifications and elegant data models. Test and optimise SQL queries and data transformations to ensure reliable, high-performance reporting. Help ensure our data infrastructure scales with our expanding international client base. Technologies: Architect Databricks SQL dbt Business Intelligence More: We are Kaluza, the Energy Intelligence Platform, turning energy complexity into seamless coordination. We help energy companies overcome todays challenges while accelerating the shift to a clean, electrified future. Our platform orchestrates millions of real-time decisions across homes, devices, markets and grids, combining predictive algorithms with human-centred design to make clean energy dependable, affordable and adaptive to everyday life. We have teams across Europe, North America, Asia and Australia, and a joint venture with Mitsubishi Corporation in Japan, powering leading companies including OVO, AGL and ENGIE, as well as innovators like Volvo and Volkswagen. This future interest role is for our Analytics Engineering team, based in London, Bristol or Edinburgh with a hybrid working model, and offers a salary of 46,400 - 63,800. We offer benefits from day one, including a pensio