caferemote
Lateral Group

Senior Data Architect (North America)

Remote Anguilla, Antigua and Barbuda, Aruba, Bahamas, Barbados, Belize, Bermuda, Bonaire, Sint Eustatius and Saba, Canada, Cayman Islands, Costa Rica, Cuba, Curaçao, Dominica, Dominican Republic, El Salvador, Greenland, Grenada, Guadeloupe, Guatemala, Haiti Full-time Senior Posted 12 days ago
Apply now
Work from
Anguilla, Antigua and Barbuda, Aruba, Bahamas, Barbados, Belize, Bermuda, Bonaire, Sint Eustatius and Saba, Canada, Cayman Islands, Costa Rica, Cuba, Curaçao, Dominica, Dominican Republic, El Salvador, Greenland, Grenada, Guadeloupe, Guatemala, Haiti
Contract
Full-time
Experience
Senior
Posted
8 November 2026
Apply by
7 January 2027

Responsibilities

You’ll join a small, senior Data & Analytics team at a real estate investment firm that has built a sophisticated data platform on Snowflake, pulling together 40+ data sources. The platform has grown fast, and the team now needs an architect who can set the direction: how the data should be layered, modeled, governed, and served so that reporting is reliable and the business can trust it. The immediate priority is financial reporting: mapping account-level activity through account hierarchies into financial statements.

You will

  • Assess and shape the platform architecture. Review the existing Snowflake environment, work out what is actually working and what isn’t, and define the target architecture: layering from raw through staging to marts, naming and grain standards, and how corrections and late-arriving data are handled.
  • Design the financial data model. Model general ledger activity, charts of accounts, and account hierarchies so they roll up cleanly into financial statements and management reporting, and stay consistent as new sources are added.
  • Design for the business, not just the ticket. Work with finance, investment, and operations stakeholders to understand how Transactions, Reporting and source of truth, and Day-to-day decision making depend on the data, and translate that into scalable designs.
  • Own integration design across 40+ sources. Define patterns for ingestion, transformation, and orchestration across real estate systems, finance systems, and external feeds, with attention to lineage, data quality, and testing.
  • Optimize for performance and cost. Guide warehouse sizing, query performance, and cost management in Snowflake, and make trade-offs visible to engineers and non-engineers alike.
  • Set the standard and lead by example. Run design reviews, produce clear design documentation, mentor data engineers, and push back when something isn’t right.
  • Prepare the platform for what’s next. Shape how the team approaches governance, data cataloging, and AI-enabled use cases so outputs are consistent and reusable.

Requirements

We’re looking for someone highly technical who cares deeply about craft and can explain design choices to people who aren’t engineers. You must bring:

  • 7+ years in data engineering, data architecture, or database engineering, with real ownership of production data platforms
  • Deep, hands-on experience with a cloud data warehouse (Snowflake preferred; Databricks or similar considered), including performance tuning and cost management
  • Strong data modeling skills: stating and enforcing grain, dimensional modeling, layered architectures, and handling corrections and late-arriving data
  • Advanced SQL and experience designing efficient schemas for high-volume environments
  • Experience designing ETL/ELT pipelines and integrations across many sources, with a transformation framework (dbt or similar) and an orchestrator (Airflow, Dagster, or similar)
  • Finance literacy: experience modeling general ledger data, charts of accounts, and account hierarchies into financial or management reporting
  • Proven ability to diagnose and improve platforms you didn’t build, and to decide what to fix first
  • A quality mindset: testing, data quality, lineage, and clear design documentation (diagrams, decisions, trade-offs)
  • Strong English communication and comfort with remote, asynchronous work across time zones
  • A practical working relationship with AI tools in how you design, build, and document

Bonus points for

  • Experience in asset management, investment firms, or commercial real estate
  • Familiarity with systems such as Yardi, MRI, RealPage, Argus, VTS, or CoStar
  • Experience building analytics-ready models for BI tools (Power BI in particular)
  • Exposure to Snowflake AI capabilities (Cortex, agent-building) or data catalog and governance initiatives
  • Leadership of data architecture across multiple projects or business domains
  • A track record of mentoring other engineers

