Senior Data Architect

Prescienceds; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Competitive salary

Performance-based bonuses

Collaborative and supportive work environment

Chance to learn and grow with a talented team

Job summary

Prescienceds in Bengaluru is seeking a senior Data Architect to drive the architecture of Finance data platforms, ensuring reliable, high-quality financial data through best practices and governance. The role requires 10+ years of experience in Data Architecture, with strong skills in MySQL, PostgreSQL, Hive, and Spark.

The ideal candidate will mentor team members and collaborate across functions to align data strategies with business needs. A competitive salary and performance-based bonuses are offered, alongside a supportive and collaborative work environment.

Qualifications

• 10+ years of experience in Data Architecture, Data Engineering, Data Warehousing, or related fields.
• Strong expertise in both transactional (OLTP) and analytical (OLAP) data modeling.
• Deep hands-on experience with MySQL, PostgreSQL, Hive, and Spark.

Responsibilities

• Define and own the architecture for Finance data platforms and datasets.
• Design enterprise-grade transactional data models using MySQL and PostgreSQL.
• Ensure high-quality, reliable, and auditable financial data through strong governance.

Skills

Data Architecture

Data Engineering

MySQL

PostgreSQL

Hive

Spark

SQL

ETL/ELT architectures

Financial Reporting

Tools

Airflow

Spark SQL

PySpark

Job description

Prescience Decision Solutions | Full time

Prescience Decision Solutions, established in 2017, partners with Fortune 500 and mid-sized companies globally to unlock enterprise data and drive improved decision-making. We specialize in Data Science, Advanced Analytics, and Data Engineering, integrating AI and machine learning to deliver measurable business value and ROI.

Headquartered in Bangalore, our ‘Business Backward’ approach ensures a deep understanding of your challenges, enabling us to provide tailored, impactful solutions.

Founded by industry leaders from IIT and IIM, Prescience is a bootstrapped and profitable company with a strong project pipeline.

Our commitment to excellence has earned us recognition as one of the top three startups in the People Excellence category by xto10x, with a 97 percentile employee NPS, 100% mutual respect among employees, and a 98% employee pride rate.

As an equal opportunity employer, we are dedicated to fostering a diverse and inclusive workplace, free from discrimination based on caste, religion, gender, sexual orientation, nationality, or other protected characteristics.

Role Overview

Own and drive the end-to-end architecture of Finance data platforms, including scalable data models and robust ETL/ELT pipelines. Ensure high-quality, reliable, and auditable financial data through strong governance and engineering best practices. Provide technical leadership and collaborate cross-functionally to align data strategy with business and reporting needs.

Job Description

Responsibilities

Define and own the architecture for Finance data platforms and datasets.

Design enterprise-grade transactional data models using MySQL and PostgreSQL.

Design scalable analytical data models using Hive, Spark, and data warehouse technologies.

Establish standards for fact, dimension, aggregate, historical, and reporting data structures.

Define table grain, primary keys, partitioning strategies, indexing, retention policies, and historical tracking approaches.

Design data contracts and integration patterns across Finance systems and downstream consumers.

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 data pipelines.

Drive architecture decisions for performance optimization and cost efficiency.

Governance & Quality:

Establish data quality, lineage, metadata, ownership, and governance standards.

Define reconciliation frameworks and controls to ensure financial data accuracy and auditability.

Drive best practices for monitoring, validation, and operational excellence.

Partner with stakeholders to ensure compliance with financial reporting requirements.

Technical Leadership:

Provide architectural guidance and design reviews across Finance data initiatives.

Mentor engineers and data practitioners on modeling and architecture best practices.

Collaborate with Finance, Engineering, Analytics, and Operations teams to align business and technical goals.

Influence long-term data platform strategy and roadmap.

Requirements

Required Qualifications:

10+ years of experience in Data Architecture, Data Engineering, Data Warehousing, or related fields.

Strong expertise in both transactional (OLTP) and analytical (OLAP) data modeling.

Deep hands‑on experience with MySQL, PostgreSQL, Hive, and Spark.

Expert‑level SQL skills and strong understanding of distributed data processing.

Experience designing large‑scale ETL/ELT architectures and data platforms.

Strong understanding of CDC, incremental processing, reconciliation, data quality, and metadata management.

Experience working with Finance domains such as payments, settlements, accounting, ledgers, reconciliation, or financial reporting.

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 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, and financial controls requirements.

• Competitive salary and performance-based bonuses.
• Collaborative and supportive work environment
• Chance to learn and grow with a talented team.