Data Architect

Posted 5 Days Ago
Be an Early Applicant
Hiring Remotely in Office, Machaze, Manica, MOZ
Remote
Mid level
Software • Financial Services
The Role
Designs logical and physical data models, Snowflake schemas, migration architectures, and certified data product interfaces. Develops SQL transformations, source-to-target mappings, data pipelines, reconciliation checks, and validation scripts for migrating Oracle data to Snowflake. Maintains data dictionaries, lineage, API and payload specifications, and governance standards while supporting PII classification, masking, and access controls. Collaborates with engineers, reporting analysts, Salesforce developers, and Tableau users under the guidance of senior data architects.
Summary Generated by Built In
About the OpportunityJob Type: Permanent

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


 

 

 

Skills Required

  • 3-6 years of experience in data modeling, data architecture, or senior data engineering in an enterprise data warehouse environment
  • Practical working knowledge of Snowflake, including virtual warehouses, clustering, staging, zero-copy cloning, and time travel
  • Experience with relational databases such as Oracle, PostgreSQL, or SQL Server
  • Understanding of Kimball dimensional modeling, Inmon relational modeling, and Data Vault
  • Experience writing source-to-target mappings and participating in large-scale database migrations
  • Advanced SQL proficiency, including analytical queries, window functions, and complex joins
  • Familiarity with data modeling tools such as ERwin, ER/Studio, or dbdiagram.io
  • Familiarity with Git version control
  • Strong attention to detail, structured thinking, data accuracy, and documentation skills
  • Excellent team collaboration skills and willingness to learn under senior architectural mentorship

Fidelity International Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Fidelity International and has not been reviewed or approved by Fidelity International.

  • Parental & Family Support — Equalised paid parental leave and five paid days for caring responsibilities are explicitly provided. Feedback suggests these policies are a notable strength for employees with family needs.
  • Wellbeing & Lifestyle Benefits — Mental-health support, an Employee Assistance Programme, and trained Mental Health First Aiders are part of the offering. Broader physical, mental, and financial-wellbeing resources are highlighted alongside healthcare support.
  • Flexible Benefits — Many roles follow a hybrid model that allows working from home with minimum office attendance. Feedback suggests this flexibility supports work-life balance in practice.

Fidelity International Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
9,919 Employees
Year Founded: 1969

What We Do

Fidelity International offers investment solutions and services and retirement expertise to more than 2.5 million customers globally. As a privately held, purpose-driven company with a 50-year heritage, we think generationally and invest for the long term. Operating in more than 25 countries and with $739.9 billion* in total assets, our clients range from central banks, sovereign wealth funds, large corporates, financial institutions, insurers and wealth managers, to private individuals. Our Workplace & Personal Financial Health business provides individuals, advisers and employers with access to world-class investment choices, third-party solutions, administration services and pension guidance. Together with our Investment Solutions & Services business, we invest $567 billion on behalf of our clients. By combining our asset management expertise with our solutions for workplace and personal investing, we work together to build better financial futures. *Data as of 31 March 2021

Similar Jobs

VicRoads Logo VicRoads

Data Architect

Transportation • Travel
Remote
Office, Machaze, Manica, MOZ
1578 Employees
180K-180K Annually

Novartis Logo Novartis

Architect

Biotech • Pharmaceutical
Remote or Hybrid
Office, Machaze, Manica, MOZ
110000 Employees

Novartis Logo Novartis

Architect

Biotech • Pharmaceutical
Remote or Hybrid
Office, Machaze, Manica, MOZ
110000 Employees

Novartis Logo Novartis

Architect

Biotech • Pharmaceutical
Remote or Hybrid
Office, Machaze, Manica, MOZ
110000 Employees

Similar Companies Hiring

Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account