BI Data Analyst

So Energy

BI Data Analyst

Salary Not Specified

So Energy, City of Westminster

  • Full time
  • Permanent
  • Remote working

Posted 3 weeks ago, 29 Aug | Get your application in now before you miss out!

Closing date: Closing date not specified

job Ref: 72eadeef00504ae7878ebdaf35e9a5d1

Full Job Description

As So Energy's Business Intelligence Data Analyst, you will be responsible for supporting the business in our data-driven focus on growth and efficiency. Within this role, you will be identifying reporting and data opportunities, analysing trends, and presenting back insights with potential solutions to solve some of the key business challenges. Our solutions are primarily built on the Google Cloud stack, of which Looker is our main BI reporting tool. This will require you to be adept to working on Looker with other BI tools being an added advantage.,

  • Gather and document requirements in a way that allows us to design well suited dashboards and reports.

  • Translate requirements to technical solutions

  • Analyse data to identify trends and patterns - Interrogate and curate the quality, consistency and completeness of data to ensure that the quality of insights are complete and relevant.

  • Script data transformation and business rules in SQL.

  • Research new data sources which will add value into the reporting that you will be delivering.

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

  • Design reporting tables which facilitate the delivery of dashboards and insights - Build dashboards and reports in Google Looker.

  • Dashboard design should follow intuitive data flow and presentation for easier end-user consumption and decision making.

  • Input and guide on new standards to improve the performance of our Looker environment using LookML and improve the landscape of reporting and insights to the business.

  • Perform data reconciliation tasks to ensure that new reporting outputs are aligned or of better accuracy than existing reports.

  • Write quality technical documentation of SQL coding as well as dashboards delivered.

  • 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.

    We are looking for a candidate with advanced SQL and Python 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.,
  • You will need to be a detailed orientated individual who has a passion for analysing data.

  • You will work closely with our Data Engineering team to build reporting friendly structures.

  • A key attention to detail will be required in the reviewing and validating of data as part of your data delivery process.

  • You should have experience in end user engagement on requirements elicitation and the ability to identify stakeholder problems that can be solved through data.

  • Proven hands-on experience with Google Looker including building and maintaining a high performant semantic layer in LookML and creating insightful and actionable dashboards for end users.

  • You should be comfortable with communicating insights to senior management and across the organisation.

  • Provide technical support to other teams within the organisation as required - You should have a strong SQL background with a deep understanding of how to use SQL and interrogate data in the context of business objectives.

  • Be a team player, contributing towards the upliftment of our overall BI capability and supporting junior team members produce higher quality outputs.


  • Research shows that some people are less likely to apply for a role unless they are 100% qualified. Your experience, skills and passion will set you apart so tell us about your achievements, irrespective of whether they are personal or work-related, tell us about your journey, and about what you learnt.

    We look for people who share our values and can add to our culture. Values are shared beliefs that guide our decision-making, culture is how we function as a group and how we live our values as individuals.

    Clear - The energy industry can be pretty complex so we strive to provide clear communication to our customers and colleagues

    Honest - Transparency is key, Whether that's providing clear bills to our customers or trusting our staff to do the right thing.

    Ambitious - All of us are ambitious about the future of So Energy and what we can contribute to it.

    Inquisitive - We are also questioning the Status Quo to see if there is a better way to do things for our customers

    Caring - We care about the work we are doing, our customers and our colleagues
    Sustainable - As a renewable energy company we are providing sustainable products but we also care about sustainable careers. That's why learning and continuous development is so important to us.

    Diversity, Equity, Inclusion & Belonging

    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 not just into our values but throughout our entire culture.