8 months ago
Edinburgh, United Kingdom or London, United KingdomSenior
Responsibilities
- Lead the transition to a scalable, multi-tenant dimensional model for multiple global clients.
- Translate complex schema designs into performant SQL scripts and transform disparate raw data into clean, structured tables.
- Design and optimize data structures for high-volume, multi-region, and multi-client environments.
- Translate complex business requirements into technical specifications and data models.
- Test and optimize SQL queries and data transformations to maintain data integrity and fast query performance.
- Partner with stakeholders across multiple business units and manage competing priorities.
Requirements
- Expertise in writing, tuning, and debugging complex SQL, including window functions, CTEs, and query execution plans.
- Proven ability to explain technical concepts to non-technical audiences and manage stakeholder priorities.
- Engineering mindset focused on clean, modular, and reusable code.
- Practical experience with star schema and Kimball data-modeling methodologies is preferred.
- Experience with Databricks and dbt is preferred.
- Experience building data products for multi-region or multi-client environments is preferred.
- Existing right to work in the UK is required.
Benefits
- Pension scheme, discretionary bonus scheme, private medical insurance, virtual GP, and life assurance.
- Access to Furthr climate-action app, free mortgage advice, eye tests, Perks at Work retail discounts, and a 5% flexible benefits fund.
- 26 days of holiday plus flexible bank holidays with an additional 8 selectable days.
- Progressive leave policies, including 26 weeks of full pay for a new addition to the family.
- Dedicated personal learning and home office budgets.
- Benefits are available from day one.
- Hybrid working model based in London, Bristol, or Edinburgh.
- This is a future-interest priority talent pool position; there is no immediate opening and recruiters will review the pool when headcount is approved.
Tech Stack
Categories
Data Engineering
About Kaluza
Kaluza builds an energy software platform for utilities and suppliers to run billing, smart EV charging, and real-time demand response across homes, devices, markets and grids. It sells its platform and services to energy companies and OEM partners; customers include OVO, AGL and ENGIE, with collaborations with Volvo and Volkswagen. Headquartered in London and B Corp‑certified, Kaluza operates across Europe, North America, Asia and Australia, including a joint venture with Mitsubishi in Japan.