Senior Data Architect (Snowflake)- Market Research

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

About Truelogic

At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.

About Truelogic

At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.

Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.

By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.

Our Client

This market research company provides trusted data, forecasts, benchmarks, and expert analysis across advertising, media, commerce, technology, healthcare, and financial services. It combines proprietary research with thousands of vetted sources to help organizations understand consumer behavior, anticipate market trends, validate strategies, and make faster, more confident and informed business decisions.

Job Summary

We are 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 correctness, performance, security, governance, and cost across production environments at scale.

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.

Qualifications and Job Requirements

• 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.

What we offer

• 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.
• Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.
• Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.
• Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.
• Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.

Why You’ll Like Working Here

• A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.
• Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.
• Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.