Senior Data Architect (North America)

Role overview

Set the architecture and modeling direction for a mature Snowflake data platform that combines more than 40 sources. The near-term focus is trustworthy financial reporting: connecting ledger activity and account hierarchies to financial statements, while improving the platform’s structure, governance, and usefulness across business teams.

Responsibilities - Assess the existing platform and define data layers, modeling conventions, naming and grain standards, and approaches for corrections and late-arriving data. - Design models for general ledger activity, charts of accounts, and account hierarchies that support consistent financial and management reporting. - Work with finance, investment, and operations stakeholders to turn reporting and decision-making needs into scalable data designs. - Set ingestion, transformation, and orchestration patterns across real estate, finance, and external data sources, including lineage, quality, and testing practices. - Guide Snowflake performance, warehouse sizing, and cost decisions, making trade-offs clear to technical and nontechnical colleagues. - Lead design reviews, document decisions, mentor data engineers, and shape approaches to governance, cataloging, and future AI-enabled use cases.

Requirements - At least seven years in data engineering, data architecture, or database engineering, including ownership of production data platforms. - Deep hands-on experience with a cloud data warehouse; Snowflake is preferred, with Databricks or similar also relevant. - Strong data modeling experience, especially with financial reporting structures and account hierarchies. - Ability to design integrations across multiple sources and address data quality, lineage, testing, and operational reliability. - Skill in explaining architecture choices to business stakeholders and guiding engineers through design decisions. - Comfort improving an existing platform, working independently in a distributed team, and adapting as priorities evolve.

Benefits and work setup

The role is on a small, senior data and analytics team. Work includes stabilizing and improving an established platform, with async collaboration, design documentation, and iterative feedback.