Senior Data Analyst

So Energy; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Hybrid Working

Educational Sponsorships

Annual Salary Reviews

Real Living Wage Employer

Birthday Off

Three So Giving Days

Wellbeing Resources

Job summary

So Energy is seeking an experienced Senior Data Analyst to join the data analytics team in Chiswick, London. You will leverage advanced SQL to extract, clean, and analyse complex datasets, delivering actionable insights to drive strategic decisions.

You will lead data-driven projects, collaborate with cross-functional teams, and design curated Data Warehouse tables for the Data Engineering team, plus develop impactful visuals for stakeholders at all levels.

Qualifications

• Bachelor's degree in a quantitative field; Master's preferred.
• 5+ years of experience as a Data Analyst with advanced SQL.
• Experience delivering analytical insights to the business.
• Data Warehouse design experience.
• Proficiency in Looker and Power BI.

Responsibilities

• Line manage 2 direct reports (mid/junior Analysts) with guidance from Data Team Lead.
• Utilize advanced SQL to extract, clean, and analyse complex datasets.
• Lead data-driven projects from objectives and methodologies to presenting findings and recommendations.
• Collaborate with cross-functional teams to understand business needs and drive data-driven decisions.
• Design and document curated Data Warehouse tables for the Data Engineering team.
• Define metrics for business monitoring and create clear data visualizations for stakeholders.

Skills

Advanced SQL

Stakeholder engagement

Data storytelling

Team collaboration

Education

Bachelor's degree in a quantitative field

Master's degree preferred

Tools

Looker

Power BI

Job description

Our priority is to match the right person to the right role, and we never want salary to be a barrier to applying. Regardless of your current pay, we’ll ask about your salary expectations during the application process, and our Talent Team will have an open, honest conversation during the talent call to understand your skills and explore our salary options. If you have questions around salary, please feel free to ask us!

Location: Chiswick, London - Hybrid

Sponsorship: We are unable to offer sponsorship for this role

The Role

We are seeking an experienced and highly skilled Senior Data Analyst to join our data analytics team. As a Senior Data Analyst at So Energy you will play a pivotal role in leveraging data to drive strategic decisions and solve complex challenges for the business.

We are looking for a candidate with advanced SQL skills who has a track record of successfully delivering analytical insights to the business.

If you are passionate about transforming data into actionable insights and possess excellent soft skills to engage with stakeholders, we invite you to apply and become a key member of our dynamic team.

Why So Energy?

So Energy was created in 2015 because we knew energy suppliers could be better. Since then, we’ve grown rapidly but sustainably, with 300,000 customers and over 450 Energists (what we call our people). But we’re not done! We’re on the road to a net-zero future, and thanks to our partnership with ESB, we’re well on the way. We’re customer-centric, tech-led, and passionate about sustainability.

We’re driven to do our best for our customers, for each other, and for our planet. That’s why we’ve built a workplace culture that’s supportive, empowering, inclusive, and full of opportunities to grow and make an impact.

At So Energy, we take pride in our values-driven culture. We live and breathe by our six core values that guide everything we do:

• Clear

• Honest

• Ambitious

• Inquisitive

• Caring

• Sustainable

What you’ll be getting up to in this role:

• Line manage 2 direct reports (mid/junior Analysts), working collaboratively with the Data Team Lead.

• Utilize advanced SQL skills to extract, clean, and analyse complex datasets, providing meaningful insights.

• Lead data-driven projects, from defining objectives and methodologies to presenting findings and recommendations.

• Collaborate with cross-functional teams to understand business needs, develop analytical solutions, and drive data-driven decision-making.

• Design and document curated Data Warehouse tables to be handed to our Data Engineering team for implementation.

• Define metrics that are suited to business monitoring at various levels.

• Create clear and compelling data visualizations and reports to communicate insights to stakeholders at all levels.

• Support the business in ad-hoc data analysis and data supply covering auditing, marketing campaigns and customer segmentation.

• Input and guide on new standards to improve our delivery of dashboards, reports, and insights.

• Stay updated with industry trends and emerging technologies in data analysis and data science.

• Contribute as part of an agile team with sprint planning sessions and daily stand ups.

• Communicate status, blockers, and progress in a clear and concise manner.

You’re a great match if:

• You have a Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Engineering) or equivalent work experience; Master's degree preferred.

• Proven experience (5+ years) as a Data Analyst or similar role with a strong focus on advanced SQL skills. Experience within the Energy Supply Industry will be favourable.

• Data Warehouse design experience using industry methodologies will be highly favourable.

• Demonstrated experience in delivering complex data projects, with a portfolio showcasing your work.

• Proficiency in data visualization tools (e.g., Looker, Power BI)

• Strong problem-solving skills and the ability to work with large, messy datasets to extract valuable insights.

• Excellent communication skills, both written and verbal, with the ability to convey complex findings to non-technical stakeholders.

• Exceptional project management skills, with the ability to drive projects from inception to completion.

• Strong analytical and critical-thinking abilities with a keen attention to detail.

• A proactive and collaborative attitude, with the ability to work effectively in a team-oriented environment.

Research shows that some underrepresented people are less likely to apply for a role unless they are 100% qualified. We believe your experience, skills, and passion will set you apart. We encourage you to apply and tell us about your journey, even if you don’t tick all the boxes.

What’s in it for you?

Smart Working Charters:

• Hybrid Working – Every team has its own SPARK Working Charter. Ask your Talent Partner for more details.

Growth & Development

• Dedicated Learning & Development Team – Supporting your development through workshops, coaching and learning opportunities.

• Learning Platform – Access thousands of learning resources to help you build new skills and support your career development.

• Educational Sponsorships – Supporting professional development through initiatives such as Code First Girls.

Pay & Reward

• Up to 10% Performance Bonus – Based on both company and personal performance.

• Annual Salary Reviews – Helping ensure we remain competitive in the market.

• Real Living Wage Employer – Proud to be an accredited Real Living Wage employer.

Time Off That Matters

• Your Birthday Off – Because birthdays should be celebrated.

• Three So Giving Days – Paid time to support a cause that's important to you.

• Enhanced Family Leave – Supporting you through every stage of family life.

Health & Wellbeing

• Employee Assistance Programme (EAP) – Confidential support available 24/7, 365 days a year, including access to professional guidance and structured counselling support.

• Wellbeing Resources via Perkbox – Access a range of wellbeing articles, tools and guidance, alongside employee perks and discounts, all in one place.

• Physical Wellbeing – Free eye tests and annual flu vaccinations.

• Menopause Policy – Providing support and guidance for colleagues experiencing menopause.

Belonging & Recognition

• Affinity Groups – Connect with colleagues through our employee-led communities.

• Monthly Social Events – Bringing teams together and creating opportunities to connect.

• Charitable Fundraising – Supporting the communities we're proud to be part of.

Diversity, Equity, Inclusion & Belonging

As a Disability Confident Committed employer, we encourage applications from everyone, and wewill ensure fair and accessible recruitment for all. At So Energy, we’re committed to cultivating an environment that promotes diversity, equity, inclusion, and belonging. We are a global community, and we believe our unique qualities should be celebrated as they are critical to our innovation. It’s essential to us that you bring your authentic self to work every single day, no matter your age, ethnicity, religion, citizenship, gender identity, sexual orientation, disability status, caring responsibilities, neurodiversity, or otherwise. Inclusion isn’t just an initiative at So Energy. We strive to embed it throughout our entire culture.