Job Title: Data Architect — Analytical Warehouse (FNZ)
About FNZ:
FNZ is a global fintech firm transforming the way financial institutions serve their clients. By
combining cutting-edge technology, infrastructure, and investment operations, FNZ
enables wealth management firms to deliver personalized investment solutions at scale.
Operating across multiple regions and supporting over $1.5 trillion in assets under
administration, FNZ partners with leading banks, insurers, and asset managers to create
seamless and cutting-edge wealth platforms that empower millions of investors worldwide.
Job Summary:
We are seeking a senior Data Architect to design and own the architecture of the Analytical
Warehouse built on Microsoft Fabric. This role is responsible for defining the data models,
storage strategies, ingestion patterns, semantic layer, and governance framework that
transform the NRT-ODS Gold-layer streaming data into a structured, performant, and
governed analytical platform. You will architect the bridge between real-time streaming and
historical analytics,
serving both operational BI and client-facing reporting workloads.
Key Responsibilities:
• Analytical Warehouse Architecture: Design the end-to-end architecture for the
Analytical Warehouse on Microsoft Fabric — ingestion from ODS Gold topics,
Bronze/Silver/Gold layering within OneLake, transformation pipelines, semantic
layer, and consumption endpoints.
• Data Modelling: Define dimensional models, star schemas, and wide denormalized
tables optimized for analytical query patterns. Design fact and dimension tables for
wealth management domains — accounts, portfolios, transactions, positions, fees,
NAV, AUM.
• Ingestion Architecture: Architect the Kafka-to-Fabric ingestion pipeline — Kafka
Connect sink configuration, Avro-to-Delta schema mapping, partitioning strategy
(date, entity type, client), exactly-once delivery semantics, and error handling.
• Lakehouse Strategy: Define the OneLake storage architecture includin
📌 Principle Data Architect (Pune)
🏢 FNZ
📍 Pune