We are EDP, a general energy company present in around 29 markets with a particular emphasis on renewable energies. With more than 45 years of experience, we have been consolidating a relevant presence on the world energy scene based on the commitment to be all-green by 2030, leading the energy transition. With more than 13,000 employees around the world, we are committed to using our energy and heart to drive a better tomorrow.
The mission of Operational Data Office and Reporting area is to ensure the EDPR Corporate Operational Reporting and KPI generation and the management of the Operational Data and Reporting solutions to grant the standardization, governance, quality and optimization of the data and reporting processes to add value to the business.
Operational Data Office main accountabilities: Management of the Interstellar Datahub Solution, ensuring the internalization of the functional maintenance and evolution activities of EDPR’s operational data solutions. Ensure the design, development, engineering, evolution and technical ownership of the Operational Interstellar datahub and cloud-based operational data platform. Coordination with Operational Reporting Solution, ensuring the alignment with the data model and available information in Interstellar Datahub Solution.
Grant an efficient interface and interaction with the rest of Dispatch Center areas, as well as with other EDPR areas and stakeholders which are relevant for the Operational Data Office and Reporting area activities and responsibilities. This role provides the leadership required for the development, engineering, and evolution of EDPR's Operational Data Platform, combining expertise in Data Engineering, cloud technologies, data architecture, automation, and software development to support critical business capabilities. Design, implement, maintain, and optimize data models, tables, views, and data structures within the Databricks environment to support operational and analytical use cases.
Develop, maintain, and enhance ETL/ELT pipelines and data integration processes for incorporating new operational systems, business assets, and external data sources. Develop and maintain technical mechanisms supporting data quality monitoring and validation. Develop, maintain, and optimize code, scripts, stored procedures, notebooks, and automated routines supporting data processing, reporting, and operational workflows.
Design and implement reusable data services, business logic, and automated processes that enable efficient generation of reports, operational views, KPIs, and business insights. Collaborate closely with business stakeholders to understand operational requirements, identify opportunities for automation, and translate business needs into scalable and sustainable data solutions. Work alongside technical teams to ensure seamless integration between operational systems, cloud platforms, and Interstellar DataHub architecture.
Monitor platform performance and proactively identify opportunities to optimize data models, queries, pipelines, workflows, and system resources. Manage the lifecycle of data assets, ensuring version control, traceability,
consistency, security, and compliance with internal data governance standards. Define and maintain technical documentation, data dictionaries, architecture diagrams, operational procedures, and development standards to ensure maintainability and knowledge sharing.
Support incident analysis, troubleshooting, root cause investigation, and implementation of corrective and preventive actions related to data processes and platform operations. Design scalable cloud-native architectures. Maintain CI/CD processes and deployment pipelines.
Ensure platform performance, resiliency and security. Optimize cloud infrastructure utilization and operating costs. Define development standards and coding guidelines. Systems and Stakeholders Knowledge Develop and maintain a comprehensive understanding of the renewable energy operational landscape, market solutions, and emerging technologies relevant to operational data management and reporting.
Continuously evaluate industry trends, commercial platforms, and innovative technologies that could enhance the capabilities, efficiency, and scalability of the Interstellar DataHub Solution. Analyze business opportunities and propose enhancements that improve operational monitoring, reporting capabilities, data accessibility, and overall business value. Act as a technical reference for data management and reporting solutions, ensuring alignment between business needs, technological capabilities, and corporate data strategy.
Gather, analyze, prioritize, and translate business requirements into scalable data solutions, ensuring continuous alignment between operational needs and platform capabilities. Design and develop technical solutions supporting the definition, planning, and implementation of new operational data requirements, reports, dashboards, KPIs, and analytical functionalities. Promote the adoption of standardized data models, reporting practices, and governance principles across business units.
Operational Reporting Organizational Milestones
Support the continuous adoption and effective utilization of the Interstellar DataHub Solution across the organization by providing technical guidance, user support, and knowledge sharing. Develop and maintain training materials, technical documentation, user guides, and best practice recommendations for end users and key stakeholders. Participate in communication, training, and change management initiatives related to new functionalities, reporting capabilities, and platform improvements.
Contribute to cross-functional projects and organizational initiatives where operational data, reporting, and analytics play a strategic role. Foster a culture of continuous improvement by identifying opportunities to simplify processes,
automate repetitive activities, and improve user experience. EDPR Institutional Representation Contribute to the promotion and visibility of the Interstellar DataHub Solution as a strategic operational data platform within EDPR.
Represent the Operational Interstellar DataHub initiatives in internal and external forums, promoting best practices in operational reporting, data management, and digital transformation. Contribute to positioning EDPR as a reference in the use of operational data, analytics, and digital solutions within the renewable energy sector. Full-Time Work site: Hybrid Model City: Porto (Portugal) or Madrid (Spain) What are we looking for: Graduation in Computer Science, Data Engineering, Information Systems or a related field, or another that fits the desired profile.
Ability to read, write and speak English, and Portuguese or Spanish Experience working with Databricks in data engineering, analytics, or business intelligence environments with proficiency in SQL for data extraction, transformation, optimization and analysis and programming experience in Python and/or advanced SQL development. Understanding of data warehousing concepts and cloud-based data architectures. Mandatory experience in Databricks, Python, SQL, data pipelines, automation scripts, notebooks, and data transformation processes and cloud-native data engineering.
Familiarity with Delta Lake and Spark technologies. Proficiency in distributed data processing architectures. Knowledge of metadata management, and master data management principles.
Experience designing, developing, and maintaining ETL/ELT workflows, data integration processes, and orchestration frameworks. Strong understanding of relational and dimensional data modelling, data warehousing concepts, and data lifecycle management.
Experience implementing data quality controls, validation frameworks, monitoring mechanisms, and data governance best practices.
Experience working with source code repositories, version control systems (e.g., Strong knowledge in reporting tools, namely PowerBI or other related data analysis and visualization tools. Proficiency in MS Office tools (Word, advanced Excel, Project, PowerPoint). capability to establish technical discussions in different cultural environments. High degree of ownership, accountability, and commitment to delivering reliable, high-quality data products and services.
Ability to work with transversal teams in OT/IT projects. Equal opportunities for all Our vision is that each person combines their unique characteristics and experiences to fulfill our mission of creating new energy for the planet.
As a top employer we: Empower our employees through a positive and innovative work environment that promotes collaboration and agile decision-making; Top employer certification by Top Employers Institute Part of the Bloomberg Gender-Equality Index Top 100 Workplaces by Houston Chronicle Discover our tips to enhance your performance during the recruitment process and apply until November 7, 2026 if you think you are the right fit for this opportunity.
📌 Operational Data Office Senior Specialist (Madrid)
🏢 EDP
📍 Madrid