Senior Snowflake Data Architect - Remote & Scalable Analytics

Truelogic; Bogotá ciudad; Remote; COP 453,162,000 - 647,375,000; Full time

Benefits offered by this job

Remote 100%

USD Pay

Paid Time Off

Autonomy

Work with U.S. companies

Job summary

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

You will solve complex SQL problems, engineer billion‑row models, and optimize data correctness, performance, and governance. The ideal candidate has 6+ years in data engineering/architecture, expert SQL, and deep Snowflake/dbt

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, marts, SCDs, and semi‑structured data.
• Advanced dbt experience with incremental strategies, snapshots, and billion‑row datasets.
• Experience with behavioral or event data, identity resolution, late‑arriving events, and duplicates.
• Deep Snowflake expertise covering RBAC, Snowpipe, stages, and cost management.
• Working knowledge of AWS services (S3, IAM, SNS, SQS) and Parquet formats.
• Ability to read and review Python code and explain architectural decisions clearly.
• Proven ability to take complex data problems from diagnosis through production with minimal direction.
• Strong written and verbal English communication skills.

Responsibilities

• Design and build scalable core tables transforming raw event data into structured datasets.
• Engineer incremental dbt models for billion‑row tables with merge, clustering, and deduplication.
• Implement identity‑resolution solutions handling merged identities and late‑arriving data.
• Design fact and dimension marts and define datasets for BI developers and data scientists.
• Tackle complex SQL challenges including performance, window functions, and semi‑structured data.
• Ingest from Amazon S3 into Snowflake using Snowpipe, stages, and COPY INTO with schema evolution.
• Collaborate with engineers to define event‑driven delivery patterns and data contracts.
• Administer Snowflake environments with RBAC, security policies, and warehouses.
• Monitor pipelines, data freshness, load failures, and duplicates; optimize cost/performance.
• Establish data modeling and dbt standards; review SQL, dbt, and Python code.
• Produce design documentation and coach engineers and analysts.

Skills

SQL Proficiency

Data Modeling

Python

Executive Collaboration

Problem Solving

Analytical Thinking

Tools

Snowflake

dbt

Python

AWS S3

Parquet

Job description

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

You will solve complex SQL problems, engineer billion‑row models, and optimize data correctness, performance, and governance. The ideal candidate has 6+ years in data engineering/architecture, expert SQL, and deep Snowflake/dbt