Municipality of Athens, Attica, Greece · Hybrid
This is an opportunity for a talented professional to join our Statistics and Reporting team as an Energy Data Analyst. You will be responsible for managing market data workflows, optimization, and reliability of HEnEX r…
Skills: SQL Server Analysis Services, SSAS, T-SQL, PL/SQL, Power BI
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
The Energy Data Analyst will manage market data workflows, optimize reporting mechanisms, and design statistical databases for HEnEX. Responsibilities include developing SSAS models, maintaining ETL pipelines, and monitoring market KPIs to ensure data integrity and regulatory compliance.
Candidates should have at least 2 years of experience in the energy sector and deep expertise in SSAS, SQL, and Power BI. Proficiency in data modeling, XML processing, and familiarity with energy market regulations like REMIT is highly preferred.
This is an opportunity for a talented professional to join our Statistics and Reporting team as an Energy Data Analyst. You will be responsible for managing market data workflows, optimization, and reliability of HEnEX reporting mechanisms for energy as well as the design and architecture of HEnEX’s statistical databases.
Your duties and responsibilities will include:
⚙️ Data Engineering & Modeling
SSAS Data Modeling: Architect, deploy, and maintain enterprise SQL Server Analysis Services (SSAS) models, including Tabular and/or Multidimensional cubes, to serve as a single source of truth for energy market metrics.
Database & ETL Architecture: Design, implement, and optimize database changes and statistical data schemas across both Microsoft SQL Server (T-SQL) and Oracle (PL/SQL) environments.
Exchange Protocols & XML Processing: Build and maintain automated pipelines to ingest, parse, and validate complex market data from various sources, specializing in XML files and structured exchange data protocols.
Data Security Compliance: Follow established organizational security standards for data protection, ensuring database permissions and basic data-at-rest/in-transit configurations align with compliance mandates.
Infrastructure Monitoring: Develop and refine in-house or third-party monitoring tools to oversee the performance and integrity of HEnEX reporting mechanisms.
📊 Market Data Management, Reporting Automations and BI
Data Workflow & Reporting: Manage, validate, and deliver daily, periodic, and ad-hoc market reports, statistics, and indicators.
Power BI Integration: Connect Power BI seamlessly to underlying SSAS semantic models. Implement advanced DAX queries, performance tuning, and optimization for fast report rendering across large-scale transactional datasets.
Advanced Analytics & KPIs: Lead the analysis of large-scale data warehouses to develop, refine, and monitor critical market KPIs, trading alerts, and statistical anomalies.
Market Operations & Invoicing: Oversee and run the automated tasks for calculating and invoicing charging fees and penalties for HEnEX members according to the regulatory framework.
👥 Leadership & Compliance
Regulatory compliance: Stay abreast of regulatory changes which affect the business of the Department (REMIT and other regulatory framework).
Mentorship: Actively mentor junior and mid-level analysts, fostering a culture of technical excellence in SQL, SSAS modeling, Power BI, and modern data practices.
Documentation & Governance: Ensure comprehensive, end-to-end technical documentation is created and maintained for all database designs, SSAS models, ETL pipelines, and reporting solutions.
Qualifications & Requirements
University degree in Mathematics/Economics / Finance / Business or Engineering (preferably, Electrical or Computer).
Energy Sector Background: 2+ years of experience in the energy sector is strongly preferred.
Regulatory Understanding: Familiarity with energy market regulation (REMIT, REMIT transaction reporting, or ACER guidance) will be considered an advantage.
Technical & Tooling Skills
SSAS Expertise: Deep, hands-on experience building, deploying, and optimizing data models within SQL Server Analysis Services (SSAS). Advanced knowledge of DAX and MDX is essential.
Database Mastery: Deep expertise in writing, debugging, and optimizing complex queries, stored procedures, and packages in SQL Server (T-SQL) and Oracle SQL (PL/SQL).
BI & Reporting: Advanced proficiency in MS Power BI (connecting to SSAS models, row-level security implementation, and advanced data visualization) and advanced Excel.
Data Protocols & Formats: Hands-on experience working with electronic exchange data protocols and processing/parsing XML schemas.
Data Security (Basic): Basic familiarity with corporate data security concepts (e.g., recognizing when data requires secure transit protocols like SFTP or HTTPS). Deep cryptographic or encryption-building experience is not required.
Programming: Advanced knowledge of Python or R (specifically for data engineering, ETL scripting, or advanced XML parsing) is highly preferred.
Soft Skills & Languages
Strong analytical thinking with high attention to detail and data integrity.
Ability to translate business needs into technical requirements for IT partners.
Excellent verbal and written communication skills in both Greek and English.
What we offer
Hybrid working model
Competitive base salary
Annual bonus based on company and individual performance
Private health & life insurance with free inclusion of family members
Family benefits (Kindergarten and summer camp allowance, Christmas gifts, increased parental leave, etc.)
Subsidized meals in company restaurant
24/7 employee assistance program
Participation in company sports activities (e.g., soccer, basketball, beach volleyball, pilates)ob ad isn't too long
EnExGroup is a leading European energy exchange providing a comprehensive suite of energy market services. It operates the Spot Electricity Markets, the Energy Derivatives Market, the Natural Gas Trading Platform, and a dedicated Power Purchase Agreements (PPA) platform. With its expanding portfolio, EnExGroup plays a central role in supporting the integration and efficient operation of Greece’s energy markets within the broader European energy landscape. The Group consists of the Hellenic Energy Exchange S.A. (HEnEx S.A.) and EnEx Clearing House S.A. (EnExClear S.A.). How it started HEnEx was established on 18 June 2018, following the spin-off of the Electricity Market branch of LAGIE S.A. (now DAPEEP S.A.). Building on over a decade of experience operating the Day-Ahead Scheduling Energy Transactions System, HEnEx was designated by the Greek Regulatory Authority for Energy (RAEYY) on 16 November 2018, as a Nominated Electricity Market Operator (NEMO), for the Day-Ahead and Intraday Electricity Markets. Since 16 March 2020, following the approval of the Hellenic Capital Market Commission (HCMC), HEnEx also operates the Energy Financial Market. EnExClear, established on 2 November 2018 as a subsidiary of HEnEx, is responsible for the clearing and settlement of transactions in the Day-Ahead and Intraday Markets, as well as the Balancing Market.
Offices: 110 Athinon Ave., Athens, Attica 10442, GR
EnExGroup is a leading European energy exchange providing a comprehensive suite of energy market services. It operates the Spot Electricity Markets, the Energy Derivatives Market, the Natural Gas Trading Platform, and a dedicated Power Purchase Agreements (PPA) platform. With its expanding portfolio, EnExGroup plays a central role in supporting the integration and efficient operation of Greece’s energy markets within the broader European energy landscape. The Group consists of the Hellenic Energy Exchange S.A. (HEnEx S.A.) and EnEx Clearing House S.A. (EnExClear S.A.). How it started HEnEx was established on 18 June 2018, following the spin-off of the Electricity Market branch of LAGIE S.A. (now DAPEEP S.A.). Building on over a decade of experience operating the Day-Ahead Scheduling Energy Transactions System, HEnEx was designated by the Greek Regulatory Authority for Energy (RAEYY) on 16 November 2018, as a Nominated Electricity Market Operator (NEMO), for the Day-Ahead and Intraday Electricity Markets. Since 16 March 2020, following the approval of the Hellenic Capital Market Commission (HCMC), HEnEx also operates the Energy Financial Market. EnExClear, established on 2 November 2018 as a subsidiary of HEnEx, is responsible for the clearing and settlement of transactions in the Day-Ahead and Intraday Markets, as well as the Balancing Market.
Offices: 110 Athinon Ave., Athens, Attica 10442, GR
