130 years of trust, time to shape what's next. Allianz Group is one of the world's leading insurers and asset managers - built on over a century of stability, expertise, and financial strength. Allianz Services is where that legacy meets the future. 8,200+ people. Eight countries. Three continents. We deliver specialized services to clients within Allianz Group, powered by AI, advanced analytics, and a mindset that refuses to stand still. From core insurance operations to engineering and consulting services, we reimagine how insurance works. What truly sets us apart are our people and the trusted partnerships we build, anchored in our values of expertise, integrity, and empowerment. We don't support the business. We shape it.
Role overview
This role is part of the Digital Resilience as a Service framework, collaborating closely with Group Information Security and Allianz Technology to turn security data into reliable risk insight and Group-wide reporting standards. You will work within a modern analytics environment that spans cloud platforms, automated data pipelines, and advanced visualization.
What you do:
- Integrate data from SIEM, EDR, IAM, DLP, vulnerability management, ITSM, cloud, and HR systems to build a single source of truth for security metrics, leveraging Azure Cloud services (Synapse Analytics, Data Factory) and data-lake architectures.
- Design, build, and maintain automated data pipelines (PySpark, Azure Data Factory) for scheduled ingestion, transformation, and KPI/KRI computation (vulnerability remediation SLAs, patch cadence, phishing training outcomes, MTTR, control health, audit readiness, risk heatmaps, vendor risk, policy compliance).
- Build executive and operational Power BI dashboards with clear metric definitions, documentation, and governed datasets; implement scheduled refreshes, Row-Level Security (RLS), and dataset governance.
- Use Power BI (DAX, Power Query) and, where appropriate, Excel (Power Query, Power Pivot) for rapid prototyping, ad hoc modelling, and data validation.
- Work with cloud-based and on-premises data stores (Azure Synapse, SQL databases, MongoDB, or similar) to query, transform, and model security data at scale.
- Conduct ad hoc analysis, root-cause investigations, and trend reporting.
- Establish data dictionaries, lineage documentation, validation checks, and SOPs for data ingestion, transformation, and reporting.
- Maintain controls for data minimization, secure handling, encryption, and least-privilege access.
- Explore and apply Generative AI capabilities to enhance reporting and analytics workflows. For example, automating narrative summaries of dashboards, using NLP to surface patterns in unstructured security data, or building AI-assisted anomaly detection in risk metrics.
- Present findings and recommendations to stakeholders across SecOps, GRC, and IT, adapting the message to technical and non-technical audiences.
What you bring:
Must have
- Bachelor's degree in Computer Science, Data Science, Engineering, Information Security, or related field (or equivalent experience).
- Solid hands-on experience with Power BI (DAX, Power Query) for data modelling and visualization at a professional/advanced level.
- Experience with at least one cloud data platform (Azure Synapse, Azure Data Factory, or similar) and familiarity with data-lake or data-warehouse concepts.
- Working knowledge of a programming or scripting language for data manipulation (Python, PySpark, SQL, or similar).
- Experience working with data governance practices: data dictionaries, validation, documentation.
- Ability to communicate data insights clearly to non-technical stakeholders.
Nice to have
- Prior exposure to security or IT risk data (SIEM, EDR, IAM, DLP, vulnerability management, or similar). No need to have worked with all of them.
- Experience defining or working with security/risk KPIs and KRIs.
- Hands-on experience with NoSQL databases (MongoDB or similar).
- Genuine interest in Generative AI and practical experience or curiosity about applying it to reporting automation, anomaly detection, or natural-language analytics.
- Advanced Excel skills (Power Query, Power Pivot) for rapid prototyping and ad hoc analysis.
- Additional languages beyond English.
What we offer:
- We offer a hybrid work model which recognizes the value of striking a balance between in-person collaboration and remote working incl. up to 25 days per year working from abroad
- We believe in rewarding performance and our compensation and benefits package includes a company bonus scheme, pension, employee shares program and multiple employee discounts (details vary by location)
- From career development and digital learning programs to international career mobility, we offer lifelong learning for our employees worldwide and an environment where innovation, delivery and empowerment are fostered
- Flexible working, health and wellbeing offers (including healthcare and parental leave benefits) support to balance family and career and help our people return from career breaks with experience that nothing else can teach.
Allianz Group is one of the most trusted insurance and asset management companies in the world. Caring for our employees, their ambitions, dreams and challenges is what makes us a unique employer.
We are united by a shared commitment: to put our customers first and at the center of everything we do. Their needs inspire our thinking and guide our actions.
Together, we can build an environment where everyone feels empowered and confident to explore, grow and shape a better future – for our customers and for the world around us. At Allianz, we stand for unity: we believe that a united world is a more prosperous world, and we are dedicated to consistently advocating for equal opportunities for all. The foundation for this is our inclusive workplace, where people and performance both matter, and where integrity, fairness, inclusion and trust are at the heart of our culture.
We therefore welcome applications regardless of ethnicity or cultural Internal background, age, gender, nationality, religion, social class, disability or sexual orientation, or any other characteristics protected under applicable local laws and regulations.
Join us. Let's care for tomorrow.
Data Engineer (m/f/d) Barcelona, B, ES