At a Glance
- Tasks: Design and deliver data solutions to enhance insights for stakeholders in the finance sector.
- Company: Join Ecotricity, Britain's greenest energy company, committed to sustainability.
- Benefits: Enjoy healthcare, generous pension, hybrid working, and 25 days holiday plus bank holidays.
- Other info: Collaborative environment with opportunities for personal and professional growth.
- Why this job: Make a real impact in the energy industry while developing your data skills.
- Qualifications: Proficient in SQL, data analysis, and strong communication skills required.
The predicted salary is between 35000 - 45000 £ per year.
This role sits within our Finance Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group. Reporting to the Head of Debt Information and Risk, this technical role will require you to design, scope, develop and deliver data solutions to meet the requests of stakeholders, while seeking opportunities to improve data insight.
About you… You will be an experienced data analyst with a proven track record in BI, data manipulation and problem solving. You’ll have experience in building relationships and mentoring junior members of a team. The role will require you to be a strong communicator, both written and verbally, with the ability to convey key information in a variety of digestible formats, providing delivery timescales and using strong stakeholder management skills to communicate these. Knowledge of the Energy industry would be beneficial but not essential.
Key Behaviours/Competencies
- You will have a questioning mind, not accepting of answers at face value, you will seek to obtain corroborating evidence for information received.
- Making complex decisions – You will demonstrate abilities to manage high quantities of data, to make good and timely decisions.
- Building collaborative relationships – You will hold yourself and others accountable to consistently achieve results.
- Identify trends to define and improve business strategies.
- Review reporting methods and processes, maximising the opportunity to automate wherever possible.
- Act as a key point of contact for both regulatory and operational reporting.
What will you bring…
- Proficiency in Databricks
- Advanced data pipeline design and development
- Data quality and governance
- Data integration processes
- Data visualisation tools development
- Data warehouse and data mart design and development
- ETL (Extract, Transform, Load) processes.
- Knowledge of Big Data technologies (Spark)
- Data modelling and architecture
- Advanced analytics and high proficiency in SQL query writing.
- Strong problem-solving skills
- Excellent communication and presentation skills
- Stakeholder management and facilitation of decisions of all sizes
- Strong presentation skills for engaging senior stakeholders.
- Ability to effectively manage high pressure situations.
About You
Essential:
- Writing complex SQL queries for data retrieval and manipulation across multiple tables / data sources.
- Selected candidates will undergo a practical SQL test to assess proficiency.
- A resilient ‘can do’ attitude. Demonstrating persistence to work through complex problems independently.
- The role is Hybrid and requires the successful candidate to work in the Stroud (UK) office 3 days per week with the remaining days working from home.
- A keen eye for detail and accuracy in delivery to requirements.
- Databricks expertise
Advantageous:
- Utilities sector experience
About Us
What's in it for you...
- Healthcare plan, life assurance and generous pension contribution
- Volunteering Day
- Hybrid Working
- Various company discounts (including shops, gyms, days out and events)
- Holiday of 25 days (plus bank holidays) & ability to buy/sell days
- Cycle to work scheme, car pooling and onsite parking available
As a valued member of the team, you will be supporting the Group Environmental Policy and its associated sustainability objectives and targets.
Flexibility Statement
The fast moving nature of the business means that from time to time you may be asked to perform duties or tasks outside of your original job description on an ad hoc basis. This allows the company to utilise our people in the best possible way at all times and helps our colleagues to make the best contribution in a changing environment.
Ecotricity is Britain's overall greenest energy company- it’s more than just green energy – the breadth and depth of our work on green issues is unmatched. When we started back in 1995, we were the first company in the world to provide a new kind of electricity - the green kind. Our mission was, and remains, to change the way energy is made and used in Britain - by replacing fossil fuels with clean, renewable energy.
We don't just supply green energy, we use the money from our customers' bills to make it ourselves too – we have built windmills and sun parks in Britain. We call this turning 'bills into mills'. We don't just focus on energy though- we built the Electric Highway, Britain's leading network of electric vehicle charging points; we helped Forest Green Rovers become the greenest football club in the world; and we launched Britain's greenest mobile phone service, Ecotalk, where they use the money from their customers' bills to protect and regenerate Britain's lost rainforests.
Ecotricity is an equal opportunities employer and is committed to providing equality for all.
SQL Analyst in Stroud employer: Ecotricity Jobs
Ecotricity is an exceptional employer, offering a dynamic work culture that prioritises sustainability and employee well-being. With a hybrid working model based in Stroud, employees benefit from a comprehensive healthcare plan, generous pension contributions, and opportunities for personal growth through mentoring and collaboration. Join us to be part of a pioneering team dedicated to transforming the energy sector while enjoying a supportive environment that values your contributions and encourages innovation.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Analyst in Stroud
✨Tip Number 1
Network like a pro! Reach out to current employees at Ecotricity on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for landing the SQL Analyst role. Building connections can give you insider info and make your application stand out.
✨Tip Number 2
Prepare for that practical SQL test! Brush up on your SQL skills and practice writing complex queries. Use online resources or even our StudySmarter platform to sharpen your data manipulation techniques. Being well-prepared will boost your confidence and show you're serious about the role.
✨Tip Number 3
Show off your problem-solving skills in interviews! Be ready to discuss past challenges you've faced as a data analyst and how you tackled them. Use the STAR method (Situation, Task, Action, Result) to structure your answers and highlight your analytical prowess.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Ecotricity team. Let’s get you that SQL Analyst position!
We think you need these skills to ace SQL Analyst in Stroud
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the SQL Analyst role. Highlight your experience with SQL, data manipulation, and any relevant projects that showcase your skills in BI and problem-solving.
Showcase Your Communication Skills:Since this role requires strong communication abilities, include examples of how you've effectively conveyed complex information in previous roles. This could be through presentations, reports, or mentoring junior team members.
Demonstrate Your Analytical Mindset:We love candidates who question the status quo! In your application, mention instances where you've sought corroborating evidence or made data-driven decisions. This will show us your analytical prowess and attention to detail.
Apply Through Our Website:Don't forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it shows you're keen on joining our team!
How to prepare for a job interview at Ecotricity Jobs
✨Know Your SQL Inside Out
Since this role requires advanced SQL skills, make sure you brush up on writing complex queries. Practise retrieving and manipulating data across multiple tables, as you'll likely face a practical SQL test during the interview.
✨Showcase Your Problem-Solving Skills
Prepare to discuss specific examples where you've tackled complex data issues. Highlight your thought process and how you arrived at solutions, as this will demonstrate your analytical abilities and resilience.
✨Communicate Clearly and Effectively
As a strong communicator, you’ll need to convey technical information in an understandable way. Practise explaining your past projects or data insights to someone without a technical background to showcase your ability to engage stakeholders.
✨Familiarise Yourself with the Energy Sector
While not essential, having some knowledge of the energy industry can give you an edge. Research current trends and challenges in the sector, and be ready to discuss how your skills can contribute to Ecotricity's mission of sustainability.
