Analytics Engineer

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.

Key Responsibilities:

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

Kaluza's vision is to power a world where net-zero is within everyone's reach. This role helps energy companies overcome today's challenges while accelerating the shift to a clean, electrified future by orchestrating millions of real-time decisions across homes, devices, markets and grids.

Must-Haves:

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

• Salary: £46,400 - £63,800
• 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

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 by orchestrating millions of real-time decisions across homes, devices, markets and grids.