At a Glance
- Tasks: Design and implement scalable data models for global reporting capabilities.
- Company: Join Kaluza, a leader in energy intelligence and innovation.
- Benefits: Enjoy competitive salary, flexible work, and great perks from day one.
- Why this job: Make a real impact on clean energy solutions while developing your skills.
- Qualifications: Expertise in SQL and strong communication skills are essential.
- Other info: Diverse team culture with excellent career growth opportunities.
The predicted salary is between 38400 - 52800 £ per year.
Location: London, Bristol or Edinburgh (Including Hybrid)
Salary: £38,400 - £52,800
Team: Analytics Engineering team
Reporting To: Analytics Engineering Manager
This role is 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.
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.
Qualifications
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.
Benefits
- 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.
Analytics Engineer - 12 Month Fixed Term Contract in Bristol employer: Kaluza
Contact Detail:
Kaluza Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Analytics Engineer - 12 Month Fixed Term Contract in Bristol
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with current employees at Kaluza. A friendly chat can sometimes lead to opportunities that aren’t even advertised.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or any projects that highlight your SQL mastery and data modelling expertise, make sure to share them during interviews. It’s a great way to demonstrate your capabilities beyond just words.
✨Tip Number 3
Prepare for those tricky questions! Brush up on how to explain complex technical concepts in simple terms. You’ll need to show you can bridge the gap between tech and business stakeholders, so practice makes perfect!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Kaluza team.
We think you need these skills to ace Analytics Engineer - 12 Month Fixed Term Contract in Bristol
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Analytics Engineer role. Highlight your SQL expertise and any relevant experience with data modelling or stakeholder management. We want to see how your skills align with what we're looking for!
Show Off Your SQL Skills: Since advanced SQL mastery is a must-have, don’t hold back! Include specific examples of complex SQL queries you've written or optimised. This will help us see your technical prowess right from the start.
Be Clear and Concise: When writing your application, keep it straightforward. Use clear language to explain your experiences and achievements. We appreciate a well-structured application that gets straight to the point without unnecessary fluff.
Apply Through Our Website: We encourage you to submit your application through our careers site. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, you’ll find all the info you need about the position there!
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 that showcase your ability to bridge the gap between data and business needs.
✨Showcase Your Data Modelling Skills
Familiarise yourself with dimensional model architecture, especially Star Schema and Kimball methodologies. Be prepared to discuss how you've designed scalable data structures in previous roles and how they contributed to the overall success of a project.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving abilities. Think about scenarios where you've had to optimise SQL queries or ensure data integrity under pressure. Practising these scenarios will help you articulate your thought process clearly during the interview.