Bangalore North, Karnataka, India · On-site
Responsibilities Data Architecture & Modeling : Define and own the architecture for Finance data platforms and datasets. Design enterprise-grade transactional data models using MySQL and PostgreSQL. Design scalable analy…
Skills: Data Architecture, Data Modeling, MySQL, PostgreSQL, Hive
Bangalore North, Karnataka, India · Hybrid
Location: Bangalore (Hybrid) Preference: Immediate Joiners / Serving Notice Period Key Responsibilities: Write and optimize complex SQL queries for large datasets Perform deep-dive analysis on customer behavior, campaign…
Skills: Sql, Python, Excel, Power BI, Customer Analytics
Bangalore North, Karnataka, India · Remote OK
Key Responsibilities: Solution Architecture & Deployment: Design and deploy secure, scalable GenAI architectures integrated into applications Build and deploy REST APIs for AI/ML models Work with Docker, Kubernetes in cl…
Skills: Python, SQL, LangChain, LLMs, RAG
Bangalore North, Karnataka, India · Hybrid
Location: Bangalore (Hybrid) Experience: 5+ Years Key Responsibilities: Act as the primary POC for Salesforce-related business issues Troubleshoot across opportunity management, account hierarchies, CPQ, CLM, pricing, an…
Skills: Salesforce CRM, CPQ, CLM, Opportunity Management, Account Hierarchy
Bangalore North, Karnataka, India • On-site
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Define and own the architecture for Finance data platforms, focusing on transactional and analytical data models. Lead the design of scalable ETL/ELT pipelines and establish governance standards for data quality and auditability.
Requires over 10 years of experience in data architecture and engineering with deep expertise in OLTP and OLAP modeling. Candidates must have hands-on experience with MySQL, PostgreSQL, Hive, and Spark, specifically within finance domains.
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.
Data Pipeline Architecture :
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.
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.
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.
Foresight for Business
Prescience is a Data and AI company focused on helping businesses unlock the power of Enterprise data. Founded in 2017, Prescience offers comprehensive data solutions and services that integrate AI and machine learning across analytics, business intelligence, data engineering, and more—driving measurable business value and ROI for its customers.
Offices: ClayWorks Create, Arekere, Bannerghata Road, Bengaluru, Karnataka 560076, IN
Foresight for Business
Prescience is a Data and AI company focused on helping businesses unlock the power of Enterprise data. Founded in 2017, Prescience offers comprehensive data solutions and services that integrate AI and machine learning across analytics, business intelligence, data engineering, and more—driving measurable business value and ROI for its customers.
Offices: ClayWorks Create, Arekere, Bannerghata Road, Bengaluru, Karnataka 560076, IN
