Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: As an SQL Analyst, you'll design and deliver data solutions to enhance insights for stakeholders.
- Company: Join Ecotricity, the world's first Green Electricity Company, leading the green energy revolution since 1996.
- Benefits: Enjoy hybrid work, healthcare plans, generous holidays, and discounts on various services.
- Why this job: Be part of a passionate team making a real impact in the green energy sector.
- Qualifications: Proficiency in SQL, data visualization, and strong problem-solving skills are essential.
- Other info: Work in Stroud 3 days a week, with flexibility to adapt to changing business needs.
The predicted salary is between 36000 - 60000 ÂŁ per year.
Location: Hybrid – Stroud
Salary Details: Depending on Experience
About The Role
About usâŚ
Green Electricity didn\’t exist in the world back in 1996. When we offered it for the first time, we became not just Britainâs but the worldâs first Green Electricity Company â and kick-started the now global Green Electricity movement. Our mission was and remains to change the way electricity is made and used in Britain.
We operate a unique model. We use our customersâ energy bills to fund the building of new sources of Green Energy. We like to refer to this as turning âBills into Millsâ â energy bills into energy mills, whether thatâs wind, sun, sea or gas. And weâre a not-for-dividend company â the money we make goes back into our mission.
At the heart of this business is a team of fantastic people – energetic and passionate about what we do, who work together to make things better and who are keen to âshake things up a bitâ by challenging what others see as âconventional wisdomâ.
About the roleâŚ
This role sits within our Commercial Credit Management Department, which handles activity relating to the collection of unpaid energy bills. Reporting to the Commercial Debt Performance & Development Manager, 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 will be required to support members of the wider 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 Behaviors/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.
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.
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, 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 targets to make the Green Britain Group net carbon neutral by 2025
Flexibility statement
The fast moving nature of the company\’s 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 use its people in the best possible way at all times and helps the employees to make their contribution in a changing environment.
Ecotricity is Britain\’s greenest energy company. 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 build windmills, sun parks and green gasmills in Britain. We call this turning \’bills into mills\’. Some of our biggest achievements to date include building Britain\’s first megawatt windmill and the country\’s first grid-scale sun park, as well as building our first green gasmill, generating 100% green gas from a source that we will never run out of grass.
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 employer: Ecotricity
Contact Detail:
Ecotricity Recruiting Team
StudySmarter Expert Advice đ¤Ť
We think this is how you could land SQL Analyst
â¨Tip Number 1
Familiarize yourself with the energy industry, especially green energy initiatives. Understanding the company's mission and how they operate can help you tailor your conversations during interviews and demonstrate your genuine interest in their work.
â¨Tip Number 2
Brush up on your SQL skills, particularly complex query writing. Since selected candidates will undergo a practical SQL test, practicing real-world scenarios can give you an edge and boost your confidence.
â¨Tip Number 3
Showcase your problem-solving abilities by preparing examples of how you've tackled data challenges in the past. Be ready to discuss specific situations where you identified trends or improved processes, as this aligns with the role's requirements.
â¨Tip Number 4
Highlight your communication skills by preparing to explain complex data insights in simple terms. The ability to convey information effectively to stakeholders is crucial, so practice summarizing technical concepts for a non-technical audience.
We think you need these skills to ace SQL Analyst
Some tips for your application đŤĄ
Tailor Your CV: Make sure your CV highlights your experience in data analysis, SQL proficiency, and any relevant projects. Emphasize your problem-solving skills and ability to work with large datasets, as these are crucial for the role.
Craft a Strong Cover Letter: In your cover letter, express your passion for green energy and how your skills align with the company's mission. Mention specific experiences that demonstrate your ability to design and deliver data solutions.
Showcase Communication Skills: Since strong communication is key for this role, provide examples in your application of how you've effectively communicated complex data insights to stakeholders in the past.
Prepare for the SQL Test: Brush up on your SQL skills, especially writing complex queries. Be ready to demonstrate your proficiency during the practical SQL test that selected candidates will undergo.
How to prepare for a job interview at Ecotricity
â¨Show Your SQL Skills
Since the role requires advanced proficiency in SQL, be prepared to discuss your experience with writing complex queries. You might even face a practical SQL test, so brush up on your skills and be ready to demonstrate your problem-solving abilities with real data scenarios.
â¨Communicate Clearly
Strong communication skills are essential for this position. Practice explaining technical concepts in simple terms, as you will need to convey key information to stakeholders. Think about examples where you've successfully communicated complex data insights in the past.
â¨Understand the Energy Sector
While knowledge of the energy industry is not essential, having a basic understanding can set you apart. Research current trends in green energy and familiarize yourself with how data analytics plays a role in this sector. This will show your genuine interest in the company's mission.
â¨Demonstrate a Collaborative Mindset
The company values teamwork and collaboration. Be ready to share examples of how you've built relationships with colleagues or stakeholders in previous roles. Highlight your ability to work under pressure and how youâve contributed to team success in challenging situations.
