Data Engineer (m/f/d)

Allianz Services; Barcelona; Hybrid; EUR 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work model

Company bonus scheme

Pension

Employee shares program

International mobility

Job summary

Allianz Services is seeking a data analytics engineer to turn security data into reliable risk insights and standardized reporting. You will work within a modern analytics environment spanning cloud platforms, automated pipelines, and advanced visualization.

The role emphasizes data integration, governance, and AI-assisted reporting. Candidates should have strong Power BI skills, Azure Synapse/Data Factory experience, and fluency in English for global stakeholder communication.

Qualifications

• Bachelor's degree in CS/DS or related field.
• Strong Power BI data modelling and visualization experience.
• Experience with Azure Synapse or comparable cloud analytics platform.
• Proficient in Python, PySpark, or SQL for data manipulation.
• Knowledge of data governance and documentation practices.
• Fluent English; ability to communicate with diverse stakeholders.

Responsibilities

• Ingest and merge data from SIEM, EDR, IAM, DLP and more to create a single source of truth.
• Build automated data pipelines (PySpark, Azure Data Factory) for KPI calculations.
• Develop Power BI dashboards with clear definitions and governance.
• Query and model data in Azure Synapse, SQL and NoSQL stores.
• Perform ad hoc analysis and trend reporting.
• Establish data dictionaries, lineage, and SOPs for data ingestion and reporting.
• Explore Generative AI to enhance reporting and analytics workflows.

Skills

Power BI (DAX)

Azure Synapse/Data Factory

PySpark/Python

SQL/data modelling

Data governance

English proficiency

Education

Bachelor's degree in Computer Science / Data Science / related field

Tools

MongoDB

Excel

Job description

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.
• Proficient English.
• 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.