Director, Data Architecture – Reporting & Analytics

Posted: 5 days ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
PostgreSQL
Data Warehousing
Oracle
Performance Tuning
Azure
Snowflake
indexing
Troubleshooting
QUERY OPTIMIZATION
Dimensional Modeling
Semantic modeling
authorization
Power BI
User Provisioning
SQL development
CockroachDB
noSQL Databases
Workspace Management
Enterprise Reporting
Power BI Embedded
Yugabytedb
Role-Based Access Control (RBAC)
Analytics Automation
Dataset Management
Partitioning
Multi-Tenant Architectures
Self-Service Analytics
Tenant Isolation
Enterprise APIs
Technology Evaluations
Proofs of Concept
Row-Level Security (RLS)
Power BI APIs
Angular Applications
Analytical Data Architecture
Object-Level Security (OLS)
Power BI SDKs
Enterprise Authorization Models
Architecture Spikes
Externally Facing Reporting Platforms
Report Embedding

About the job

Fidelity will not provide immigration sponsorship for this position.

Job Description:

The Role

Fidelity Workplace Investing (WI) is seeking an experienced Director, Data Architecture – Reporting and Analytics to support the Stock Plan Services(SPS) product area. This role will focus on architecting scalable, secure, and client-facing reporting solutions for SPS. The ideal candidate brings deep expertise in designing modern digital experience for reporting and insights with a proven ability to evaluate and recommend emerging technologies.

The Expertise and Skills You Bring

  • 10 plus years experience defining target-state reporting and analytics architectures, including semantic layers, data products, governance models, and self-service reporting strategies.
  • Experience modernizing enterprise reporting platforms, including migration from legacy BI technologies such as OBIEE/OAS, WebFOCUS (IBI), Cognos, or Business Objects to Power BI and/or cloud-native analytics platforms.

  • Proven experience designing external-facing reporting and analytics solutions that provide secure client and participant access to operational and analytical data.

  • Hands-on experience implementing Power BI Embedded solutions, Azure-based deployments, multi-tenant architectures, and externally facing reporting platforms serving clients and participants at scale.

  • Hands-on experience integrating applications with Power BI SDKs and APIs for report embedding, workspace management, user provisioning, authorization, dataset management, and analytics automation.

  • Experience designing architecture patterns that abstract Power BI functionality behind enterprise APIs and Angular applications, providing a consistent, secure, and extensible reporting experience independent of the underlying BI platform

  • Strong expertise in designing and implementing Row-Level Security (RLS), Object-Level Security (OLS), Role-Based Access Control (RBAC), tenant isolation, and enterprise authorization models within Power BI.

  • Strong understanding of data warehousing, dimensional modeling, semantic modeling, and analytical data architecture patterns that support enterprise reporting and self-service analytics.

  • Strong hands-on database development experience with one or more of Oracle, Snowflake, PostgreSQL, YugabyteDB, CockroachDB, and NoSQL databases.

  • Expertise in SQL development, dimensional and semantic modeling, query optimization, indexing, partitioning, performance tuning, and troubleshooting.

  • Experience conducting architecture spikes, proofs of concept, and technology evaluations to guide strategic reporting and analytics decisions.

  • Relevant certifications in Power BI, Microsoft Fabric, Azure, AWS, Snowflake, or Tableau are highly desirable.

  • 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

Albeado company logo
Albeado
Breakthrough causal AI predictions, optimizations and interventions - in real time
GVOS  company logo
GVOS
An Edge Cloud for Autonomous Driving
Deepgram company logo
Deepgram
AI speech API for transcription with human-level understanding
Archesys company logo
Archesys
Improving the government services that impact everyday lives
Scale AI company logo
Scale AI
Accelerate the development of AI applications
Traba company logo
Traba
Making the supply chain operate at peak efficiency
Rocket Money company logo
Rocket Money
The Money App That Works for You
Ambient.ai company logo
Ambient.ai
Ambient.ai is a leader in real-time human-level perception technology (Series-A YC/a16z)