Prescience Decision Solutions - Senior Data Architect

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

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.

Benefits:

- Competitive salary and performance-based bonuses.

- Comprehensive insurance plans.

- Collaborative and supportive work environment.

- Chance to learn and grow with a talented team.

- A positive and fun work environment.