Senior Data Architect (North America)

Lateral Group; EE. UU.; A distancia; USD 140.000 - 210.000; Jornada completa

Descripción de la vacante

Lateral Group is seeking a senior data architect to set the architecture and modeling direction for a mature Snowflake data platform that integrates 40+ sources. The initial focus is trustworthy financial reporting.

You will shape data layers, governance, and scalable designs, collaborating with finance and operations while guiding performance, cost, and quality across the data stack. This role also involves mentoring engineers in a distributed team.

Formación

• 7+ years in data engineering or architecture with ownership of production data platforms.
• Deep hands-on experience with a cloud data warehouse; Snowflake preferred; Databricks or similar also relevant.
• Strong data modeling experience for financial reporting structures and account hierarchies.
• Ability to design integrations across multiple sources with data quality, lineage, testing, and operational reliability.
• Ability to explain architecture to business stakeholders and guide engineers through design decisions.
• Comfort improving an existing platform within a distributed team and adapting as priorities evolve.

Responsabilidades

• 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 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.

Conocimientos

Data engineering

Data architecture

Data modeling

Cloud data warehouse

Stakeholder communication

Performance tuning

Herramientas

Snowflake

Databricks

ETL tools

Descripción del empleo

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.