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 5 Acquisitions - We've expanded our operations by acquiring four key companies across financing (Hometree Finance - formerly Bewarm), home cover (Your Repair) and installations energy services (Geowarmth, The Little Green Energy Company and IMS). 100k Homes Covered - We cover over one hundred thousand homes across the UK 250 Employees - We have over 250 passionate employees transforming the industry across the Group, one home at a time The Role Join Hometree as a Data Analyst and help drive advancements in renewable energy. Use your skills in BigQuery and Looker to extract, analyze, and visualize complex datasets, providing key insights that support our mission. Work with cross-functional teams to deliver data-driven recommendations and contribute to a more sustainable future. If you're experienced in data analysis and committed to impactful work, we want to hear from you. Responsibilities: Data Analysis & Reporting : Extract, clean, and analyze large datasets from multiple sources using BigQuery, and develop comprehensive reports and dashboards in Looker to support various business functions. Data Visualisation : Design and create intuitive and impactful data visualizations using Looker to effectively communicate findings to stakeholders. Data Management : Maintain data integrity and ensure high levels of data quality by developing and implementing data governance practices, and monitor and troubleshoot data anomalies. Collaboration & Communication : Work closely with cross-functional teams, including Product, Marketing, Finance, and Engineering, to provide analytical support and insights, and present data-driven recommendations to both technical and non-technical stakeholders. 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. Extra Credit: Additional Tools : Knowledge of Tableau or Power BI for data visualization. Looker Studio : Familiarity with Looker Studio for enhanced data reporting. 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