Jobs › Companies › Fidelity Canada › Data Architect

Über diese Data Architect Stelle bei Fidelity Canada

Fidelity Canada · Vor Ort · Gurgaon Office

About the Opportunity

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

 

 

 

 

Bereit, sich bei Fidelity Canada zu bewerben?
Bei Fidelity Canada bewerben

Über Fidelity Canada

About Us Fidelity Canada has become an employer of choice for talented people seeking rewarding career opportunities in the financial services industry. We look to hire outstanding individuals who want to maximize their potential and be challenged in all aspects of their professional careers. To help our employees excel in their roles at Fidelity, we provide everyone here with the best training, resources and support possible throughout their careers. With our help, there’s no limit to what you can accomplish here. We’re excited you’re considering Fidelity for your career plans. The Search Jobs section is your online source for job opportunities at Fidelity. Using our site is simple - just t

Alle Jobs bei Fidelity Canada ansehen →

Ähnliche Jobs

Fora Space Limited
Senior Interior Designer / Senior Architect - 12 Month Fixed Term Contract
Fora Space Limited
⚡ Früh bewerben London, England, United Kingdo... Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 28 Min.
Bjak
AI Phone - Hardware Platform / Mobile SoC Architect
Bjak
⚡ Früh bewerben China · standortgebunden
● Neu 👁 Gesehen ✓ Beworben vor 40 Min.
Bjak
AI Phone - Hardware Platform / Mobile SoC Architect
Bjak
⚡ Früh bewerben United States · standortgebunden
● Neu 👁 Gesehen ✓ Beworben vor 40 Min.
Bjak
AI Phone - Hardware Platform / Mobile SoC Architect
Bjak
⚡ Früh bewerben Seoul, Korea Hybrid
● Neu 👁 Gesehen ✓ Beworben vor 40 Min.
Perplexity
Member of Technical Staff (Cybersecurity Solutions Architect)
Perplexity
⚡ Früh bewerben San Francisco Hybrid $250,000–$350,000
● Neu 👁 Gesehen ✓ Beworben vor 1 Std.
Elastic
Consulting Architect (Canberra)
Elastic
⚡ Früh bewerben Australia Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 1 Std.
Tipalti
Product Security Architect
Tipalti
⚡ Früh bewerben Tel Aviv District, Israel Hybrid
● Neu 👁 Gesehen ✓ Beworben vor 2 Std.
EG
Software and Solution Architect
EQT Group
⚡ Früh bewerben Warszawa, Masovian Voivodeship... Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 2 Std.
EG
Software and Solution Architect
EQT Group
⚡ Früh bewerben Stockholm, Stockholm, Sweden Vor Ort
● Neu 👁 Gesehen ✓ Beworben vor 2 Std.

Registrieren für Vorschläge, die auf die von Ihnen geöffneten Jobs und gespeicherten Suchen zugeschnitten sind.

Mehr Jobs bei Fidelity Canada

Alle Jobs bei Fidelity Canada ansehen →

Jetzt bewerben
🤖

Moment — langsam

JobsRadar wurde für echte Menschen gebaut, die eine schwere Zeit bei der Jobsuche haben — nicht für automatisierte Anfragen. Sie klicken viel zu schnell und sind jetzt vorübergehend blockiert.

Kommen Sie später wieder. Wenn Sie wirklich auf Jobsuche sind, stehen wir hinter Ihnen — verhalten Sie sich einfach wie ein Mensch.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Verschaffe dir einen Vorsprung bei der Jobsuche.

Tritt unserem Telegram-Kanal bei für das, was dir hilft, die Stelle zu bekommen — Gehaltsbenchmarks, den wöchentlichen Marktpuls und neue Feature-Drops. Kein Spam, nur Signal.

Dem Kanal beitreten — kostenlos