Data Architect

Overview

Design and maintain data models and Snowflake pipelines for the Client Servicing Platform, supporting the migration from the legacy on-premise Client Reporting Database to Snowflake, as a Grade 4 Data Architect under the Data Architecture Lead.

What you'll do

• Design and maintain logical and physical data models for CSP data domains using ERwin, ER/Studio, or dbt semantic models.
• Develop star-schema, snowflake-schema, and normalized table structures in Snowflake optimized for query performance and data sharing.
• Author source-to-target mapping specifications, documenting transformation logic, business rules, and data cleansing requirements.
• Partner with delivery engineers to design ingestion and transformation pipelines moving data from legacy Oracle databases (CRDB) to target Snowflake tables.
• Write and optimize complex SQL transformations, views, and stored procedures in Snowflake.
• Assist in establishing data reconciliation, automated data validation checks, and regression scripts to guarantee zero data loss during cutover.
• Define technical specifications for certified Data Products: table schemas, JSON/Avro payloads, API contracts, and update cadences.
• Document data dictionary entries, column definitions, and data lineage in enterprise catalogues (Collibra).
• Work with downstream consuming teams (reporting analysts, Salesforce developers, Tableau dashboard creators) to ensure data products meet functional requirements.
• Ensure database designs adhere to enterprise naming conventions, data classifications, and retention policies.
• Assist in classifying sensitive personal data (PII) and configuring masking policies or row-level access controls in Snowflake.

What you'll need

• 3–6 years of experience in Data Modeling, Data Architecture, or Senior Data Engineering in an enterprise data warehouse environment.
• Strong practical working knowledge of Snowflake (virtual warehouses, clustering, staging, zero-copy cloning, time travel).
• Experience working with relational databases (Oracle, PostgreSQL, or SQL Server).
• Solid understanding of data warehousing methodologies (Kimball dimensional modeling, Inmon relational modeling, Data Vault).
• Experience writing source-to-target mappings and participating in large-scale database migrations.
• Advanced SQL proficiency, including performant analytical queries, window functions, and complex joins.
• Familiarity with data modeling tools (ERwin, ER/Studio, dbdiagram.io) and version control (Git).
• High attention to detail, structured thinking, and a passion for data accuracy and documentation.
• Excellent team collaboration skills, eager to learn and grow under senior architectural mentorship.

Details

• Location: Gurgaon or Bangalore.
• Employment type: Permanent.
• Application deadline: 21 November 2026.
• Reports to: Data Architecture Lead.