(Senior) Data and Automation Analyst - Commodity Accounting Exchanges d/f/m

RWE Supply & Trading GmbH
To start as soon as possible, full time / part time, Secondment (14 months)

Join the Commodity Accounting Exchanges team on a fixed-term basis and help transform our global exchange accounting processes. As the central accounting hub for exchange-related activities across Supply & Trading GmbH (RWEST), the team supports a rapidly growing portfolio of products, exchanges and legal entities worldwide. 
You will apply your data analytics and automation expertise as well as your process understanding to analyse exchange-related trading data, automate recurring activities and improve the quality, efficiency and resilience of our accounting processes.

About the role

• Take ownership of key exchange accounting processes and drive their continuous improvement through automation, data analytics and process optimisation, increasing accuracy, transparency and efficiency across the end-to-end process landscape.


• Analyse trading, margin, P&L and cash flow data to generate actionable insights and support business-critical decisions.


• Develop and enhance scalable reporting, analytics and data solutions using SQL, Power Query, Power BI and comparable technologies.


• Lead cross-functional initiatives and collaborate with stakeholders across Accounting, Risk, Trading, Clearing and Operations to deliver data-driven and process-focused improvements.


• Support the integration of new exchanges, products and business requirements into a scalable and resilient accounting framework.


• Translate complex data into meaningful insights and recommendations for management and subject matter experts.

Job requirements and experience

• Strong IT or finance background, ideally with exposure to commodity trading, exchange-traded products, clearing or settlement processes.


• Proven experience in data analysis, process optimisation and automation within commodity trading, energy markets, financial services or another data-intensive environment.


• Confident handling large data sets, using tools such as SQL, advanced Excel, Power Query or Power BI.


• Demonstrated ability to independently drive process improvements and translate business requirements into scalable analytical solutions.


• Strong communication, ownership and collaboration skills, with fluent business English and the ability to align international, cross-functional stakeholders.

Advantageous, but not essential

• Good understanding of exchange-traded products, derivatives, margining and related business workflows.


• Experience with Python or another programming language for advanced analytics, automation, data engineering or AI-enabled solutions.


• Experience with commodity trading platforms and industry-specific systems such as Endur, SAP S/4HANA or comparable trading and accounting solutions.


• Knowledge of accounting, risk management, financial reporting or regulatory requirements within commodity trading and exchange-related businesses.


• Good German language skills to support collaboration with local stakeholders and documentation requirements where needed.

RWE is committed to creating a diverse and inclusive environment – we value your passion, your willingness to learn and your desire to thrive. Even if you don't have all the above skills, need flexible working arrangements or other adjustments not yet listed here, we'd love to hear from you.

Your benefits

• Play a key role in modernising exchange accounting processes within one of Europe’s leading energy trading organisations.


• Work closely with experts across Trading, Risk, Operations and Finance in a highly international environment.


• Develop solutions with lasting impact that improve how RWEST manages exchange-related processes globally.

Apply with just a few clicks: ad code 93463
Any questions? Contact HR: Pia König, +49 152 09448320

We look forward to meeting you. Of course, you can find us on LinkedIn, Instagram, Facebook, YouTube and Xing, too.

We value diversity and therefore welcome all applications - regardless of gender, disability, nationality, ethnic and social origin, religion/belief, age, sexual orientation, and identity. #inclusionmatters

RWE Supply & Trading is our connection to the world’s energy markets. Headquartered in Essen, Germany, the company operates one of Europe’s largest and most advanced energy trading floors. A diverse team of over 2,300 professionals from around 90 countries trades electricity, gas, commodities, and CO2 emission allowances. With precise market analysis and a strong customer focus, we create innovative energy supply solutions and tailored risk management concepts for industrial clients.

We also ensure the commercial optimisation of RWE’s power plant portfolio and market the electricity generated by RWE. In addition, legally independent RWE gas storage companies operate in Germany, contributing to a secure energy supply.