Senior Data Architect

Prescience Decision Solutions; Bengaluru; On-site; INR 3,000,000 - 4,800,000; Full time

Benefits offered by this job

Competitive salary

Performance bonuses

Learning & growth

Job summary

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

Own and drive the end-to-end architecture of Finance data platforms, including scalable data models and robust ETL/ELT pipelines.

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.

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.
• 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.
• 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.

Skills

Data Architecture

Data Modeling

MySQL

PostgreSQL

Hive

Spark

ETL/ELT

Data Governance

SQL

Financial data

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.

To learn more, subscribe to our YouTube channel: YouTube Link .

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.
• Strongexpertisein 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.