Senior Data Architect (Bengaluru)

Senior Data Architect (Bengaluru)

17 Nov
|
Zensar Technologies
|
Bengaluru

17 Nov

Zensar Technologies

Bengaluru

Senior Data Architect – Finance Data

Job Summary

We are seeking a Senior Data Architect to lead the architecture and design of scalable Finance data platforms and data products, with a primary focus on transactional data systems and OLTP data modelling. The role involves designing robust transactional data models, architecture patterns, governance standards, data contracts, and scalable data pipelines to support financial operations, payments, settlements, accounting, ledgers, reconciliation, reporting, and analytics.

The ideal candidate will have strong hands-on expertise in MySQL and PostgreSQL, deep knowledge of OLTP architecture, and experience designing downstream analytical data models using Hive, Spark, and data warehouse technologies.

Key Responsibilities

Transactional Data Architecture & Modelling

- Define and own the architecture of Finance transactional data platforms and core Finance datasets.
- Design enterprise-grade OLTP data models using MySQL and PostgreSQL.
- Model complex Finance domains, including payments, settlements, accounting, ledgers, reconciliation, financial events, and adjustments.
- Define table structures, primary and foreign keys, indexes, constraints, partitioning strategies, retention policies, and historical tracking approaches.
- Establish standards for data normalization, transactional integrity, auditability, idempotency, and data consistency.
- Define 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 Modelling & Reporting

- Design scalable analytical data models using Hive, Spark,



and data warehouse technologies.
- Establish standards for fact tables, dimension tables, aggregates, historical data, and reporting structures.
- Transform transactional Finance data into reliable datasets for reporting, reconciliation, analytics, and operational monitoring.
- Define data modelling patterns that support financial reporting, business metrics, audit requirements, and analytical consumption.
- Ensure OLAP models remain consistent with source-of-truth transactional systems and Finance data contracts.

Required Skills & Qualifications

- 10 years of experience in Data Architecture, Data Engineering, Data Warehousing, or related fields.
- Strong expertise in transactional data modelling and OLTP data architecture.
- Hands-on experience with MySQL and PostgreSQL.
- Strong understanding of database design concepts, including 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 SQL skills and query performance optimization experience.
- Experience designing large-scale ETL/ELT architectures and data platforms.
- Understanding of CDC, incremental processing, reconciliation, data quality, and metadata management.
- Hands-on experience with Hive, Spark, Spark SQL, or similar distributed data processing technologies.
- Solid understanding of OLAP modelling, including fact tables, dimension tables, aggregates, and reporting datasets.
- Ability to independently drive architecture decisions and provide senior technical leadership.

📌 Senior Data Architect (Bengaluru)
🏢 Zensar Technologies
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior data architect (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: senior data architect (bengaluru) / bengaluru