Director, Data Architecture – Simulation

Fidelity Investments Inc.

Westlake (TX)

On-site

USD 180,000 - 260,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Fidelity Investments is seeking an experienced Data Architect to support Stock Plan Services platform modernization, building a scalable, resilient data platform for advanced simulations. The role emphasizes data architecture, database design patterns, multi-tenancy, DR, and cloud-native modernization across Azure and/or AWS.

You will lead architecture decisions, partner with business, architecture, and technology teams, and apply SQL and Python for data modeling, performance tuning, and

Qualifications

  • 10+ years in data architecture for large-scale platforms.
  • Experience with database scalability, disaster recovery, and cloud-native modernization.
  • Experience leading architecture decisions across business, architecture, and technology groups.
  • Expertise in enterprise-scale data architectures for transactional, analytical, and simulation workloads.
  • Strong knowledge of 3NF, dimensional, canonical and domain-driven data models.
  • Experience with Azure and/or AWS data solutions.
  • Familiar with ETL, CDC, streaming, and real-time data synchronization.
  • SQL and Python programming proficiency.
  • Oracle database expertise including RAC, Data Guard, GoldenGate, and partitioning.

Skills

Data architecture
Database design
SQL
Python
Oracle
Azure
AWS
Data modeling
Partitioning
CDC
ETL
NoSQL
Cross-team leadership

Education

BS/MS in CS/Engineering/IS

Tools

Oracle RAC
Oracle Data Guard
Oracle GoldenGate
PostgreSQL
Snowflake

Job description

Fidelity will not provide immigration sponsorship for this position.

Job Description:

The Role

Fidelity Workplace Investing (WI) is seeking an experienced Data Architect to support the Stock Plan Services(SPS) platform modernization. The ideal candidate will bring deep expertise in data architecture, database technologies and database design to build scalable, resilient data platform for advanced simulation capabilities for SPS.

The Expertise and Skills You Bring

  • 10 plus years of experience architecting, scaling, and modernizing data platforms supporting mission-critical workloads with petabyte-scale data volumes and 24x7 availability requirements.
  • Strong leadership and influencing skills with experience collaborating across business, architecture, and technology organizations.
  • Proven experience leading architecture decisions for database scalability, resiliency, multi-tenancy, disaster recovery, and cloud-native data platform modernization initiatives.
  • Extensive experience designing enterprise-scale data architectures supporting high-volume transactional, operational, analytical, and simulation workloads.
  • Must have expertise in database design patterns for scalability, including horizontal and vertical partitioning, sharding strategies, tenant isolation models, multi-tenancy architectures, workload distribution, and data lifecycle management.
  • Must have experience designing highly available database deployment topologies leveraging cross-availability zone and cross-region replication, failover, disaster recovery, active-active and active-passive architectures, and zero/minimal-downtime maintenance strategies.
  • Good to have experience applying AI and Generative AI technologies to accelerate data modernization and legacy transformation initiatives.
  • Desired knowledge of AI-driven approaches for metadata extraction, schema mapping, lineage analysis, business-rule discovery, and migration validation.
  • Good to have familiarity with vector databases, semantic search, Retrieval-Augmented Generation (RAG), and AI-native data architectures.
  • Desired Oracle database expertise, including Oracle RAC, Data Guard, GoldenGate, Multitenant Architecture, Oracle Partitioning, Performance Tuning, Backup and Recovery, and deployment of highly available and resilient Oracle database platforms.
  • Deep understanding of data modeling, including 3NF, dimensional, canonical, domain-driven, and simulation-oriented data models.
  • Experience designing and implementing enterprise-scale data solutions on Azure and/or AWS.
  • Ability to evaluate, prototype, and adopt emerging data technologies and platforms.
  • Experience with ETL tools, Change Data Capture (CDC), replication, event-driven architectures, streaming technologies, and real-time data synchronization patterns.
  • Strong hands-on database development experience with one of more of Oracle, PostgreSQL, Snowflake, and NoSQL databases.
  • Expertise in SQL development, query optimization, indexing strategies, partitioning, performance tuning, database observability, and troubleshooting.
  • Strong programming skills in SQL and Python.
  • BS or MS in Computer Science, Engineering, Information Systems, or related field.

Fidelity’s Onsite Working Model
Fidelity is transitioning to a full-time onsite working model through a phased rollout across regions and roles. Currently, some roles and locations require 100% onsite presence, while others require less. Onsite expectations are likely to evolve as the rollout continues. This transition does not apply to fully remote roles.

Certifications:
Category:

Information Technology

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Director, Data Architecture - Data Migration
Director, Data Architecture - Data Migration

Fidelity Investments • Westlake (LA)

On-site
USD 140,000 - 190,000
Director, Data Architecture – Reporting & Analytics
Director, Data Architecture – Reporting & Analytics

Fidelity • United States

On-site
USD 150,000 - 230,000
Director, Data Modeling
Director, Data Modeling

Fidelity Investments Inc. • Westlake (TX)

On-site
USD 150,000 - 210,000
Director, Data Engineering
Director, Data Engineering

Fidelity • North Carolina

On-site
USD 150,000 - 190,000
Director, Data Engineering
Director, Data Engineering

Fidelity Investments Inc. • Durham (NC)

On-site
USD 180,000 - 240,000
Principal Data Engineer
Principal Data Engineer

Fidelity • Westlake (TX)

On-site
USD 170,000 - 210,000
Director, Data Modeling
Director, Data Modeling

Fidelity • Westlake (TX)

On-site
USD 170,000 - 230,000
Vice President, Data Architecture
Vice President, Data Architecture

Fidelity Investments Inc. • Durham (NC)

On-site
USD 150,000 - 230,000
Principal Data Modeler
Principal Data Modeler

Fidelity Investments Inc. • Roanoke (TX)

On-site
USD 140,000 - 180,000
Principal Data Engineer
Principal Data Engineer

Fidelity Investments Inc. • Roanoke (TX)

On-site
USD 140,000 - 210,000