SQL Analyst

19 hours ago

Stroud, United Kingdom Ecotricity Full time

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

    8 hours ago

    Stroud, United Kingdom Ecotricity Full time

    Location: Hybrid - StroudSalary Details: Depending on ExperienceAbout The RoleAbout 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...

  • SQL Analyst

    15 hours ago

    Stroud, United Kingdom Ecotricity Full time

    Location: Hybrid - StroudSalary Details: Depending on ExperienceAbout The RoleAbout 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...

  • SQL Analyst

    18 hours ago

    Stroud, United Kingdom Ecotricity Full time

    Location: Hybrid - StroudSalary Details: Depending on ExperienceAbout The RoleAbout 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...

  • Senior SQL Analyst

    4 months ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleSalary Details: Depending on ExperienceThis role sits within our Credit Management Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group.We have the challenging task of balancing the needs of our customers with our needs as a business, all...

  • Senior SQL Analyst

    4 months ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleSalary Details: Depending on ExperienceThis role sits within our Credit Management Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group.We have the challenging task of balancing the needs of our customers with our needs as a business, all...

  • Senior SQL Analyst

    5 months ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleSalary Details: Depending on ExperienceThis role sits within our Credit Management Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group.We have the challenging task of balancing the needs of our customers with our needs as a business, all...

  • Senior SQL Analyst

    1 month ago

    Stroud, United Kingdom Ecotricity Full time

    About The Role Salary Details: Depending on Experience This role sits within our Credit Management Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group. We have the challenging task of balancing the needs of our customers with our needs as a...

  • SQL Analyst

    15 hours ago

    Stroud, UK, Gloucestershire, United Kingdom Ecotricity Full time

    Location: Hybrid - StroudSalary Details: Depending on ExperienceAbout The RoleAbout 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...

  • Data Analyst

    22 hours ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    About the RoleWe are seeking an experienced Data Analyst to join our Trading team at Ecotricity. As a key member of the team, you will be responsible for maintaining and developing automated pricing systems used for B2B quoting activity and profitability analysis on our customer base.The successful candidate will have hands-on experience with SQL, VBA, and...

  • Senior SQL Analyst

    4 months ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    About The Role Salary Details: Depending on Experience This role sits within our Credit Management Department, which handles activity relating to the collection of unpaid energy bills (domestic & business) and other companies within the Ecotricity Group. We have the challenging task of balancing the needs of our customers with our needs as a business,...

  • SQL/Python Developer

    1 month ago

    Stroud, United Kingdom Ecotricity Full time

    About The Role We do an awful lot in the Trading team at Ecotricity. As well as purchasing all of the electricity, gas and renewable certificates for all 190,000 (and counting) customers, we are the team that is responsible for all of the customer pricing, forecasting, and cost/profitability analysis. We love numbers, complex systems, and working out...

  • SQL/Python Developer

    2 months ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleWe do an awful lot in the Trading team at Ecotricity. As well as purchasing all of the electricity, gas and renewable certificates for all 190,000 (and counting) customers, we are the team that is responsible for all of the customer pricing, forecasting, and cost/profitability analysis.We love numbers, complex systems, and working out amazing...

  • SQL/Python Developer

    2 weeks ago

    Stroud, UK, Gloucestershire, United Kingdom Ecotricity Full time

    About The RoleWe do an awful lot in the Trading team at Ecotricity. As well as purchasing all of the electricity, gas and renewable certificates for all 190,000 (and counting) customers, we are the team that is responsible for all of the customer pricing, forecasting, and cost/profitability analysis.We love numbers, complex systems, and working out amazing...

  • Purchasing & Forecast Analyst

    2 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. The Forecasting Team’s role is to predict customer energy and gas usage using a mix of industry formulas and machine learning models. Forecasts are uploaded to our trading...

  • Purchasing & Forecast Analyst

    2 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. The Forecasting Team’s role is to predict customer energy and gas usage using a mix of industry formulas and machine learning models. Forecasts are uploaded to our trading...

  • Junior Forecasting Analyst

    5 days ago

    stroud, United Kingdom Ecotricity Full time

    Job Description About The Role Job Summary: We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. This role is essential to supporting customer demand and long-term generation forecasts, balancing operational forecasting tasks,...

  • Junior Forecasting Analyst

    2 weeks ago

    Stroud, United Kingdom Ecotricity Full time

    About The Role Job Summary: We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. This role is essential to supporting customer demand and long-term generation forecasts, balancing operational forecasting tasks, analytical...

  • Junior Forecasting Analyst

    3 weeks ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleJob Summary:We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. This role is essential to supporting customer demand and long-term generation forecasts, balancing operational forecasting tasks, analytical...

  • Junior Forecasting Analyst

    3 weeks ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleJob Summary:We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. This role is essential to supporting customer demand and long-term generation forecasts, balancing operational forecasting tasks, analytical...

  • Junior Forecasting Analyst

    3 weeks ago

    Stroud, United Kingdom Ecotricity Full time

    About The RoleJob Summary:We are seeking a Junior Forecasting Analyst to join our Trading Team, working closely with our Forecasting and Quants Analyst, and reporting to the Senior Quants and Risk Analyst. This role is essential to supporting customer demand and long-term generation forecasts, balancing operational forecasting tasks, analytical...