Data Architect, Snowflake, Vice President
Job DescriptionAbout this roleGeneral 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 ResponsibilitiesEnterprise Data Architecture & StrategyDefine and execute the target-state architecture for BlackRock’s business data domains in SnowflakeEstablish enterprise data modeling standards and architectural patternsDesign scalable, secure and cost-efficient multi-account Snowflake architectures aligned with BlackRock’s enterprise cloud strategyDevelop data models, conformed dimensions and golden source strategies across regulated domainsProvide expertise for the development of a multi-year data warehouse transformation roadmapDefine enterprise architecture patterns for AI-ready data models, ensuring structured and unstructured data are optimized for advanced analytics and generative AI use casesSnowflake Platform Architecture & GovernanceThe 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 policiesEstablish cost governance, performance engineering standards and warehouse optimization strategiesDefine and oversee monitoring, observability and data quality control across the platformDesign 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 domainsOversee secure data pipelines to support AI/ML workloads, including vector embeddings, semantic search and unstructured data processing within SnowflakeEnsuring adherence to BlackRock’s governance, access controls and monitoring frameworks for AI-enabled data productsIntegration of Snowflake Native Apps and Snowpark ML capabilities to extend platform intelligence while maintaining enterprise security standardsData Modeling & DesignLead 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 datasetsImplement SCD strategies, historical tracking models and audit-compliant lineage frameworksEvaluate and apply appropriate modeling paradigmsEnsure traceability of data transformations to support SOX and regulatory reporting controlsEngineering & Delivery OversightOversee the design of scalable ingestion and transformation frameworks leveraging ELT tools (e.g., dbt, Fivetran)Establish data testing, validation, reconciliation and observability standardsGuide orchestration strategies (Airflow or equivalent) for reliable and resilient data pipelinesDrive performance tuning initiatives using Snowflake query profiling, clustering strategies and concurrency scaling designStakeholder Leadership & Operating ModelServe as the primary technical advisor to business leadership on data strategyLead architecture review boards and set development standards across engineering teamsMentor data engineers, fostering technical excellence and architectural consistencyExperienceJob Requirements10+ years of enterprise data architecture and data warehousing experience5+ years designing and leading Snowflake implementations at scale in production environmentsDemonstrated experience designing and delivering enterprise-wide data warehouse solutionsProven leadership of large-scale data transformation initiatives within regulated financial services environmentsExperience designing governance, security, and compliance frameworks in cloud-based data platformsSkillsTechnical ExpertiseDeep expertise in Snowflake architecture, including storage/compute separation, micro-partitioning, clustering, performance tuning and cost optimizationAdvanced knowledge of dimensional modeling and enterprise data architecture patternsStrong command of SQL and data transformation engineering best practicesExperience implementing CI/CD pipelines, Infrastructure-as-Code, and DevOps frameworks for data platformsProficiency with modern ELT/ETL tools (dbt / Fivetran preferred), orchestration frameworks and data quality toolingStrong understanding of cloud ecosystems (AWS, Azure or GCP) and enterprise data integration patternsExperience implementing Snowflake Cortex Snowpark (Python), and AI_SQL capabilities in production environmentsStrong understanding of vector databases, embeddings, semantic search and retrieval-augmented generation (RAG) patternsFamiliarity with responsible AI frameworks, model governance and secure deployment of LLM-powered enterprise solutionsExperience enabling AI/ML workloads directly within Snowflake’s native ecosystemGovernance & RegulatoryExpertise in data classification, PII handling, row-level security and dynamic masking policiesFamiliarity with SOX controls, audit frameworks, data retention policies and regulatory reporting requirementsExperience designing end-to-end lineage and traceability frameworksLeadership & Strategic CapabilitiesAbility to define enterprise data strategy and influence senior stakeholdersStrong executive communication skills, including the ability to present architectural strategy to leadershipExperience leading architecture governance forums and cross-functional engineering teamsDemonstrated ability to align technical platforms with long-term business objectivesEducationBachelor’s degree in computer science, engineering, information systems or related quantitative discipline requiredAdvanced degree (Master’s or MBA) preferredSnowPro Advanced Certification is preferredFor New York, NY Only the salary range for this position is USD$155,000.00 - USD$210,000.00 . Additionally, employees are eligible for an annual discretionary bonus, and benefits including healthcare, leave benefits, and retirement benefits. BlackRock operates a pay-for-performance compensation philosophy and your total compensation may vary based on role, location, and firm, department and individual performance.Our BenefitsTo help you stay energized, engaged and inspired, we offer a wide range of benefits including a strong retirement plan, tuition reimbursement, comprehensive healthcare, support for working parents and Flexible Time Off (FTO) so you can relax, recharge and be there for the people you care about.Our hybrid work modelBlackRock’s hybrid work model is designed to enable a culture of collaboration and apprenticeship that enriches the experience of our employees, while supporting flexibility for all. Employees are currently required to work at least 4 days in the office per week, with the flexibility to work from home 1 day a week. Some business groups may require more time in the office due to their roles and responsibilities. We remain focused on increasing the impactful moments that arise when we work together in person – aligned with our commitment to performance and innovation. As a new joiner, you can count on this hybrid model to accelerate your learning and onboarding experience here at BlackRock.About BlackRockAt BlackRock, we are all connected by one mission: to help more and more people experience financial well-being. Our clients, and the people they serve, are saving for retirement, paying for their children’s educations, buying homes and starting businesses. Their investments also help to strengthen the global economy: support businesses small and large; finance infrastructure projects that connect and power cities; and facilitate innovations that drive progress.This mission would not be possible without our smartest investment – the one we make in our employees. It’s why we’re dedicated to creating an environment where our colleagues feel welcomed, valued and supported with networks, benefits and development opportunities to help them thrive.For additional information on BlackRock, please visit @blackrock (opens in new window) | Twitter: @blackrock (opens in new window) | LinkedIn: www.linkedin.com/company/blackrock (opens in new window)BlackRock is proud to be an equal opportunity workplace. We are committed to equal employment opportunity to all applicants and existing employees, and we evaluate qualified applicants without regard to race, creed, color, national origin, sex (including pregnancy and gender identity/expression), sexual orientation, age, ancestry, physical or mental disability, marital status, political affiliation, religion, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. View the EEOC’s Know Your Rights poster and its supplement (opens in new window) and the pay transparency statement (opens in new window).BlackRock is committed to full inclusion of all qualified individuals and to providing reasonable accommodations or job modifications for individuals with disabilities. If reasonable accommodation/adjustments are needed throughout the employment process, please email Disability.Assistance@blackrock.com (opens in new window). All requests are treated in line with our privacy policy (opens in new window). (opens in new window)BlackRock will consider for employment qualified applicants with arrest or conviction records in a manner consistent with the requirements of the law, including any applicable fair chance law.Job Requisition #R261692Apply