Senior Data Architect

Fa Etvl Saasfaprod1; Bengaluru South; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Fa Etvl Saasfaprod1 is seeking a Senior Data Architect, Finance Data to lead architecture of Finance data platforms and data products at scale. You will define transactional data models, governance standards, data contracts, and scalable pipelines supporting payments, settlements, accounting, ledgers, reconciliation, reporting, and analytics.

Collaboration with Finance, Risk, Engineering, Analytics, and Operations is essential.

Qualifications

• 10+ years of experience in Data Architecture, Data Engineering, Data Warehousing, or related fields.
• Strong expertise in transactional data modeling and OLTP data architecture.
• Deep hands-on experience with MySQL and PostgreSQL.
• Knowledge of primary keys, foreign keys, indexing, partitioning, normalization, historical tracking, auditability, and transactional integrity.
• Experience designing data models for Finance domains such as payments, settlements, accounting, ledgers, reconciliation, financial reporting, or financial operations.
• Strong expertise in SQL and query performance optimization.
• Experience designing large-scale ETL/ELT architectures and data platforms.
• Strong understanding of CDC, incremental processing, reconciliation, data quality, and metadata management.
• Hands-on experience with analytical data platforms such as Hive, Spark, Spark SQL, or similar distributed processing technologies.
• Strong understanding of OLAP modeling, including fact tables, dimension tables, aggregates, and reporting datasets.
• Proven ability to drive architecture decisions and work independently as a senior technical leader

Responsibilities

• Define and own the architecture for Finance transactional data platforms and core Finance datasets.
• Design enterprise-grade OLTP data models using MySQL and PostgreSQL.
• Model complex Finance domains such as payments, settlements, accounting, ledgers, reconciliation, financial events, adjustments, and reporting inputs.
• Define table grain, primary keys, foreign keys, indexes, constraints, partitioning strategies, retention policies, and historical tracking approaches.
• Establish standards for normalized data structures, transactional integrity, auditability, idempotency, and data consistency.
• Design data contracts and integration patterns across Finance systems, upstream producers, and downstream consumers.
• Ensure transactional data models are scalable, maintainable, and aligned with financial control requirements.
• Design scalable analytical data models using Hive, Spark, and data warehouse technologies.
• Establish standards for fact, dimension, aggregate, historical, and reporting data structures.
• Translate transactional Finance data into reliable downstream datasets for reporting, reconciliation, analytics, and operational monitoring.
• Define data modeling patterns that support financial reporting, business metrics, audit requirements, and analytical consumption.
• Ensure OLAP models are consistent with source-of-truth transactional systems and Finance data contracts.
• Collaborate with Finance, Risk, Engineering, Analytics, and Operations teams to translate requirements into reliable data solutions.

Skills

OLTP data architecture

Transactional data modeling

MySQL

PostgreSQL

SQL

Data warehousing

Hive

Spark

Spark SQL

Data contracts

CDC

ETL/ELT

Data governance

Education

10+ years experience in Data Architecture

Tools

MySQL

PostgreSQL

Hive

Spark

Spark SQL

Job description

We are seeking a Senior Data Architect, Finance Data to lead the architecture and design of Finance data platforms and data products at scale, with a primary focus on transactional finance data systems and OLTP data modeling. This role will be responsible for defining robust transactional data models, architecture patterns, governance standards, data contracts, and scalable data pipelines that support financial operations, payments, settlements, accounting, ledgers, reconciliation, reporting, and analytics. The ideal candidate brings deep expertise in OLTP-first data architecture, strong hands-on experience with MySQL and PostgreSQL, and the ability to design downstream analytical data models using Hive, Spark, and data warehouse technologies. They will partner closely with Finance, Risk, Engineering, Analytics, and Operations teams to translate business requirements into reliable, maintainable, auditable, and scalable data solutions.

Transactional Data Architecture & Modeling

• Define and own the architecture for Finance transactional data platforms and core Finance datasets.
• Design enterprise-grade OLTP data models using MySQL and PostgreSQL.
• Model complex Finance domains such as payments, settlements, accounting, ledgers, reconciliation, financial events, adjustments, and reporting inputs.
• Define table grain, primary keys, foreign keys, indexes, constraints, partitioning strategies, retention policies, and historical tracking approaches.
• Establish standards for normalized data structures, transactional integrity, auditability, idempotency, and data consistency.
• Design data contracts and integration patterns across Finance systems, upstream producers, and downstream consumers.
• Ensure transactional data models are scalable, maintainable, and aligned with financial control requirements.

Analytical Data Modeling & Reporting

• Design scalable analytical data models using Hive, Spark, and data warehouse technologies.
• Establish standards for fact, dimension, aggregate, historical, and reporting data structures.
• Translate transactional Finance data into reliable downstream datasets for reporting, reconciliation, analytics, and operational monitoring.
• Define data modeling patterns that support financial reporting, business metrics, audit requirements, and analytical consumption.
• Ensure OLAP models are consistent with source-of-truth transactional systems and Finance data contracts.

• 10+ years of experience in Data Architecture, Data Engineering, Data Warehousing, or related fields.
• Strong expertise in transactional data modeling and OLTP data architecture.
• Deep hands-on experience with MySQL and PostgreSQL.
• Strong understanding of primary keys, foreign keys, indexing, partitioning, normalization, historical tracking, auditability, and transactional integrity.
• Experience designing data models for Finance domains such as payments, settlements, accounting, ledgers, reconciliation, financial reporting, or financial operations.
• Strong expertise in SQL and query performance optimization.
• Experience designing large-scale ETL/ELT architectures and data platforms.
• Strong understanding of CDC, incremental processing, reconciliation, data quality, and metadata management.
• Hands-on experience with analytical data platforms such as Hive, Spark, Spark SQL, or similar distributed processing technologies.
• Strong understanding of OLAP modeling, including fact tables, dimension tables, aggregates, and reporting datasets.
• Proven ability to drive architecture decisions and work independently as a senior technical leader