About this role

General Information 

Description:  The VP, Snowflake Data Architect will design and build BlackRock’s enterprise data warehouse capabilities supporting one or more domains (e.g., HR, Finance, Legal & Compliance).  This role is accountable for defining and implementing scalable, secure and regulatory-compliant Snowflake architectures that enable trusted analytics, operational reporting and strategic decision-making across sensitive and highly governed business functions.

This candidate will serve as the senior data architecture authority for one or more domains, establishing enterprise data models, governance frameworks and engineering standards.  This individual will partner with senior stakeholders across BlackRock businesses and technology to translate complex regulatory and business requirements into sustainable data platform solutions.

The role requires deep expertise in Snowflake architecture, enterprise data modeling and large-scale data transformation programs.

Key Responsibilities

Enterprise Data Architecture & Strategy

• Define and execute the target-state architecture for BlackRock’s business data domains in Snowflake

• Establish enterprise data modeling standards and architectural patterns

• Design scalable, secure and cost-efficient multi-account Snowflake architectures aligned with BlackRock’s enterprise cloud strategy

• Develop data models, conformed dimensions and golden source strategies across regulated domains

• Provide expertise for the development of a multi-year data warehouse transformation roadmap

• Define enterprise architecture patterns for AI-ready data models, ensuring structured and unstructured data are optimized for advanced analytics and generative AI use cases

Snowflake Platform Architecture & Governance

• The role includes overseeing definitions for RBAC models, security, dynamic data masking, and secure data sharing, etc.

• Support BlackRock’s governance frameworks to ensure legal and regulatory compliance, audit traceability, data lineage and retention policies

• Establish cost governance, performance engineering standards and warehouse optimization strategies

• Define and oversee monitoring, observability and data quality control across the platform

• Design and implement Snowflake Cortex capabilities (LLM functions, AI_SQL, document intelligence and vector functions) to enable secure AI-driven analytics within the HR, Finance and Legal and Compliance domains

• Oversee secure data pipelines to support AI/ML workloads, including vector embeddings, semantic search and unstructured data processing within Snowflake

• Ensuring adherence to BlackRock’s governance, access controls and monitoring frameworks for AI-enabled data products

• Integration of Snowflake Native Apps and Snowpark ML capabilities to extend platform intelligence while maintaining enterprise security standards

Data Modeling & Design

• Lead logical and physical data model design for one or more business domains, including HR (workforce planning, compensation, payroll), finance (GL, sub-ledger, cost centers, entity hierarchies) and legal & compliance datasets

• Implement SCD strategies, historical tracking models and audit-compliant lineage frameworks

• Evaluate and apply appropriate modeling paradigms

• Ensure traceability of data transformations to support SOX and regulatory reporting controls

Engineering & Delivery Oversight

• Oversee the design of scalable ingestion and transformation frameworks leveraging ELT tools (e.g., dbt, Fivetran)

• Establish data testing, validation, reconciliation and observability standards

• Guide orchestration strategies (Airflow or equivalent) for reliable and resilient data pipelines

• Drive performance tuning initiatives using Snowflake query profiling, clustering strategies and concurrency scaling design

Stakeholder Leadership & Operating Model

• Serve as the primary technical advisor to business leadership on data strategy

• Lead architecture review boards and set development standards across engineering teams

• Mentor data engineers, fostering technical excellence and architectural consistency

Job Requirements

Experience

• 10+ years of enterprise data architecture and data warehousing experience

• 5+ years designing and leading Snowflake implementations at scale in production environm