Remote Senior Data Architect: Snowflake & dbt

Truelogic; New York (NY); Hybrid; MXN 2,517,000 - 3,416,000; Full time

Benefits offered by this job

100% Remote Work

Highly Competitive USD Pay

Paid Time Off

Work with Autonomy

Work with Top American Companies

Job summary

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a large-scale Snowflake and dbt platform. This hands-on role transforms raw S3 files and event data into reliable core tables and dimensional marts supporting analytics and data science.

The ideal candidate will solve complex SQL problems, engineer billion-row incremental models, administer Snowflake, establish modeling standards, and partner with software engineers while optimizing data

Qualifications

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
• 3+ years of hands-on experience building production solutions with Snowflake.
• Expert-level SQL skills and ability to independently solve complex modeling, performance, and data-correctness problems.
• Advanced data-modeling experience, including dimensional modeling, fact and dimension marts, slowly changing dimensions, conformed dimensions, and semi-structured data.
• Advanced dbt experience with incremental strategies, snapshots, macros, testing, and billion-row datasets.

Responsibilities

• Design and build scalable core tables that transform raw event data into reliable, well-structured datasets.
• Engineer incremental dbt models for billion-row tables using merge strategies, clustering, deduplication, microbatch processing, and idempotent reprocessing.
• Implement identity-resolution solutions that correctly handle merged identities, late-arriving data, and duplicate events.
• Design fact and dimension marts and define approved datasets for BI developers, analysts, and data scientists.
• Monitor pipeline stability, load failures, data freshness, late-arriving events, and duplicate files.
• Optimize Snowflake and dbt performance and cost through clustering, materialization strategies, warehouse sizing, query profiling, and scheduling.

Skills

SQL

Data Modeling

dbt

Python

Snowflake

Tools

Snowflake

dbt

Python

AWS

Parquet

Job description

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a large-scale Snowflake and dbt platform. This hands-on role transforms raw S3 files and event data into reliable core tables and dimensional marts supporting analytics and data science.

The ideal candidate will solve complex SQL problems, engineer billion-row incremental models, administer Snowflake, establish modeling standards, and partner with software engineers while optimizing data