Director, Data Architecture - Simulation

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.