Senior Data Architect (Snowflake) - 100% Remote + USD Pay

Truelogic; Colombia; Remote; COP 453,104,000 - 679,656,000; Full time

Benefits offered by this job

Remote work

USD pay

Paid time off

Autonomy

US clients

Job summary

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a Snowflake/dbt platform. You will transform raw S3 data into core tables and dimensional marts, solving complex SQL challenges at scale.

You will administer Snowflake environments, design event-driven data integrations, and collaborate with engineers to optimize performance, security, and cost. This role offers 100% remote work with USD pay and international teams.

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.
• Experience working with behavioral or event data, including sessionization, identity resolution, late-arriving events, and duplicates.
• Deep Snowflake expertise covering RBAC, Snowpipe, stages, storage integrations, COPY INTO, schema inference, tasks, streams, clustering, and cost management.
• Working knowledge of AWS services, including S3, IAM, SNS, and SQS.
• Experience designing event-driven data integrations and working with formats such as Parquet.
• Ability to read and review Python code.
• Proven ability to take complex data problems from diagnosis through production with minimal direction.
• Strong written and verbal English communication skills.
• Ability to explain architectural decisions and technical trade-offs to engineers and business leaders.

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.
• Solve complex SQL challenges involving performance, correctness, window functions, and semi-structured data.
• Design reliable ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage integrations, COPY INTO, and schema evolution.
• Partner with software engineers to define event-driven delivery patterns, schemas, data contracts, and columnar formats such as Parquet.
• Administer Snowflake environments, including role-based access control, security policies, integrations, and warehouse configuration.
• 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.
• Establish data-modeling and dbt standards and review complex SQL, dbt, and Python code.
• Produce design documentation, evaluate architectural trade-offs, and coach engineers and analysts.

Skills

SQL

Snowflake

dbt

Python

Data Modeling

AWS

S3

ETL/ELT

Performance Tuning

Data Governance

Tools

Snowflake

dbt

Python

Parquet

Snowpipe

AWS

S3

Job description

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a Snowflake/dbt platform. You will transform raw S3 data into core tables and dimensional marts, solving complex SQL challenges at scale.

You will administer Snowflake environments, design event-driven data integrations, and collaborate with engineers to optimize performance, security, and cost. This role offers 100% remote work with USD pay and international teams.