At a Glance
- Tasks: Join a dynamic team to analyse and resolve data challenges in energy trading.
- Company: Exciting opportunity within the fast-paced Energy Trading sector.
- Benefits: Competitive £700/day, hybrid working, and a chance to work with top industry professionals.
- Other info: Opportunity for career growth in a collaborative and agile environment.
- Why this job: Make a real impact on trading operations while developing your data skills.
- Qualifications: Strong SQL skills, experience with ETRM systems, and a passion for data analysis.
A Data Business Analyst is required for an exciting long-term contract opportunity within the Energy Trading sector. This data-centric Business Analyst role is ideal for someone who thrives in fast-paced Front Office environments, has strong experience working with data coming from third parties (Bloomberg, Zema etc), the exchanges (Nordpool, EPEX etc) and/or out of ETRMs and other internal systems, and enjoys solving data-based challenges that directly impact trading operations.
You’ll be joining a highly agile Front Office support team that operates on an ad-hoc tactical basis, dealing with incidents and data discrepancies as they arise. This role will see you working closely with traders, quants, and other front office stakeholders to ensure their data and tools run smoothly across Gas, Power, and other commodities.
The role involves working with data feeding from ETRMs (Endur, Coral), UIs and APIs, legacy spreadsheets in Excel and deep diving into the macros, diagnosing issues, and tracing data back to its source, often pulling large datasets directly from SQL databases. As part of the role, you’ll investigate inconsistencies across trade bookings, modelling, or valuation systems — making judgment calls on which issues can be quickly resolved versus those that need long-term development.
The Data Business Analyst Contract
- Hybrid Working (2-3 days in London)
- Support Front Office teams by building curves using market data pulled from third party sources
- Investigate and resolve data inconsistencies between ETRM systems, models, and spreadsheets
- Extract, analyse, and validate data using SQL queries and stored procedures
- Understand ETRM data workflows, exposure, and P&L from a troubleshooting perspective
- Liaise with traders and business users to prioritise issues and determine short vs. long-term fixes
- Ensure accuracy and reliability of spreadsheet-based reporting tools used by Front Office
- Strong SQL skills – able to write and optimise complex queries and scripts
- Experience integrating third party data sources - establishing APIs
- Deep Excel expertise, including experience working with macros and legacy spreadsheets
- Understanding of ETRM systems (Endur, Coral, Previse) and trade data structures
- Knowledge of Front Office operations within Energy Trading (Gas & Power)
- Experience with exposure and P&L troubleshooting
- Ability to analyse data pipelines from UI/API to database to spreadsheet
Nice to Haves
- Familiarity with Python scripting (used by Front Office teams)
- Experience with Tableau or other BI tools
- Knowledge of LNG or Carbon Emissions markets
If you are interested in this Data Business Analyst – Energy Trading role, please apply to the advert or send your CV to sam@virtuetech.io
Data Business Analyst | Energy Trading | Market Data | SQL | Python | £700/Day Inside IR35 employer: VirtueTech Recruitment Group
Join a dynamic and innovative team in the heart of London, where as a Data Business Analyst in the Energy Trading sector, you'll thrive in a fast-paced environment that values agility and collaboration. Our company fosters a culture of continuous learning and growth, offering you the opportunity to work closely with traders and quants while tackling data challenges that have a direct impact on trading operations. With hybrid working options and a focus on employee well-being, we provide a supportive atmosphere that encourages both personal and professional development.
Contact Details:
VirtueTech Recruitment Group Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Business Analyst | Energy Trading | Market Data | SQL | Python | £700/Day Inside IR35
✨Tip Number 1
Network like a pro! Reach out to folks in the energy trading sector on LinkedIn or at industry events. A friendly chat can sometimes lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Prepare a portfolio or case studies showcasing your SQL queries and data analysis projects. This will give potential employers a taste of what you can do with data in real-world scenarios.
✨Tip Number 3
Practice makes perfect! Brush up on your Python and SQL skills before interviews. You might get asked to solve a problem on the spot, so being sharp will definitely give you an edge.
✨Tip Number 4
Apply through our website! We’ve got loads of exciting roles, and applying directly can sometimes speed up the process. Plus, it shows you’re genuinely interested in joining our team!
We think you need these skills to ace Data Business Analyst | Energy Trading | Market Data | SQL | Python | £700/Day Inside IR35
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Data Business Analyst role. Highlight your experience with SQL, Python, and any relevant ETRM systems. We want to see how your skills match what we're looking for!
Showcase Your Data Skills:In your application, don’t just list your skills—show us how you've used them in real-world scenarios. Talk about specific projects where you’ve tackled data challenges, especially in energy trading or similar sectors.
Be Clear and Concise:When writing your application, keep it clear and to the point. Use bullet points for key achievements and make it easy for us to see why you’re a great fit for the role. We love straightforward communication!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to track your application status directly. Don’t miss out on this opportunity!
How to prepare for a job interview at VirtueTech Recruitment Group
✨Know Your Data Inside Out
Make sure you’re well-versed in the data sources relevant to the role, like Bloomberg and ETRMs. Brush up on your SQL skills and be ready to discuss how you've tackled data discrepancies in the past.
✨Understand the Energy Trading Landscape
Familiarise yourself with the basics of energy trading, especially around Gas and Power markets. Being able to speak knowledgeably about market dynamics will impress the interviewers and show your genuine interest in the sector.
✨Prepare for Technical Questions
Expect to dive deep into technical discussions, especially around SQL queries and Excel macros. Practise writing complex SQL scripts and be ready to explain your thought process when troubleshooting data issues.
✨Showcase Your Problem-Solving Skills
Be prepared to share specific examples of how you've resolved data-related challenges in previous roles. Highlight your ability to prioritise short-term fixes versus long-term solutions, as this is crucial in a fast-paced environment.
