SQL Data in City of London

SQL Data in City of London

City of London Full-Time 45000 - 55000 € / year (est.) No home office possible
Digital Waffle

At a Glance

  • Tasks: Analyse and model data for renewable energy projects using Python and optimisation techniques.
  • Company: A leading renewable energy advisory firm focused on sustainability.
  • Benefits: Competitive salary, hybrid working, and opportunities for professional growth.
  • Other info: Collaborate with industry experts on innovative projects in a dynamic environment.
  • Why this job: Make a real impact in the transition to renewable energy while honing your analytical skills.
  • Qualifications: 3 years of experience in data analysis, strong Python skills, and knowledge of energy systems.

The predicted salary is between 45000 - 55000 € per year.

A specialist renewable energy advisory firm is hiring a Data & Modelling Analyst to support quantitative analysis and modelling across major energy and infrastructure projects. This is a highly analytical role focused on energy systems, optimisation modelling and data-driven decision making. You will work closely with developers, utilities, investors and government bodies on projects related to renewable energy, storage, market design and decarbonisation.

Salary: Competitive, dependent on experience

Location: London, hybrid working (typically once per week onsite or less)

What you’ll be doing:

  • Prepare, structure and analyse large datasets across energy markets, grid systems and policy scenarios
  • Build and run mathematical optimisation and simulation models using Python
  • Support analysis across areas such as storage optimisation, dispatch modelling and market simulations
  • Develop dashboards, notebooks and reporting outputs to communicate modelling insights clearly
  • Contribute to scenario analysis and strategic recommendations for clients across the renewable energy sector
  • Work closely with senior consultants and external stakeholders on complex analytical projects
  • Help improve reproducibility, data workflows and modelling processes across the business

What you’ll need:

  • Around 3 years’ commercial experience within data analysis, modelling or energy analytics
  • Strong Python skills including pandas, NumPy, SciPy and data visualisation libraries
  • Experience with mathematical optimisation or modelling techniques such as LP/MILP
  • Understanding of electricity markets, power systems or renewable energy environments
  • Experience with Power BI and basic SQL
  • Comfortable working with large, imperfect real-world datasets
  • Ability to explain complex analytical findings to non-technical stakeholders
  • Self-sufficient and organised working style

Nice to have:

  • Experience within energy modelling, storage optimisation or decarbonisation projects
  • Understanding of machine learning concepts or forecasting models
  • Familiarity with Git and collaborative coding workflows
  • Interest in renewable energy, climate technology and energy transition projects

This role would suit someone who enjoys combining technical modelling skills with real-world energy challenges, and who wants to contribute to projects supporting the transition to renewable energy.

SQL Data in City of London employer: Digital Waffle

As a leading renewable energy advisory firm, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to make a meaningful impact in the transition to sustainable energy. With competitive salaries, hybrid working arrangements, and ample opportunities for professional growth, our Data & Modelling Analyst role offers a unique chance to engage with diverse stakeholders while developing your analytical skills in a supportive environment. Join us in shaping the future of energy systems and contribute to projects that drive decarbonisation and market optimisation.

Digital Waffle

Contact Detail:

Digital Waffle Recruiting Team

StudySmarter Expert Advice🤫

We think this is how you could land SQL Data in City of London

Network Like a Pro

Get out there and connect with people in the renewable energy sector! Attend industry events, webinars, or even local meetups. The more you engage with professionals, the better your chances of landing that Data & Modelling Analyst role.

Show Off Your Skills

When you get the chance to chat with potential employers, don’t hold back on showcasing your Python skills and analytical prowess. Bring examples of your work, like dashboards or models you've built, to demonstrate your capabilities in real-time.

Tailor Your Approach

Make sure to tailor your conversations and presentations to highlight how your experience aligns with their needs in energy systems and optimisation modelling. Speak their language and show them you understand the challenges they face in the renewable energy space.

Apply Through Our Website

Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search and genuinely interested in joining our team.

We think you need these skills to ace SQL Data in City of London

Data Analysis
Mathematical Optimisation
Python
pandas
NumPy
SciPy
Data Visualisation

Some tips for your application 🫡

Tailor Your CV:Make sure your CV is tailored to the Data & Modelling Analyst role. Highlight your experience with Python, data analysis, and any relevant projects in renewable energy. We want to see how your skills match what we're looking for!

Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about renewable energy and how your background makes you a great fit for our team. Keep it concise but impactful – we love a good story!

Showcase Your Technical Skills:Don’t forget to mention your technical skills, especially with Python, SQL, and any optimisation techniques you've used. We’re keen on seeing how you’ve applied these skills in real-world scenarios, so be specific!

Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep everything organised and ensures your application gets the attention it deserves. Plus, it’s super easy!

How to prepare for a job interview at Digital Waffle

Know Your Data Inside Out

Make sure you’re well-versed in the datasets relevant to the role. Brush up on your experience with large, imperfect datasets and be ready to discuss how you've handled them in the past. This will show your analytical skills and understanding of real-world data challenges.

Show Off Your Python Skills

Prepare to demonstrate your Python prowess, especially with libraries like pandas, NumPy, and SciPy. You might be asked to solve a problem or explain a model you've built, so have examples ready that highlight your coding abilities and optimisation techniques.

Communicate Complex Ideas Simply

Since you'll need to explain findings to non-technical stakeholders, practice breaking down complex concepts into simple terms. Think of examples where you’ve successfully communicated technical information and be prepared to share those stories during the interview.

Be Ready for Scenario Analysis

Expect questions about scenario analysis and strategic recommendations. Prepare to discuss how you approach modelling for different energy scenarios and what insights you've derived from past projects. This will demonstrate your ability to think critically about energy systems.