Search by job, company or skills

Senior Data Architect

Senior Data Architect

Zensar Technologies Limited
10-15 Years
Not Disclosed
Early Applicant
Quick Apply
  • Posted 13 hours ago
  • Be among the first 10 applicants

Job Description

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.
  • Strong understanding of OLAP modelling, including fact tables, dimension tables, aggregates, and reporting datasets.
  • Ability to independently drive architecture decisions and provide senior technical leadership.

More Info

Job Type:
Function:
Employment Type:

Key Skills

OLTP Data Architecture

Finance Data Modelling

Apache Spark and Hive

Similar Jobs

15-17 yrs
Bengaluru, India
Skills:
Amazon Web Services (AWS), Data Lineage, Data Modelling, Pyspark, Apache Spark, Sql, ELT, Databricks, Microsoft Azure, Data Governance, Python, Etl, Reporting Analytics, Data Architecture Solution Design, Data Lakehouse Architecture, Data Pipeline Design Development
10-12 yrs
Bengaluru, India
Skills:
Hive, MySQL, PostgreSQL, Spark, Data Warehousing, Sql, Etl, ELT, Data Quality, Metadata Management, OLAP modeling, cdc, OLTP data modeling, incremental processing
12-14 yrs
Bengaluru, India
Skills:
snowflake , S3, Sql, Azure Data Factory, Gcp, Spark, Databricks, Python, AWS, Airflow, ADLS, dbt, Delta Lake
12-14 yrs
Bengaluru, India
Skills:
Sql, Databricks, Pig, Pl Sql, Impala, RDBMS, Kinesis, Hadoop, Pyspark, AWS, Etl, Cassandra, Hive, Unix Shell Scripting, Python, Azure, Neo4j, Terraform, Apache Kafka, Git, MongoDB, Spark, CircleCI
8-10 yrs
Bengaluru, India
Skills:
Azure Functions, SQL Server, Microsoft Azure, Azure DevOps, identity management via Microsoft Entra ID, GitHub Actions, T-SQL performance tuning, AlwaysOn Availability Groups, Service Bus, Azure App Services