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 working, and great perks from day one.
- Other info: Be part of a diverse team with excellent career growth opportunities.
- Why this job: Make a real impact in the clean energy sector with cutting-edge technology.
- Qualifications: Expertise in SQL and strong communication 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. We are committed to building a diverse, global team and our sponsorship policy is evaluated on a role-by-role basis. We encourage you to keep an eye on our careers site to stay informed about future opportunities where we are able to offer visa sponsorship.
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.
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…
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 Kaluza on our careers page and LinkedIn. You can also find our Applicant Data Protection Policy here.
Future Interest: Analytics Engineer in London 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 London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Kaluza!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Future Interest: Analytics Engineer at Kaluza.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Kaluza.
✨Apply Directly through Our Website
When you find a suitable opening like Future Interest: Analytics Engineer at Kaluza, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Future Interest: Analytics Engineer in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Kaluza, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Kaluza. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Kaluza
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Kaluza!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
