Director – Data Architecture - Reporting & Analytics

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.