Data Architect

Fidelity International; Gurgaon; Híbrido; INR 1.800.000 - 3.200.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Comprehensive benefits

Flexible working policy

Career development

Descripción de la vacante

Fidelity International seeks a Data Architect to shape CSP data models and Snowflake pipelines in Gurgaon/Bangalore. You will translate business needs into robust schemas, support migration from legacy systems, and define data product interfaces for downstream analysts and dashboards.

Bring 3–6 years in data architecture, strong SQL skills, and hands-on Snowflake experience. The role offers flexible hybrid work within India and a transparent, collaborative environment.

Formación

• Design and maintain logical/physical data models for CSP data domains.
• Experience with Snowflake and data migration from legacy systems.
• Proficient in SQL and data warehousing methodologies.
• Knowledge of Kimball, Inmon, and Data Vault modeling paradigms.
• Ability to author source-to-target mappings and data dictionaries.

Responsabilidades

• Data Modeling & Schema Design for CSP data domains.
• Snowflake migration pipelines from legacy databases.
• Define technical specs for Data Products and API contracts.
• Governance, naming conventions, and data retention compliance.

Conocimientos

Data Modeling

SQL

Snowflake

Data Warehousing

ETL/ELT

Dimensional Modeling

Erwin/ER/Studio

Git

Herramientas

Snowflake

Oracle

PostgreSQL

dbt

ERwin

ER/Studio

dbdiagram.io

Git

Descripción del empleo

Data Architect# Fidelity Careers## Data Architect申请: Gurgaon Office: FIL Bengaluru Office: Full time: 今天发布: 结束日期:2026年11月21日 (申请时间还剩 7 天): J72235# **About the Opportunity**Job Type: PermanentApplication Deadline: 21 November 2026 **Title: Data Architect****Department: Client Service Platform****Location: Gurgaon/Bangalore****Grade: 4****Reports To: Data Architecture Lead**We’re proud to have been helping our clients build better financial futures for over 50 years. We achieve this by working together and supporting one another across our global business. Join our team and be part of something bigger.**Department Description**Platform Design & Solutions (PDS) is the architecture and technical governance body across Client Servicing Platforms (CSP). The Data Architecture and Ownership capability within PDS defines data models, migration architectures, certified data products, and data standards supporting client servicing, reporting, and investment operations globally.**Purpose of the Role** The **Data Architect (Grade 4)** is a foundational data engineering and data modeling specialist responsible for translating business requirements and data domain definitions into physical and logical schema designs, Snowflake data pipelines, and certified Data Product interfaces.Working under the mentorship of the Data Architecture Lead and alongside senior data architects, you will play a crucial role in modernising CSP's data estate — specifically supporting the strategic migration from the legacy on-premise Client Reporting Database onto **Snowflake**.You will map source-to-target data flows, author dimensional and relational data models, maintain technical data dictionaries, and validate data product contracts across client reporting, sales and assets, and distribution datasets.**Key Responsibilities****Data Modeling & Schema Design*** 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 comprehensive source-to-target mapping specifications, documenting transformation logic, business rules, and data cleansing requirements.**Snowflake Data Migration & Pipeline Architecture*** 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.**Data Product Specification & Documentation*** Define technical specifications for certified Data Products: table schemas, JSON/Avro payloads, API contracts, and update cadences.* Document detailed 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.**Governance & Standards Compliance*** Ensure all database designs adhere to Fidelity’s 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. **Experience and Qualifications Required****Knowledge:*** 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.**Skills:*** Advanced SQL proficiency — ability to write 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.**Feel rewarded:**For starters, we’ll offer you a comprehensive benefits package. We’ll value your wellbeing and support your development. And we’ll be as flexible as we can about where and when you work – finding a balance that works for all of us. It’s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.