SQL/Python Developer

3 months 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 amazing ways to analyse data, use it, and share it in insightful ways. It would be fair to say that we are often at the cutting edge of a forward thinking energy company, and are constantly developing, adapting, and finding new ways of doing things. From battery storage development, to automated trading, it’s an exciting time for energy trading in Ecotricity.


For the right candidate, this role represents a unique opportunity to be part of a growing team in a fast paced and highly challenging environment.


Overall Description of Duties


Sitting as part of the Pricing team, the successful candidate will be responsible for maintaining and developing the automated pricing systems, which are used for not only our B2B quoting activity, but also profitability analysis on our customer base.


These models are always needing to adapt to industry changes, and how as a business we want to understand our customers from a commercial perspective. Given the complexity of how costs blend together in retail supply, it’s a full time job to keep these developed and as efficient as possible.


This function is a critical part of the business. The models owned and operated by the team represent the decisions for areas of the business that represent the majority of revenue for Ecotricity Group.



About You


We are looking for a knowledge coder, who has experience in the retail energy space. Our models are written in VBA, SQL, and Python, so we are looking for individuals that are able to code in these languages, amongst others. The ideal individual has an aptitude for developing both robust, automated systems, as well as working with front end sales teams to develop tools that help the business to sell energy to potential customers.


Core Responsibilities


  • Developing and maintaining the core automated pricing system, which is used for B2B quoting activity, portfolio profitability analysis, and tariff development.
  • Working with the commercial cost analyst to ensure the cost stack is accurately reflected in the modelling framework.
  • Working with the sales team to develop front end tools to help create efficiencies and flexibility in pricing for prospects.
  • Working with stakeholders – profitability analysts, pricing analysts, managers, to ensure the models and systems meet their requirements.



Desirable Skill Set


  • Degree level education in a numerate subject or experience in an analytical commercial role.
  • Hands on experience of key automation and coding frameworks, such as SQL, VBA, Python.
  • Self Starter
  • Track record in creating highly automated systems, that integrate with other areas of businesses.



About Us


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.

  • Python & SQL Developer

    9 hours ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    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 ways to analyse data, use it, and share it in insightful ways. It...

  • SQL/Python Developer

    2 months 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

    3 days 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

    3 days 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...

  • Systems and Web Developer

    2 weeks ago

    Stroud, United Kingdom Fill My Vacancy Full time

    **Job summary** Purpose of the Role: As part of a small development team within our clients ICT service, you will be delivering digital solutions to improve the delivery of their services across the whole organisation. About the role: In addition to a good working knowledge of delivering user centric solutions from concept & design through to delivery &...

  • Renewable Energy Systems Developer

    3 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    Renewable Energy Systems DeveloperWe are seeking an experienced Renewable Energy Systems Developer 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.The successful candidate will have hands-on experience...

  • SQL Analyst

    2 days ago

    stroud, United Kingdom Ecotricity Full time

    Job Description 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....

  • SQL Analyst

    4 weeks 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

    4 weeks 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

    4 weeks 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

    4 days ago

    Stroud, United Kingdom Ecotricity Full time

    Job Description 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...

  • SQL Analyst

    4 weeks 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...

  • Pricing Developer

    3 months 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...

  • Pricing Developer

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

  • Pricing Developer

    3 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 Analyst

    3 weeks ago

    Stroud, Gloucestershire, 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...

  • SQL Analyst

    4 weeks 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

    4 weeks 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...

  • Energy Pricing Specialist

    4 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    Job DescriptionWe are looking for an Energy Pricing Specialist to join our team at Ecotricity. As a specialist in energy pricing, you will be responsible for developing and maintaining automated pricing systems used for B2B quoting activity and profitability analysis.The successful candidate will have a degree-level education in a numerate subject or...

  • Senior Renewable Energy Analyst

    4 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    About UsAt Ecotricity, we're committed to making Britain greener. Our mission is to change the way energy is made and used in our country by replacing fossil fuels with clean, renewable energy.We believe that everyone deserves access to affordable, sustainable energy solutions. As a Senior Renewable Energy Analyst, you'll play a key role in helping us...