Vice President, Senior Data Architect

About the Role

The Data Architect will lead the design and build-out of the firm’s enterprise data architecture, with a focus on creating a trusted single source of truth for an asset management organization. This role will partner with business, technology, operations, investment, compliance, and reporting stakeholders to define data standards, integrate enterprise data sources, and deliver scalable analytics and reporting capabilities.

Microsoft Fabric, Snowflake, and Power BI are required. The ideal candidate has hands-on experience designing modern data warehouse/lakehouse solutions using Microsoft Fabric and Snowflake, building governed semantic models, and implementing data governance, cataloging, lineage, and data quality practices using Microsoft Purview, Atlan, or comparable data governance tools.

Key Responsibilities

• Define and implement the enterprise data architecture and roadmap for a modern Microsoft data platform, aligned to the firm’s business strategy and asset management data needs.
• Design and build a single source of truth across critical domains such as security master, funds, portfolios, holdings, transactions, performance, clients, reference data, and reporting data sets.
• Architect Microsoft Fabric solutions, including OneLake, Lakehouse, Warehouse, Data Factory pipelines, notebooks/data engineering workloads, semantic models, and Power BI reporting layers; design and integrate Snowflake data warehouse capabilities where used by the firm.
• Lead data modeling efforts across conceptual, logical, and physical models, including dimensional, normalized, and semantic models for analytics and reporting.
• Design scalable ingestion, transformation, validation, and orchestration patterns for internal and external data sources, including APIs, files, databases, vendor feeds, operational systems, Microsoft Fabric, and Snowflake.
• Establish and enforce data governance standards, including data ownership, stewardship, metadata, lineage, definitions, classification, access controls, retention, and usage standards.
• Implement data quality frameworks, profiling, validation rules, monitoring, exception management, and remediation workflows to improve trust in enterprise reporting and analytics.
• Evaluate, implement, and administer data governance and cataloging tools such as Microsoft Purview, Atlan, or similar platforms.
• Partner with business teams to define KPIs, reporting requirements, data definitions, and reusable Power BI semantic models that support consistent reporting across the firm.
• Collaborate with application, infrastructure, cybersecurity, and business teams to ensure the data platform is secure, resilient, performant, compliant, and supportable.
• Document data architecture, data flows, lineage, data dictionaries, standards, integration patterns, and operational procedures.
• Assess current-state data platforms, databases, reports, and data processes; recommend improvements, migration paths, and modernization opportunities.

Qualifications

Required:

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Engineering, or a related field; Master’s degree preferred.
• At least 10 years of experience in data architecture, data engineering, business intelligence, or enterprise data platform delivery.
• 5+ years of experience in financial services; asset management, investment management, wealth management, or capital markets experience strongly preferred.
• Hands-on experience with Microsoft Fabric, including Lakehouse/Warehouse architecture, OneLake, pipelines, data engineering, and integration patterns.
• Hands-on Snowflake experience, including warehouse design, schemas, secure data sharing, ingestion/ELT, performance optimization, and integration with Microsoft Fabric and Power BI.
• Strong Power BI experience, including semantic models, DAX, dataflows, governance, deployment practices, and enterprise reporting standards.
• Strong SQL skills and experience with SQL Server or Azure SQL; ability to write, op