This job is with Allianz Commercial, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ business community. Please do not contact the recruiter directly. Senior Data Architect with Snowflake & dbt knowledge who can help them with architecture for BMP onboarding and steer local team towards agreed architecture. Proven skills in enterprise & solution architecture. Define and own the end-to-end data architecture strategy, ensuring alignment with enterprise standards, scalability requirements, and long-term business goals. Navigates, recommends, and implements cloud-based data solutions and can work on contemporary tools like DBT for data transformation. Design reference architectures and solution blueprints for cloud-based data platforms (Snowflake-centric), covering ingestion, transformation, storage, and consumption layers. Develop Conceptual, Logical and Physical Data Models and related artefacts to specified standards. Architect data warehouse solutions applying industry patterns - including Data Vault 2.0, dimensional modelling (Kimball),



historization (SCD Type 1/2), persistent staging areas, and change data capture (CDC). Design repeatable, industrialized ELT/ETL frameworks leveraging dbt for transformation orchestration; define integration patterns for ingesting data from heterogeneous source systems. Establish architectural principles, design patterns, naming conventions, and data standards; conduct architecture reviews and ensure compliance across delivery teams. Assess, recommend, and roadmap cloud-native data technologies and tooling; drive architectural decisions with documented ADRs (Architecture Decision Records). Evaluates the business units for existing inefficiencies and bottlenecks and to develop and maintain protocols for handling, processing, and cleaning data. Understanding of data privacy regulations (such as GDPR) and ethical considerations in handling sensitive customer data and their historization. Ability to w

📌 Architect-Business Analytics (Pune)
🏢 Allianz Commercial
📍 Pune