Arquitecto de Datos Senior — 100% Remoto

Truelogic; United States; Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

100% Remote Work

Competitive USD Pay

Paid Time Off

Autonomy in work

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. You will transform raw S3/event data into core tables and dimensional marts, solving complex SQL problems while ensuring data correctness, security, and cost control at scale.

The role partners with software engineers, engineers, and data scientists to define data contracts and event-driven patterns, with 100% remote work and USD pay.

Qualifications

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
• 3+ years 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

Data Engineering

Data Architecture

Analytics Engineering

SQL

Data Modeling

dbt

Python

AWS

Tools

Snowflake

dbt

Python

AWS

Parquet

S3

Snowpipe

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. You will transform raw S3/event data into core tables and dimensional marts, solving complex SQL problems while ensuring data correctness, security, and cost control at scale.

The role partners with software engineers, engineers, and data scientists to define data contracts and event-driven patterns, with 100% remote work and USD pay.