So Energy was created in 2015 because we knew energy suppliers could be better. Since then, we’re grown rapidly but sustainably, with 300,000+ customers and over 300 So Energists. But, we’re not done. We’re on the road to a million customers by the end of 2026 and, thanks to our recent merger with ESB Energy, we’re well on the way. We’re tech first, we’re customer-centric and we’re passionate about sustainability.
We want to do the best we can by our customers and by each other, so we’ve created a workplace that is encouraging, supportive and offers the opportunity for growth. As a company, we live by six core values that guide everything we do.
- Clear
- Honest
- Ambitious
- Inquisitive
- Caring
- Sustainable
We are looking for a Business Intelligence Data Analyst who 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.
Requirements
- As a BI Data Analyst you will need to be a detailed orientated individual who has a passion for analysing data
- This will require you to learn and fully understand our data landscape both from a source system and reporting perspective
- 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 prior to it being shared with the business
- 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 and extensive hands-on experience in building dashboards using Google Looker which are insightful and builds a data storyline which makes sense to your 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
What you will be doing
- 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 and Python
- Research new data sources which will add value into the reporting that you will be delivering
- Define metrics that are suited to business monitoring
- 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
- Model data within Looker (LookML) which conforms to standards and principles that keeps the quality and integrity of the Looker backend intact
- Input and guide on new standards to improve our delivery of dashboards and the quality of our outputs
- 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 standups
- Communicate status, blockers, and progress clearly
Benefits
- Competitive salary
- Hybrid remote working
- Life Assurance 4x Base Salary
- Bonus Up to 10% of Base Salary
- 25 days holiday, plus bank holidays, and an extra day holiday for your birthday
- Perkbox
- Ongoing support and development as well as a generous learning and development budget
- Free daily breakfast
- Great reward and recognition
- Exposure to all parts of a growing business
- Pension matching as part of auto-enrolment pension sc