Senior Data Architect

Zensar Technologies; Bengaluru South; On-site; INR 3,500,000 - 6,500,000; Full time

Job summary

Zensar Technologies is seeking a Senior Data Architect, Finance Data to lead the architecture and design of Finance data platforms and data products at scale, focusing on transactional finance data systems and OLTP data modeling.

Responsibilities include defining robust data models, governance standards, data contracts, and scalable pipelines for financial operations, payments, settlements, ledger reconciliation, and reporting.

Qualifications

• 10+ years of experience in Data Architecture, Data Engineering, or related fields.
• Strong expertise in transactional data modeling and OLTP data architecture.
• Hands-on experience with MySQL and PostgreSQL.
• Experience designing data models for Finance domains and data platforms.
• Strong SQL and query performance optimization knowledge.

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, and reporting inputs.
• Define table grain, primary keys, foreign keys, indexes, constraints, partitioning strategies, retention policies, and historical tracking.
• 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, auditable, 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 monitoring.
• Define data modeling patterns that support financial reporting, business metrics, and audit requirements.

Skills

OLTP data architecture

MySQL

PostgreSQL

Hive

Spark

Data modeling

SQL performance tuning

ETL/ELT architecture

Data governance

Analytics data platforms

Tools

Apache Spark

SQL

Job description

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.

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.

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

About Us

At Zensar, we’re "experience-led everything". We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: "Together, we shape experiences for better futures". Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well‑being is prioritized.

We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.