Senior Snowflake Data Architect (Remote)

Truelogic; United States; A distancia; USD 140.000 - 210.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

100% Remote Work

Highly Competitive USD Pay

Paid Time Off

Autonomy to manage your time

Work with Top American Companies

Descripción de la vacante

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a large-scale Snowflake/dbt platform for its U.S.-based client projects. You will transform raw S3 data into reliable core tables and dimensional marts, and partner with software engineers to build scalable data pipelines.

The role requires expert SQL, advanced data modeling, and hands-on Snowflake/dbt experience, with a focus on performance, security, governance, and cost optimization in

Formación

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

Responsabilidades

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

Conocimientos

SQL

Data Modeling

dbt

Python

Snowflake

AWS

Herramientas

Snowflake

dbt

Python

Parquet

Snowpipe

AWS

Descripción del empleo

Truelogic is seeking a Senior Data Architect to own the design, modeling, ingestion, and optimization of a large-scale Snowflake/dbt platform for its U.S.-based client projects. You will transform raw S3 data into reliable core tables and dimensional marts, and partner with software engineers to build scalable data pipelines.

The role requires expert SQL, advanced data modeling, and hands-on Snowflake/dbt experience, with a focus on performance, security, governance, and cost optimization in