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

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

  • SQL Analyst

    24 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

    14 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

    20 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

    24 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

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

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

  • Service IT Developer

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

  • Service IT Developer

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

  • Pricing 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...

  • Pricing 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...

  • Pricing 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 Analyst

    21 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

    1 day 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...

  • Sophisticated Automation Specialist

    4 weeks ago

    Stroud, Gloucestershire, United Kingdom Ecotricity Full time

    About The RoleWe're looking for a skilled professional to join our Pricing team at Ecotricity, a pioneering green energy company. You will be responsible for maintaining and developing our automated pricing systems, used for quoting activity, profitability analysis, and tariff development.Key ResponsibilitiesDevelop and maintain our core automated pricing...

  • Energy Pricing Specialist

    1 day 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 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,...