Data Analyst

Salary: £45,000 - £60,000 pa depending on experience.
Role type: Permanent, Full time.
Location: Hybrid, with the expectations to come into the office twice a week.
Reporting to: Head of Business Intelligence

About Hometree

Join Hometree Group and be at the forefront of transforming the residential energy landscape. Founded in 2015, Hometree began its journey in the home cover market. Today, We are spearheading the shift towards a future where home energy systems are decentralised, digitised, and reliant on renewable sources such as heat pumps, solar panels, batteries, EV chargers, and smart controls. This innovative approach is not just about sustainability; it's about empowering homeowners to manage their energy more efficiently and cost-effectively, thereby setting new standards in energy consumption.

We operate across three dynamic divisions:

Financial Services: Here, you'll contribute to offering flexible financing options, that make it feasible for homeowners to embrace renewable energy technologies and make essential upgrades.

Energy Services: Be part of our extensive network of local installation businesses that equip homeowners with the cutting-edge, sustainable energy solutions necessary for reaching net-zero emissions.

Home Services: Help maintain the comfort and functionality of homes with comprehensive coverage plans that protect the essential hardware in the home.

At Hometree Group, we are committed to guiding UK homeowners on their journey towards more sustainable energy solutions, and we need passionate individuals to support them at every step. Join us during this exciting time, and play a pivotal role in a business that supports sustainable homeownership in alignment with their readiness and needs.

Key Achievements

🏆 £85m+ Capital Raised - We’ve raised over £85m to-date from leading global investors including Legal & General Capital and specialist energy VCs

🏆 6 Acquisitions - We've expanded our operations by acquiring four key companies across financing (Hometree Finance - formerly Bewarm), home cover (Your Repair) and energy services (Geowarmth, The Little Green Energy Company, IMS, and GreenGen).

🏆 100k Homes Covered - We cover over one hundred thousand homes across the UK

🏆 280+ Employees - We have over 280 passionate employees transforming the industry across the Group, one home at a time

The Role

We're seeking a skilled data analyst with 3–5 years of experience to own and evolve key performance metrics, build impactful dashboards in Looker, and drive insights through advanced SQL and BigQuery. You'll collaborate across teams to automate reporting, ensure data quality, and perform deep-dive analyses that support strategic decisions and fundraising efforts. The ideal candidate has strong technical ability and thrives at turning complex data into clear, actionable insights.

Responsibilities:

• Own Key Metrics: Own and evolve key performance metrics to track and drive company success.
• Dashboard Development: Build and maintain dashboards in Looker to support cross-functional teams.
• SQL & Data Extraction: Write and optimise SQL queries in BigQuery to extract actionable insights from the data warehouse.
• Reporting Automation: Collaborate with stakeholders to automate and streamline reporting processes.
• Data Quality Partnership: Partner with Product and Engineering to ensure data quality, consistency, and availability across the stack.
• Ad Hoc Analysis: Conduct deep-dive analyses to answer business questions, inform strategy, and support fundraising efforts.

What we’re looking for:

• Experience: 3-5 years as a Data Analyst with expertise in Looker (LookML, dashboards), strong SQL skills, and experience with Google BigQuery or similar data warehouses.
• Technical Skills: Advanced SQL, Looker for visualisation, familiarity with ETL processes, and understanding of data warehousing concepts.
• Soft Skills: Strong analytical and problem-solving abilities, excellent communication skills for technical and non-technical audiences, attention to detail, and the ability to work independently and collaboratively.
• BI Tool Expertise: Experience building dashboards and reports using BI tools; Looker experience is a strong plus.
• Spreadsheet Skills: Proficient in tools like Google Sheets, with the ability to build models and automations.
• Insight Translation: Ability to translate complex data into clear, actionable insights and recommendations.

Extra Credit:

• Bonus Experience: Background in financial services, green energy, or climate tech is a plus.
• A/B Testing: Experience with A/B testing, experimentation, and statistical analysis.
• Cloud Platforms: Familiarity with Google Cloud Platform (GCP) or AWS.

Our Recruitment Process:

• Initial Call: Start with an introductory call with our Junior Talent Acquisition Specialist to discuss the role and your potential fit. (30 mins)
• Skills-Based Interview: Engage in a detailed discussion about your past experiences with our Head of Business Intelligence (1 hr)
• Values Interview: A Values Based Interview with the Head of Commercial Operations and our Data Engineer (40 mins)
• Final/Task Interview: Final interview with Head of Business Intelligence and our Chief Technology Officer.

Perks of the job

We have an ever expanding list of benefits that currently includes:

• 25 days holiday plus bank holidays and your birthday
• Hybrid working - Spend 2 days per week with your team in our collaborative London office (it’s dog friendly too!)
• Free boiler & home emergency cover with Hometree plus 40% discount for friends & family
• Discounted gym membership across over 100 UK gyms (independent and chains) and free fitness, wellness and nutrition apps.
• £300 Home office allowance
• Support for your mental health and wellbeing via Oliva
• Menopause support from Stella, including friends & family access
• Cycle to work scheme
• Regular team socials including Summer and Winter parties.

FCA Code of Conduct

At Hometree, we prioritise ethical conduct and regulatory compliance. As a regulated financial services organisation, we operate under the strict guidelines and regulations set forth by the Financial Conduct Authority (FCA). We are committed to maintaining the highest standards of integrity and professionalism in all aspects of our business.

As a prospective member of our team, you will be expected to fully embrace and adhere to the FCA Code of Conduct obligations. These obligations are designed to ensure the fair treatment of customers, the preservation of market integrity, and the promotion of healthy competition within the financial services industry.

Equal Opportunity Employer

At Hometree, we are committed to creating an inclusive and representative environment. We know that different experiences, perspectives and backgrounds make for a better workplace and a better planet. Together, we celebrate differences and promote a culture where you can bring your full self to work.

We promise to give you the same opportunities as everyone else and we won't discriminate against you at any point in the hiring process or the working day. This includes how we source talent, our interview process, our conditions of employment, feedback and everything in between