Back to jobs

Data Architect

Pay
Pay not listed
Work setting
Not stated
Employment
Permanent · Full-time — employment source
About the Opportunity Job Type: Permanent Application Deadline: 21 November 2026
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design logical and physical data models for CSP data domains

  • Partner with engineers to build pipelines moving data from legacy Oracle to Snowflake

  • Write source-to-target mapping specifications with transformation and cleansing rules

  • Define technical specifications for certified data products and their contracts

  • Maintain data dictionary entries and lineage in Collibra

From the employer’s posting
Design and maintain logical and physical data models for CSP data domains
Partner with delivery engineers to design ingestion and transformation pipelines moving data from legacy Oracle databases (CRDB) to target Snowflake tables
Author comprehensive source-to-target mapping specifications, documenting transformation logic, business rules, and data cleansing requirements
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)

What you’ll bring

All qualifications

Core experience

  • Familiarity with data modeling tools (ERwin, ER/Studio, dbdiagram.io) and version control (Git).
Qualification wording
Familiarity with data modeling tools (ERwin, ER/Studio, dbdiagram.io) and version control (Git).

About Fil

We’re proud to have been helping our clients build better financial futures for over 50 years.

In the employer’s words · Read in context

Apply at Fil

Posting record

Report an error

Actively hiringFirst seen by us 9 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 12, 20269 days ago
Recorded sightings
4
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 9

Similar jobs usually come down between day 6 and day 56.

At Fil, jobs usually come down by about day 15.

From 14,766 similar postings that came down, and 54 of Fil’s. Coming down is not always a hire.

Fil is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is steady
  • Takes jobs down quickly
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Collibra
  • dbt
  • Oracle
  • PostgreSQL
  • Snowflake
  • SQL Server
  • Tableau
Where the posting names them
- 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.
- 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).
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).
- 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.
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.
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.
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.
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.
- 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.
- 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.
- 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
- 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).
- 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

Your next step

Complete your application on fil.wd3.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

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.

 

 

 

 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Gurgaon Office

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.