At a Glance
- Tasks: Design and implement scalable data models for global reporting.
- Company: Join Kaluza, a leader in energy intelligence and innovation.
- Benefits: Enjoy competitive salary, flexible holidays, and personal development budgets.
- Other info: Diverse and inclusive workplace with excellent career growth opportunities.
- Why this job: Be part of a team transforming energy with cutting-edge analytics.
- Qualifications: Expertise in SQL and strong stakeholder management skills required.
The predicted salary is between 46400 - 63800 £ per year.
Location: London, Bristol or Edinburgh (Hybrid working model)
Salary: £46,400 - £63,800
Team: Analytics Engineering team
Reporting To: Analytics Engineering Manager
IMPORTANT Note on this role: While we don’t have an immediate opening for this specific position today, we are growing fast and hire for this skillset frequently! By applying here, you are joining our Priority Talent Pool and when a headcount is approved, our recruiters check this pool before posting the job publicly. This role will be based in London, Bristol or Edinburgh and requires an existing right to work in the UK. At this time, we are not able to offer visa sponsorship for this role.
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.
What will I be doing?
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.
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.
- 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.
Candidate Profile
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.
Kaluza Values
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…
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.
Future Interest: Analytics Engineer in Bristol employer: Kaluza
Kaluza is an exceptional employer that fosters a dynamic work culture in the heart of London, where innovation meets collaboration. Employees benefit from a comprehensive pension scheme and flexible holiday options, promoting a healthy work-life balance while engaging in meaningful projects that leverage cutting-edge AI technology. With ample opportunities for professional growth and development, Kaluza empowers its team to thrive in a supportive environment dedicated to enhancing internal processes through automation.
StudySmarter Expert Advice🤫
We think this is how you could land Future Interest: Analytics Engineer in Bristol
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on upcoming roles or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects or any relevant analytics work. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Stay updated with industry trends! Follow blogs, podcasts, or webinars related to analytics engineering. This not only boosts your knowledge but also gives you great talking points during interviews.
✨Tip Number 4
Apply through our website! By joining our Priority Talent Pool, you’ll be first in line when we open up new positions. Plus, it shows us you’re genuinely interested in being part of our team!
We think you need these skills to ace Future Interest: Analytics Engineer in Bristol
Some tips for your application 🫡
Show Your SQL Skills:Make sure to highlight your advanced SQL mastery in your application. We want to see how you can translate complex schema designs into high-quality, performant SQL scripts. Don’t hold back on showcasing your expertise!
Tailor Your Application:Take a moment to tailor your application to the role. Mention specific experiences that relate to dimensional model architecture and stakeholder management. This shows us you understand what we’re looking for and how you fit in.
Be Clear and Concise:When writing your application, keep it clear and concise. We appreciate straightforward communication, especially when it comes to technical concepts. Make it easy for us to see your skills and experience without wading through fluff.
Apply Through Our Website:Don’t forget to apply through our website! This ensures your application goes directly into our Priority Talent Pool, making it easier for us to find you when the right opportunity arises. We can’t wait to hear from you!
How to prepare for a job interview at Kaluza
✨Know Your SQL Inside Out
As an Analytics Engineer, your SQL skills are crucial. Brush up on advanced SQL concepts like window functions and CTEs. Be ready to discuss how you've used these in past projects, as well as any challenges you faced and how you overcame them.
✨Understand the Business Needs
Kaluza values stakeholder management, so make sure you can articulate how you've translated complex technical requirements into actionable insights for non-technical audiences. Prepare examples of how you've collaborated with different departments to meet their data needs.
✨Showcase Your Data Modelling Skills
Familiarise yourself with dimensional modelling techniques, especially Star Schema and Kimball methodologies. Be prepared to discuss how you've implemented these in previous roles and how they can benefit Kaluza's global reporting capabilities.
✨Demonstrate a Problem-Solving Mindset
Kaluza is all about solving real problems. Think of specific instances where you've tackled data challenges or optimised processes. Highlight your engineering mindset by discussing how you write clean, modular code and ensure data integrity.
