Senior Data Architect – North America
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Data Architect shaping Snowflake architecture, financial data models, and integrations for a real estate investment firm. Improving governance, performance, quality, and reporting reliability.
Responsibilities:
- Assess and shape the Snowflake data platform architecture
- Define target architecture across raw, staging, and mart layers
- Establish naming and data-grain standards
- Design approaches for corrections and late-arriving data
- Model general ledger activity, charts of accounts, and account hierarchies for financial statements and management reporting
- Work with finance, investment, and operations stakeholders to translate business needs into scalable data designs
- Define ingestion, transformation, and orchestration patterns across 40+ sources
- Address data lineage, data quality, and testing
- Guide Snowflake warehouse sizing, query performance, and cost management
- Run design reviews and produce design documentation, diagrams, decisions, and trade-offs
- Mentor data engineers and set technical standards
- Shape data governance, data cataloging, and AI-enabled use cases
- Participate in interviews and a take-home work trial as part of the hiring process
Requirements:
- 7+ years in data engineering, data architecture, or database engineering, with ownership of production data platforms
- Deep hands-on experience with a cloud data warehouse; Snowflake preferred, Databricks or similar considered
- Experience with performance tuning and cost management
- Strong data modeling skills, including grain definition, dimensional modeling, layered architectures, corrections, and late-arriving data
- Advanced SQL and efficient schema design for high-volume environments
- Experience designing ETL/ELT pipelines and integrations across many sources
- Experience with dbt or similar transformation frameworks
- Experience with Airflow, Dagster, or similar orchestration tools
- Experience modeling general ledger data, charts of accounts, and account hierarchies for financial or management reporting
- Ability to diagnose and improve platforms not originally built by the candidate
- Experience with testing, data quality, lineage, and clear design documentation
- Strong English communication skills
- Comfort with remote, asynchronous work across time zones
- Practical working relationship with AI tools for designing, building, and documenting
- Ability to work with ambiguity, shifting priorities, self-management, and continuous feedback
Benefits:
- Meaningful products with measurable impact
- Support for professional growth, exploring new paths, and greater responsibility
- Self-managed, distributed work environment
- Flexible asynchronous work across time zones
- No burnout or crunch; sustainable high-quality work
- Profitable, independent company with over two decades of stability
- Variety of projects and fresh challenges
- Talented, kind, collaborative team culture
- Remote work arrangement
Similar Jobs
Snowflake Data Architect
Senior Snowflake Data Architect designing Snowflake healthcare data platforms for Datavail. Leading patient identity, dimensional modeling, quality controls, and engineering delivery.
Data Architect – VA OCDAO Data and Analytics
Data Architect designing enterprise data models, taxonomies, and metadata standards for the Department of Veterans Affairs. Leading business architecture content and aligning data governance structures.
Data Engineer – VA OCDAO Data and Analytics
Data Engineer building pipelines and integrations for the Department of Veterans Affairs OCDAO enterprise data catalog. Applying data quality and security controls remotely across the United States.
SQL Developer, Data Migration Specialist
SQL Developer and Data Migration Specialist configuring Momentive Software’s cloud platform for nonprofits and associations. Developing client solutions, supporting data conversion, testing deployments, and training users.
Junior Data Engineer – Snowflake, Oracle
Data Engineer Jr apoiando a migração de Data Warehouse Oracle para Snowflake na Keyrus, grupo internacional de dados e IA. Desenvolvendo pipelines, validando código e documentando processos.
Data Engineer, Pharmacy Data, SQL Server
Remote Data Engineer building SQL Server pharmacy data pipelines for Chiri’s AI operating platform. Ensuring reliable ingestion, quality, observability, and high availability.
Middle Data Engineer
Data Engineer owning analytics infrastructure for Boosters’ JustDone AI research assistant. Building reliable event, ETL/ELT, BigQuery, Airflow, and Milvus pipelines.
Senior Data Engineer – Square, APAC
Senior Data Engineer building scalable data pipelines and feature platforms for Binance’s global cryptocurrency ecosystem. Supporting machine learning and recommendation systems across APAC.
Senior FHIR Data Platform Engineer
Senior engineer optimizing HAPI FHIR and PostgreSQL platforms for federal healthcare modernization. Delivering quality reporting, MDM, performance, and reliable data exchange.
Data Engineer – Level III
Data Architect / Engineering Lead guiding AWS modernization, enterprise data platforms, and AI/ML enablement. Supporting AttainX’s federal NRCS technology programs under the USDA OMNI contract.
Staff Data Engineer – Databricks
Staff Data Engineer designing scalable Azure and Databricks data platforms for CVS Health’s connected healthcare services. Leading architecture, pipeline optimization, data quality, and engineering mentorship.
Short-Term Membership Data Migration Consultant
Remote consultant migrating Together for Girls’ contact data from Airtable into EveryAction CRM. Cleansing, mapping, validating and documenting sensitive records for advocacy, fundraising and reporting.
Data Engineer
Senior Data Engineer designing scalable data pipelines and high-value products. Bridging data architecture with business applications in Study Patient projects.
Data Architect
Data Architect designing scalable data models, ETL pipelines, and SQL Server environments. Supporting Corpay’s global commercial payments solutions through migrations, warehousing, and data governance.
Senior Data Engineer – Cybersecurity
Senior Data Engineer modernizing Snowflake, DBT, SQL, and Python data infrastructure. Improving pipelines and security analytics for a global cybersecurity company.
Data Engineer – Databricks, PySpark
Data Engineer building Databricks and PySpark lakehouse solutions for Sigma Software’s AdTech analytics client. Developing scalable batch and near-real-time marketing data pipelines.
Data Engineer II – Data Platform
Data Engineer II building scalable AWS, Snowflake, and dbt data platforms for First Citizens Bank. Developing reliable pipelines, data quality controls, and analytics solutions.
Senior Data Engineer, Developer
Senior Data Engineer owning Azure data pipelines, integrations, and backend development. Supporting Smart Working’s global teams with financial analysis, automation, and business visibility.
Data Platform Engineer – Clearance Required
Data Platform Engineer building Palantir Foundry, Databricks, and Power Platform solutions for LMI’s Army and federal government clients. Leading data pipelines, AI/ML integration, and technical mentorship.
CRM/Data Platform Consultant
iGaming CRM consultant shaping an advanced player data platform for a MarTech company. Advising on strategy, architecture, vendor selection, retention, and multi-brand data.