Architect-Business Analytics

Allianz
Pune
Workplace: OnsiteFull timeFunction: Data Analytics & Business IntelligenceSkills: ["Architectural planning","Stakeholder collaboration","Architecture review","Ethical judgment","Documentation (ADRs)"]

Own end-to-end data architecture for BMP onboarding, aligning with enterprise standards and long-term business goals. Design Snowflake-centric reference architectures across ingestion, transformation, storage, and consumption layers, and create conceptual/logical/physical data models. Build repeatable ELT/ETL frameworks using dbt, apply warehouse patterns like Data Vault 2.0, Kimball dimensional modeling, SCD (Type 1/2), and CDC. Establish data standards, run architecture reviews, and document ADRs while considering data privacy and ethics.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Allianz
Allianz
1 day ago

Architect-Business Analytics

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 19 hours agoStatus: Live

Job Summary

Own end-to-end data architecture for BMP onboarding, aligning with enterprise standards and long-term business goals. Design Snowflake-centric reference architectures across ingestion, transformation, storage, and consumption layers, and create conceptual/logical/physical data models. Build repeatable ELT/ETL frameworks using dbt, apply warehouse patterns like Data Vault 2.0, Kimball dimensional modeling, SCD (Type 1/2), and CDC. Establish data standards, run architecture reviews, and document ADRs while considering data privacy and ethics.
Location: Pune
Workplace: Onsite
Employment Type: Full time · Permanent
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Own and drive the end-to-end data architecture strategy for BMP onboarding, ensuring alignment with enterprise standards and long-term goals.
  • •Navigate, recommend, and implement cloud-based data solutions, leveraging modern transformation tooling such as dbt.
  • •Design and blueprint cloud data platforms (Snowflake-centric), covering ingestion, transformation, storage, and consumption layers.
  • •Develop ELT/ETL frameworks using dbt for transformation orchestration, and define integration patterns for heterogeneous source systems.
  • •Establish architectural principles and standards, conduct architecture reviews for compliance, and develop roadmaps and ADRs; consider data privacy regulations such as GDPR and ethical handling of sensitive data.

Key Requirements

  • •Strong enterprise and solution architecture experience, including Snowflake and dbt knowledge.
  • •Define and own the end-to-end data architecture strategy aligned to enterprise standards, scalability, and business goals.
  • •Design Snowflake-centric cloud data reference architectures covering ingestion, transformation, storage, and consumption.
  • •Develop conceptual, logical, and physical data models and related artefacts to specified standards.
  • •Architect data warehouse solutions using patterns such as Data Vault 2.0, Kimball dimensional modeling, SCD Type 1/2, and CDC.
Skills:Architectural planningStakeholder collaborationArchitecture reviewEthical judgmentDocumentation (ADRs)
Tech Stack:SnowflakeDbtELTETLData Vault 2.0Dimensional modellingKimballSCD Type 1SCD Type 2CDCCloud-native data technologiesADR (Architecture Decision Records)

Company Brief

Allianz
Global insurance and financial services group offering property-casualty insurance, life and health insurance, asset management, and corporate risk solutions to individuals, businesses, and institutions across more than 70 countries.
Industry: Insurance
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Munich, Germany
Founded: 1890
WebsiteLinkedIn