Data Analyst – Python & PowerBI Consultant

About the role

The consultant will join the SMA team to enhance data management and visualization processes for large-scale energy market simulations. This role focuses on building data pipelines, creating insightful dashboards, and supporting stakeholders with clear, data‑driven insights.

Key responsibilities

• Design and implement a data warehouse and data pipelines to improve SMA’s data management.
• Explore and analyse large volumes of simulation output from ANTARES and other solvers.
• Benchmark and adapt visualisations from studies such as ERAA, TYNDP, MLZ, NESO‑FES, and RTE.
• Create and update visualisations in PowerBI and, where appropriate, in React.js.
• Develop and maintain Python scripts to process simulation data, identify inconsistencies, and generate reports.
• Present visualisations to key stakeholders, gather feedback, and iterate to meet business needs.
• Propose and prototype a user‑friendly interface for dynamic data exploration that can be shared publicly.
• Consolidate historical data into the new data warehouse and support data‑engineering tasks.

Required profile

• Minimum three years of professional experience (mid‑level).
• Strong interest and knowledge of the energy market.
• Ability to work both independently and collaboratively within a team.
• Analytical mindset with a focus on innovative problem solving.

Required skills

• Python (mandatory)
• PowerBI (mandatory)
• React.js (nice to have)
• ANTARES simulation tool (nice to have)
• Basic understanding of energy systems.