ensuring consistent metric definitions across all consumption channels.
Data Sharing: Implement Fabric Data Sharing using OneLake shortcuts or Delta
Sharing for clients who consume analytics in their own Fabric tenant. Ensure
governed access where clients see only their own data.
Data Quality: Implement data quality checks within the Analytical Warehouse using
Great Expectations or Soda. Validate row counts, null rates, referential integrity, and
freshness against defined data contracts.
Performance Optimization: Tune query performance across Fabric SQL endpoints,
optimize Delta table layouts (Z-ordering, partitioning, file sizing), and manage
compute resource allocation.
CI/CD & DevOps: Implement CI/CD pipelines for Analytical Warehouse artifacts
(transformation models, Fabric notebooks, pipeline definitions) using GitHub
Actions. Follow GitOps practices for deployment.
Requirements
Education: Bachelor's degree in Computer Science, Engineering, Data Science, or a
related technical field.
Experience: 4+ years of hands-on experience in data engineering with a focus on
analytical/warehouse workloads.
Microsoft Fabric / Azure: Demonstrated experience with Microsoft Fabric, Azure
Synapse Analytics, or Azure Data Factory. Familiarity with OneLake, Fabric
notebooks, and Fabric SQL endpoints.
SQL Expertise: Strong SQL skills including complex analytical queries, window
functions, CTEs, and query performance tuning.
Spark / PySpark: Proficiency in PySpark or Spark SQL for large-scale data
transformations.
Data Transformation Frameworks: Experience with SQL-based transformation
frameworks for managing transformation layers - models, tests, documentation,
and incremental materializations.
Delta Lake / Parquet: Understanding of Delta Lake table format - ACID
transactions, time travel, schema evolution, partition management, and file
compaction.
Kafka Fundamentals: Working knowledge of Apache Kafka - consumer concepts,
Kafka Connect, Avro serialization - sufficient to build and troubleshoot the
ingestion layer from ODS Gold topics.
CI/CD: Experience with CI/CD pipelines (GitHub Actions preferred) for data pipeline
deployments.
Experience working in the Wealth Management or Financial Services industry with
understanding of investment data domains (accounts, portfolios, transactions,
positions).
Experience with Apache Iceberg table format for time-travel qu
Additional Information
Job Title: Data Engineer - 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 innovative wealth platforms that empower millions of investors worldwide.
Job Summary:
We are seeking a hands-on Data Engineer to build and maintain the Analytical Warehouse
on Microsoft Fabric. This role focuses on developing data pipelines that ingest enriched
Gold-layer data from the NRT-ODS streaming platform into OneLake, building
transformation layers using SQL-based transformation frameworks or Fabric notebooks,
and delivering analytical datasets to wealth management clients. You will work at the
intersection of the real-time ODS and the analytical lakehouse, enabling historical
analytics, business intelligence, and client-facing reporting.
Fnz · Pune Job Posting Location -, India