Hybrid Data Architect & AI Lead - Power BI & Azure AI

Opdenergy; Madrid; Hybrid; EUR 90,000 - 130,000; Full time

Benefits offered by this job

Free health insurance

Free snacks and well-equipped facility

Language and technical training on dem

Job summary

Opdenergy seeks an experienced Data Architect & AI Lead to shape our Data & AI landscape across Madrid or Sevilla. You will design scalable architectures, lead data warehouses, and build end-to-end Power BI solutions while advancing AI capabilities.

You will collaborate with CIO, IT and business teams to translate needs into robust, secure systems and drive automation and governance across production environments.

Qualifications

• 8+ years in Data/BI/Software Engineering or related technical roles.
• Strong hands-on experience with SQL, data modelling, Data Warehousing and ETL/ELT.
• Proven experience developing Power BI solutions end-to-end, including DAX and semantic models.
• Practical experience with Generative AI, RAG, AI agents or similar AI solutions.
• Experience with cloud architectures, APIs and system integrations, preferably within the Microsoft/Azure ecosystem.
• Experience with data quality, monitoring, troubleshooting and technical governance in production environments.
• Experience integrating heterogeneous data sources; knowledge of SAP would be a plus.
• Strong technical communication skills and ability to work with both technical and non-technical stakeholders.
• Fluent English is mandatory.

Responsibilities

• Design and evolve Opdenergy's Data & AI architecture, ensuring scalable, secure and reusable solutions.
• Lead the design and implementation of Data Warehouses, data models, ETL/ELT processes and data integrations.
• Develop and maintain Power BI solutions, including semantic models, DAX, Power Query, dashboards and governed self-service analytics.
• Design and develop AI solutions, including Microsoft Copilot, Copilot Studio, RAG and AI agents using Microsoft Foundry / Azure AI Foundry.
• Integrate data and AI solutions with corporate systems, APIs and business applications, including SAP and other heterogeneous data sources.
• Establish technical standards and best practices across Data, BI and AI, including architecture reviews, documentation, data quality, lineage and observability.
• Troubleshoot complex technical issues and ensure the performance, reliability and maintainability of solutions in production.
• Work closely with the CIO, IT, business teams and Data Owners to translate business needs into scalable technical solutions.
• Coordinate and technically challenge external technology partners when required, ensuring knowledge and critical capabilities remain in-house.
• Drive the evolution of the Data & AI landscape, identifying opportunities for automation, reuse and continuous improvement.

Skills

SQL

Data modelling

Data Warehousing

ETL/ELT

Power BI

DAX

Power Query

Generative AI

RAG

AI agents

Azure / Microsoft

Data governance

Technical communication

English

Tools

SAP

Azure

Power BI

Job description

Opdenergy seeks an experienced Data Architect & AI Lead to shape our Data & AI landscape across Madrid or Sevilla. You will design scalable architectures, lead data warehouses, and build end-to-end Power BI solutions while advancing AI capabilities.

You will collaborate with CIO, IT and business teams to translate needs into robust, secure systems and drive automation and governance across production environments.