Data Architect (OLTP, OLAP, Dimensional, Data Vault)- Banking

Client of YALLO Retail

Key Responsibilities

1. Data Architecture & Design

Develop and maintain enterprise data architecture, including conceptual, logical, and physical data models.
Design data pipelines, data lakes, data warehouses, and integration platforms.
Define standards for master data management (MDM), metadata management, and data quality.
Architect solutions for real-time, batch, and streaming data processing.

2. Cloud & Platform Expertise

Design scalable data solutions on Azure / AWS / GCP.
Build and optimize Data Lakehouse architectures (Databricks, Snowflake, Synapse, BigQuery, Redshift).
Recommend appropriate data storage formats (Parquet, Delta Lake, ORC, etc.).

3. Data Governance & Security

Ensure data security, compliance, and privacy aligned with enterprise and regulatory standards.
Implement RBAC, data lineage, auditability, cataloging, and governance frameworks.
Work with InfoSec to enforce best practices for secure data access and retention.

4. Collaboration & Solution Delivery

Partner with Business, Data Engineers, BI teams, and Application Architects to define data requirements.
Provide architecture reviews, design documents, and implementation guidance.
Support decision-making with data modeling best practices and architecture recommendations.

5. Performance Optimization & Best Practices

Optimize database performance, indexing, query tuning, and ETL processes.
Assess and recommend new tools, frameworks, and technologies.
Ensure high data availability, disaster recovery, and scalability.

Required Skills & Experience

Technical Skills

Strong expertise in data modeling (OLTP, OLAP, Dimensional, Data Vault).
Experience with ETL/ELT tools: ADF, Informatica, Talend, Databricks, DBT.
Knowledge of SQL/NoSQL databases: PostgreSQL, MySQL, MongoDB, Cassandra.
Hands-on with data streaming platforms: Kafka, EventHub, Kinesis.
Experience with API-based data integration, microservices, and event-driven architecture.
Familiarity with AI/ML data preparation, feature stores, and MLOps is a plus.

Experience Required

10 -15+ years in data engineering, database design, or architecture roles.
Proven experience as a Data Architect in enterprise environments.
BFSI domain experience is an added advantage.