Director, Data Architecture – Simulation

Posted: 4 days ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
PostgreSQL
Azure
Snowflake
AWS
Etl Tools
noSQL Databases
Change Data Capture (CDC)

About the job

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.

Similar Jobs

Enigma Technologies company logo
Enigma Technologies
Authoritative answers for your agents and workflows
Forus company logo
Forus
Accelerate the future of medicine
Clipboard company logo
Clipboard
Flexibility and high pay for professionals. Top talent and fast fill for workplaces
Blue Ink Digital company logo
Blue Ink Digital
Automated Marketplace for real-time exclusive leads
AARATECH company logo
AARATECH
AaraTech Inc. empowers businesses by providing innovative and tailored IT solutions and services
EquityZen company logo
EquityZen
Private Markets for the Public // Pre-IPO Stock Marketplace
Iterative Health company logo
Iterative Health
Pioneering the use of artificial intelligence-based solutions for gastroenterology