Senior Data Engineer

Senior Data Engineer Front Office Data Products London Full time Hours 40 hours per week Hybrid Minimum 3 days per week in the office Working pattern Monday to Friday, 08:30 - 17:30 About EDF Trading When you join EDF Trading, you’ll become part of a diverse international team of experts who challenge conventional ideas, test new approaches, and think outside the box. Energy markets evolve rapidly, so our team needs to remain agile, flexible, and ready to spot opportunities across all the markets we trade in: power, gas, LNG, LPG, oil, and environmental products. EDF Group and our customers all over the world trust that their assets are managed by us in the most effective and efficient manner and are protected through expert risk management. Trading for over 20 years, it’s experience that makes us leaders in the field. Energy is what we do. We are EDF Trading, part of the EDF Group - a world leader in low-carbon, sustainable electricity generation. Join us, make a difference, and help shape the future of energy. The team The Front Office Data Products team serves a variety of stakeholders across the Front Office, including traders, risk and senior management. We work with lots of different internal and external data sources, building and maintaining data pipelines, data models, and data products to support trading decisions and critical business processes. The team is currently expanding its capabilities to support real-time use cases alongside existing batch processing workflows, and is also expanding its Python data visualisation capabilities. Position purpose We are looking for a hands-on Senior Data Engineer to join our team to accelerate the delivery of high-value data products to the business. This person will be someone with strong Python fundamentals, experience with orchestration tools and Python data visualisation/UI tooling (ideally Plotly Dash) and will be someone who can communicate effectively with both business stakeholders and technical colleagues. 1 EDF Trading | Senior Data Engineer | JR1001537 Main responsibilities • Build and maintain data pipelines that integrate with existing trading workflows and business processes, including operational ownership (monitoring, alerting, incident support) and embedding data quality controls (validation, anomaly detection). • Collaborate with stakeholders across different teams within the front office to understand requirements, translate business needs into technical tasks, and deliver high-quality data products. Explain trade-offs clearly and align on practical delivery plans. • Contribute to architectural decisions on how to implement pipelines and systems. • Design database schemas and SQLAlchemy ORM models to support our data needs and cater for data quality and data governance requirements. • Utilise streaming technologies and event driven architecture to build real time visualisations. • Develop dashboards and data products using Python UI tools (Plotly Dash, Streamlit or similar). • Participate in peer reviews and uphold engineering standards across the team (coding conventions, testing, CI/CD, observability, security-by-design). • Tune and optimise SQL queries for performance. • Work with DevOps processes (Azure DevOps, CI/CD pipelines, Docker, Kubernetes). • Take ownership of work end-to-end: prioritise effectively, communicate with stakeholders, plan out the work, manage risks and dependencies, and drive tasks through to completion. • Be a role model for Python (and data engineering) best practices in the team. 2 EDF Trading | Senior Data Engineer | JR1001537 Experience and technical requirements Essential • Strong Python and SQL experience. • Data orchestration tools (Airflow, Dagster, Prefect). • Designing database schemas and ORM models (e.g. SQLAlchemy). • SQL query performance tuning and optimisation. • Python UI/dashboard tools (Plotly Dash, Streamlit or similar). • DevOps experience (CI/CD pipelines, Azure DevOps or similar). • Strong communication skills - ability to work with both technical colleagues and business stakeholders. Strongly preferred • Kafka or other streaming technologies (e.g. Azure Event Hubs). • Kubernetes. • Docker and containerisation. • Azure Cloud services (Blob Storage, Application Insights, KeyVault, Azure DevOps). • Commodities trading or financial services background. Nice to have • Dagster. • Tableau experience. Benefits and culture You will be offered a great range of benefits, which include (location dependent) hybrid working, a personal pension plan, private medical and dental insurance, bi-annual health assessments, corporate gym memberships, an electric car lease programme, childcare vouchers, a cycle-to-work scheme, season ticket loans, volunteering opportunities, and much more. Gender balance and inclusion are very high on the agenda at EDF Trading, so you will become part of an ever-diversifying family of around 750 colleagues based in London, Paris, Singapore, and Houston. Regular social and networking events, both physical and virtual, will ensure that you always feel connected to your colleagues and the business. 3 EDF Trading | Senior Data Engineer | JR1001537