Benefits

Real impact. You'll work on meaningful products that make a measurable difference.

An outstanding team. Talented, kind, hard working people who care about their craft and about each other. No egos. No politics.

Growth. You'll be supported in growing your craft, exploring new paths, and stepping into greater responsibility, at your own pace.

A culture of excellence. We care about doing the right thing for our clients, our team, and ourselves. No burnout. No crunch. Just high quality work, delivered sustainably.

Variety and stability. We're profitable, independent, and over two decades strong. Yet every project brings a fresh challenge. You'll never be bored here.

This Role Might Not Be for You

We want to respect your time by being clear about what this role isn't. You should skip this opportunity if:

  • You prefer well defined structure. If you gravitate toward a clear hierarchy and well defined roles and swim lanes, you may find our self-managed style challenging.
  • Distributed work isn't your thing. If you find async communication, design documentation, and being proactive without a manager nearby difficult, our setup won't suit you.
  • Inheriting an existing environment doesn't appeal. This role starts by stabilizing and improving a platform someone else built, with a lot of moving parts. If you only want greenfield projects, you'll find it frustrating.
  • Feedback doesn't excite you. We're obsessed with quality and believe in continuous improvement. That means feedback that's sometimes nitpicky. If refining work until it's excellent feels over the top, this won't be a fit.
  • Change makes you uncomfortable. Priorities shift and processes evolve. If ambiguity is uncomfortable, this may feel bumpy.

However, if this sounds like fuel, we'd love to talk.

How to apply

How to Apply and What to Expect in the Interview Process

  1. Your work. Show us the work that reflects you at your best. We'll look at depth, the quality of your thinking, and the logic behind your choices.
  2. Lateral team fit. You'll speak with our Talent team about your career direction, your motivators, and our plans ahead.
  3. Work trial. You'll tackle a take-home challenge that mirrors what we actually do.
  4. Engineering deep dive. A collaborative session with our engineers.
  5. Project fit. An interview focused on prioritisation, collaboration across disciplines, and how you handle the messy middle.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

Similar remote jobs

Browse all →

Senior BI/DW Developer

Nextpower
Remote India Full-time

Job Description: BI/DW Architect (Finance Analytics & Insights) Position Summary The BI/DW Architect (Finance Analytics & Insights) is a strategic leader within the Global Controllership…

2h ago Data

Senior Analytics Solutions Lead – Power BI & Fabric

Cooper Equipment Rentals Limited
Remote Canada Full-time CAD 110K – CAD 130K / year

Build your Career at Cooper Equipment Rentals Please note, to be considered for this position applicants should currently be residing in Canada and legally entitled to work. Why Work with…

2h ago Data

ServiceNow Business Analyst

LIGHTFEATHER IO LLC
Remote United States Full-time $110K – $130K / year

LightFeather is seeking a Senior ServiceNow Business Analyst to lead the requirements gathering and process design for our federal agency clients. In this role, you will act as the critical…

2h ago Data

Senior Data Migration Specialist

WELLSTAR
Remote Canada Full-time CAD 75K – CAD 95K / year

Who we are At WELLSTAR , we are committed to reshaping Canadian healthcare by leveraging technology to address the administrative burdens that pull physicians away from their true calling,…

2h ago Data

Risk Adjustment Operations Senior Project Analyst

Datavant
Remote United States Full-time $103K – $121K / year

Datavant is the data collaboration platform trusted for healthcare. Guided by our mission to make the world’s health data secure, accessible and actionable, we provide critical data…

2h ago Data

Data Scientist

Timeleft
Remote Albania, Andorra, Austria, Belarus, Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czechia, Denmark, Estonia, Faroe Islands, Finland, France, Germany, Gibraltar, Greece, Guernsey, Holy See (Vatican City State), Hungary, Iceland, Ireland, Full-time

⌘Role Overview The Data Scientist is the first hire on the team whose job is to put machine learning into production , not just into a notebook. You'll build models that power product and…

4h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.