Architect- Business Intelligence

Allianz Services; Pune District; On-site; INR 4,000,000 - 7,000,000; Full time

Job summary

Allianz Services is seeking an experienced Data Platform Solution Architect to transform and guide a multi‑layer Azure data platform. You will assimilate a complex platform, craft target architectures, and lead the team through the next stage of platform evolution.

You will collaborate with senior engineers and stakeholders, defining roadmaps, governance, and best practices for scalable data ingestion, processing, and consumption in a regulated enterprise environment.

Qualifications

• Proven experience designing enterprise‑scale data platform architectures end‑to‑end.
• Deep knowledge of medallion / lakehouse patterns (Raw/ Harmonized/ Conformed/ Consumption).
• Strong data modeling skills across relational, dimensional and lakehouse contexts.
• Experience designing data governance architectures including lineage and SCD/versioning.
• Ability to design for batch and real‑time processing at scale.
• Experience with migration strategies across platforms and phased approaches.
• Hands‑on Azure Data Platform skills including Synapse, Data Lake Gen2, Databricks.
• Proficient in Python and SQL; capable of code review and guidance.

Responsibilities

• Assess current platform state and understand landscape with the engineering team.
• Define target‑state architecture and roadmap for platform transformation.
• Translate data needs into architectural decisions and designs.
• Provide hands‑on architectural guidance during delivery.
• Identify risks, dependencies, and mitigation strategies.
• Define integration patterns and governance across data layers.
• Drive platform tooling and infrastructure choices in line with cloud standards.

Skills

Enterprise data platform architecture

Medallion / lakehouse patterns

Data modeling (relational, dimensional

Data governance architectures

Batch and real‑time processing

Migration strategies across platforms

Azure Data Platform (Azure Synapse,Dat

Python & SQL skills

Tools

Azure Synapse Analytics

Azure Data Lake Storage Gen2

Delta Lake on Azure

Azure Databricks

Unity Catalog

Purview

Terraform

Docker

Kubernetes

Power BI

Job description

Job Description – Data Platform Solution Architect (Azure Synapse & Databricks)

Role Overview

We are looking for an experienced Data Platform Solution Architect to join an existing enterprise data platform team. The role requires the ability to rapidly assimilate a complex, partially implemented platform — understanding what has been built, what remains, and what needs to evolve — and to translate that into a clear, actionable architecture that guides the team through current delivery and the next stage of platform transformation. This person will work closely with senior engineers and stakeholders, providing the architectural vision and technical direction needed to complete ongoing work and design the path forward.

Key Responsibilities

• Rapidly assess and develop a deep understanding of the current platform state across all layers and components, working alongside the existing engineering team
• Define and own the target-state architecture, bridging the gap between what is currently implemented and what needs to be completed or evolved
• Design the architectural roadmap for the next stage of platform transformation, ensuring continuity with current investments while enabling future scalability
• Translate business and data requirements into architectural decisions, reference designs, and technical standards
• Provide hands‑on architectural guidance to engineering teams on a day‑to‑day basis — not limited to design documents but actively engaged in delivery
• Identify architectural risks, dependencies, and trade‑offs across the platform and recommend mitigation strategies
• Define integration patterns, data flow designs, and governance standards across source ingestion, transformation, and consumption layers
• Establish and enforce architecture principles, design patterns, and platform standards across the team
• Collaborate with data governance, business, and technology stakeholders to align platform direction with enterprise requirements
• Support migration planning by defining target architectures, transition states, and validation strategies for workload migrations across platforms
• Drive decisions on platform tooling, infrastructure, and service selection in alignment with cloud and enterprise architecture standards

Core Technical Skills

Architecture & Design

• Proven experience designing enterprise‑scale data platform architectures end‑to‑end — from source ingestion through to consumption
• Deep understanding of medallion / lakehouse architecture patterns (Raw / Harmonized / Conformed / Consumption)
• Strong knowledge of data modelling approaches: relational, dimensional, and lakehouse‑oriented
• Experience designing data governance architectures: lineage, data quality frameworks, audit and control patterns, SCD versioning, CDC
• Ability to design for both batch and real‑time data processing at scale
• Experience architecting parallel‑run and phased migration strategies across platforms
• Azure Data Platform Strong hands‑on knowledge of:
• Azure Synapse Analytics (Pipelines, Spark Pool, Dedicated SQL Pool)
• Azure Data Lake Storage Gen2
• Delta Lake on Azure (Synapse Lakehouse)
• Azure Analysis Services
• Oracle Golden Gate or equivalent real‑time replication patterns
• Power BI and semantic layer design
• Databricks & Lakehouse
• Hands‑on experience with Azure Databricks (Delta Live Tables, Unity Catalog preferred)
• Strong understanding of Databricks platform capabilities: Delta Lake, Spark‑based transformation, workflow orchestration, governance
• Experience designing migration architectures from legacy data warehouse or Synapse environments to Databricks Lakehouse
• Ability to architect governance and control frameworks natively within Databricks

Cloud & Infrastructure

• Strong Azure cloud architecture skills — security, networking, scalability, and cost optimization
• Experience with Infrastructure as Code (Terraform preferred)
• CI/CD and DevOps practices for data platform delivery (Azure DevOps / GitHub Actions)
• Containerisation and compute management (Docker, Kubernetes awareness)
• Data Engineering Depth
• Sufficient hands‑on engineering background to engage credibly with senior engineers on implementation decisions
• Strong Python and SQL skills — able to review, challenge, and contribute to code where necessary
• Experience with ETL/ELT frameworks, pipeline design patterns, and performance optimisation at scale

Nice to Have

• Experience with Unity Catalog and Azure Purview for enterprise data governance
• Exposure to real‑time and streaming architectures (Event Hub / Kafka / Kinesis)
• Familiarity with MLOps and GenAI platform integration patterns
• Experience with monitoring and observability frameworks (e.g., Dynatrace)
• Background in financial services or other regulated industries

Experience & Profile

• 12+ years of experience in Data Engineering and/or Data Architecture, with at least 4–5 years in a solution or platform architect role
• Proven experience joining mid‑flight programmes — able to quickly understand existing implementations and make sound architectural decisions without starting from a blank slate
• Track record of delivering architecture across complex, multi‑layer data platforms in enterprise environments
• Strong ability to balance pragmatism with rigour — delivering architecture that works for the team today while keeping the longer‑term direction sound
• Excellent communication and stakeholder management skills — able to present technical architecture clearly to both engineering teams and non‑technical stakeholders
• Collaborative by nature — this is a working architect role embedded with the team, not a remote advisory position
• Experience working in regulated or enterprise‑scale environments (financial services a plus)

100924 | Data & AI | Professional | Non‑Executive | Allianz Services | Full‑Time | Permanent

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. Together we can build an environment where everyone feels empowered and has the confidence to explore, to grow and to shape a better future for our customers and 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. And the foundation for this is our inclusive workplace, where people and performance both matter, and nurtures a culture grounded in integrity, fairness, inclusion and trust.

We therefore welcome applications regardless of ethnicity or cultural 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.