Ecotricity Home
  • My Ecotricity Jobs
  • Register

Senior SQL Analyst

Location:
Hybrid
Salary Details:
Depending on Experience
06 Oct 2024
About The Role
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, all within a regulatory framework shaped by quality, compliance and a drive for exceptional customer service.

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 Attributes /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.
  • Databricks expertise.
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, gym, 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 it's people in the best possible way at all times and helps the employees to make 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 and sun parks in Britain. We call this 'bills in to mills'. In 2021, we started work on building two new solar parks, and now, in 2023, we're bringing geothermal energy to our customers' fuel mix, a first in the UK. We're also developing green gas mills which will generate 100% green gas from a source that we will never run out of- grass.

We don't just focus on energy though- we built Electric Highways, Britain's leading network of electric vehicle charging points, we helped Forest Green Rovers become the greenest football club in the world, and, in partnership with RSPB, we launched Britain's greenest mobile phone service, Ecotalk.

Ecotricity is an equal opportunities employer and is committed to providing equality for all.