Senior Data Architect
Posted Updated
Description
QT-KRS-11-505
Location: Bangalore
Experience: 10+ Years
The project is related to building and managing a Finance Data Platform.
The platform deals with large volumes of financial and transactional data, including payments, settlements, accounting, ledgers and reconciliation.
The main objective is to ensure that financial data coming from different systems is properly structured, stored, processed and maintained accurately.
The role involves designing the database architecture using MySQL and PostgreSQL, along with developing data models and pipelines for reporting and analytics using technologies such as Spark and Hive.
As a Senior Data Architect, you will be responsible for defining the overall data architecture, designing transactional and analytical data models, ensuring data quality and consistency, and providing technical guidance to the engineering team.
We are looking for someone who has strong experience in transactional data architecture, particularly OLTP modelling, financial data systems and large-scale data platforms.
What candidate will be expected to do in this role:
Design how financial transaction data is stored using MySQL and PostgreSQL.
Design data structures for payments, settlements, accounting, ledgers and reconciliation.
Define how data moves from transactional systems into analytical platforms using Spark, Hive and ETL/ELT.
Ensure financial data is accurate, consistent, traceable and available for reporting and audits.
Please note that all the positions are Hybrid (3 days' work from the office).
Kindly ensure the following while working on these requirements:
Submit a minimum of 5 relevant CVs for each position.
Thoroughly screen candidates before submission to ensure they meet the job requirements.
Ensure candidates have excellent communication skills.
Notice Period should be min 15-20 Days only.
Submit only candidates who are genuinely interested and available to attend interviews as per the client's schedule.
Role Summary
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.
Responsibilities
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.
Data Pipeline Architecture
Architect and guide the implementation of ETL/ELT pipelines supporting Finance use
cases.
Design scalable ingestion and processing patterns, including batch, incremental, CDC,
backfill, reconciliation, and recovery workflows.
Ensure reliability, scalability, observability, and maintainability of Finance data pipelines.
Drive architecture decisions for performance optimization, operational resilience, and
cost efficiency.
Define pipeline patterns that preserve transactional accuracy while enabling downstream
analytics and reporting.
Governance, Quality & Controls
Establish data quality, lineage, metadata, ownership, and governance standards for
Finance data.
Define reconciliation frameworks and controls to ensure financial data accuracy,
completeness, and auditability.
Drive best practices for monitoring, validation, anomaly detection, and operational
excellence.
Partner with stakeholders to ensure compliance with financial reporting, audit, and
control requirements.
Technical Leadership
Provide architectural guidance and design reviews across Finance data initiatives.
Mentor engineers and data practitioners on OLTP modeling, Finance data architecture,
and downstream analytical modeling best practices.
Collaborate with Finance, Risk, Engineering, Analytics, and Operations teams to align
business and technical goals.
Influence long-term Finance data platform strategy, architecture standards, and
roadmap.
Required 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.
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.
Preferred Qualifications
Experience with Spark SQL, PySpark, Hive SQL, Airflow, or similar orchestration
frameworks.
Experience designing Finance data architectures in fintech, payments, marketplace,
mobility, or large-scale technology environments.
Exposure to data governance, cataloging, lineage, and observability platforms.
Experience supporting audit, compliance, reconciliation, and financial controls
requirements.
Prior experience working with large-scale transactional Finance systems is a strong plus.
Looking forward to your response.
Skills
Sign in to read and join the discussion.