Senior Data Architect

Zensar Technologies

Not disclosedBengaluru (On-site)
Posted: 13d agoOpening: 1

Skills Required

Key skills are marked withstar
  • Key skillData Architecture
  • Key skillData Modeling
  • Key skillData Warehousing
  • Data Governance
  • SQL
  • Cloud Data Platforms
  • Snowflake
  • Databricks
  • ETL
  • Master Data Management
  • Data Lakes
  • Lakehouse Architecture
  • Metadata Management
  • Data Security
  • Stakeholder Management

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

Similar Jobs (35149)

Manager, Enterprise Data Management

TriNet

Not disclosedHyderabad

Skills required:

Data Management, Data Quality, Data Governance, Master Data Management, SQL, Excel, Data Cleansing, Data Validation, Data Profiling, Metadata Management, Documentation, Reporting, Attention to Detail

Module Lead - Azure Databricks

YASH Technologies

Not disclosedBengaluru

Skills required:

Technical Leadership, Software Development, Code Review, Module Design, Mentoring, Agile Methodologies, Estimation, Task Allocation, Java, SQL, Unit Testing, Stakeholder Management, Git, Delivery Management

Module Lead - IBM Cognos TM1

YASH Technologies

Not disclosedBengaluru

Skills required:

Technical Leadership, Software Development, Code Review, Module Design, Mentoring, Agile Methodologies, Estimation, Task Allocation, Java, SQL, Unit Testing, Stakeholder Management, Git, Delivery Management

Sr. Data Analyst - Qliksense

YASH Technologies

Not disclosedBengaluru

Skills required:

Data Analysis, SQL, Excel, Python, Power BI, Tableau, Data Visualization, Statistics, Data Cleaning, Dashboards, Reporting, Pandas, Google Sheets, Storytelling with Data, Stakeholder Management

Sr. Data Analyst - MS Excel

YASH Technologies

Not disclosedIndore

Skills required:

Data Analysis, SQL, Excel, Python, Power BI, Tableau, Data Visualization, Statistics, Data Cleaning, Dashboards, Reporting, Pandas, Google Sheets, Storytelling with Data, Stakeholder Management

Sr. Project Manager

YASH Technologies

Not disclosedBengaluru

Skills required:

Project Management, Project Planning, Stakeholder Management, Risk Management, Budget Management, Scheduling, Scope Management, Resource Planning, Agile Methodologies, MS Project, Jira, Status Reporting, Team Leadership, Change Management, Problem Solving

Software Engineer - SnowFlake

YASH Technologies

Not disclosedBengaluru

Skills required:

Programming, Data Structures & Algorithms, System Design, Object-Oriented Programming, Java, Python, JavaScript, SQL, REST APIs, Git, Unit Testing, Cloud Platforms, Docker, CI/CD, Debugging

Consultant - SAP Fiori

YASH Technologies

Not disclosedBengaluru

Skills required:

SAP, SAP S/4HANA, SAP Implementation, Business Process Mapping, Requirements Gathering, SAP Configuration, Fit-Gap Analysis, Functional Specifications, Data Migration, User Acceptance Testing, User Training, SAP Activate, Integration, Stakeholder Management

Consultant - SAP BTP

YASH Technologies

Not disclosedBengaluru

Skills required:

SAP, SAP S/4HANA, SAP Implementation, Business Process Mapping, Requirements Gathering, SAP Configuration, Fit-Gap Analysis, Functional Specifications, Data Migration, User Acceptance Testing, User Training, SAP Activate, Integration, Stakeholder Management

Consultant - SAP BTP

YASH Technologies

Not disclosedBengaluru

Skills required:

SAP, SAP S/4HANA, SAP Implementation, Business Process Mapping, Requirements Gathering, SAP Configuration, Fit-Gap Analysis, Functional Specifications, Data Migration, User Acceptance Testing, User Training, SAP Activate, Integration, Stakeholder Management

View All 35149 Jobs