Future Interest Analytics Engineer

Kaluza Ltd.
Edinburgh, UK
6 days ago
Apply on www.totaljobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

Data Analysis Code Reuse Data Architecture Data Infrastructure Data Integrity Data Transformation Data Structures Data Warehousing Database Development Software Debugging Performance Tuning SQL Databases
+3 more
Sql Optimization Star Schema Databricks

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

Requirements

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

Benefits & conditions

Here at Kaluza we have five core values that guide us as a business: Play to win, Solve the real problem, Build trust every day, Own the outcome, Go further together From us you’ll get

  • Pension Scheme
  • Discretionary Bonus Scheme
  • Private Medical Insurance + Virtual GP
  • Life Assurance
  • Access to Furthr - a Climate Action app
  • Free Mortgage Advice and Eye Tests
  • Perks at Work - access to thousands of retail discounts
  • 5% Flex Fund to spend on the benefits you want most
  • 26 days holiday
  • Flexible bank holidays, giving you an additional 8 days which you can choose to take whenever you like
  • Progressive leave policies with no qualifying service periods, including 26 weeks full pay if you have a new addition to your family
  • Dedicated personal learning and home office budgets
  • And more… Even better? You’ll have access to these benefits from day 1 when you join. We want the best people We’re keen to meet people from all walks of life - our view is that the more inclusive we are, the better our work will be. We want to build teams which represent a variety of experiences, perspectives and skills, and we recognise talent on the basis of merit and potential. We understand some people may not apply for jobs unless they tick every box. But if you’re excited about joining us and think you have some of what we’re looking for, even if you’re not 100% sure, we’d still love to hear from you. Find out more about working at on our and . You can also find our Applicant Data Protection Policy .Kaluzacareers pageLinkedInhere

About the company

Kaluza is the Energy Intelligence Platform, turning energy complexity into seamless coordination. We help energy companies overcome today’s challenges while accelerating the shift to a clean, electrified future.

Our platform orchestrates millions of real-time decisions across homes, devices, markets and grids. By combining predictive algorithms with human-centred design, Kaluza makes clean energy dependable, affordable and adaptive to everyday life.

With teams across Europe, North America, Asia and Australia, and a joint venture with Mitsubishi Corporation in Japan, we power leading companies including OVO, AGL and ENGIE, as well as innovators like Volvo and Volkswagen.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.totaljobs.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou ¡ Coffee With Developers

5:14 min

Executing Databricks jobs with built-in Airflow operators

Alan Mazankiewicz ¡ LIVE

4:15 min

Enabling code reuse and inline assembly

Liu Xiaohui ¡ LIVE

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt ¡ LIVE

8:27 min

Building generic custom operators for Databricks APIs

Alan Mazankiewicz ¡ LIVE

2:39 min

The evolution of code reuse and dependency risks

Liran Tal Liran Tal ¡ LIVE

Videos

See all

Related articles

See all