Senior SQL Analyst 12 Month FTC
Posted 3 days ago by Ecotricity
£45,000 Per year
Fixed-Term
Hybrid
Stroud, England, United Kingdom
Summary: This role is for a Senior SQL Analyst within the Credit Management Department at Ecotricity, focusing on the collection of unpaid energy bills. The position involves designing and delivering data solutions while improving data insights and requires strong communication and stakeholder management skills. The ideal candidate will have a background in business intelligence and data analysis, with experience in SQL and PowerBI. Knowledge of the energy industry is beneficial but not essential.
Key Responsibilities:
- Design, scope, develop, and deliver data solutions for stakeholders.
- Improve data insight and reporting methods, maximizing automation opportunities.
- Act as a key point of contact for regulatory and operational reporting.
- Manage and manipulate data effectively to support decision-making.
- Build collaborative relationships and mentor junior team members.
- Communicate key information clearly to stakeholders.
Key Skills:
- Strong technical analytical skills as a Data Analyst.
- Experience in managing and manipulating data.
- Proficient in SQL for data analysis (MS-SQL/Databricks - T-SQL).
- Expertise in PowerBI and advanced MS Excel (Power Query, Power Pivots).
- Strong stakeholder management and presentation skills.
- Ability to handle high-pressure situations.
- Utilities sector experience is advantageous.
Salary (Rate): £45,000.00 yearly
City: Stroud
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: fixed-term
Seniority Level: Mid-Level
Industry: IT
Location: Stroud
Salary Details: Up to £45,000 DOE
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. Reporting to the Head Of Debt Information and Risk, 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 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 Behaviours/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 have a ‘can do’ attitude. Demonstrating persistence to work through complex problems independently. 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…
- Strong technical analytical skills as a Data Analyst
- Managing and manipulating data experience
- Strong working knowledge of SQL for data analysis (MS-SQL/Databricks - T-SQL, View and table design, Experience of ETL)
- Expert with PowerBI
- Advanced MS Excel (Power Query, Power Pivots)
- Stakeholder management and facilitation of decisions of all sizes
- Strong presentation skills for engaging senior stakeholders
- Ability to handle high pressure situations
- Advantageous: Utilities sector experience
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, gyms, 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 sustainability objectives and targets.
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.