Senior Snowflake Data Architect | Remote & dbt Focus

Truelogic; United States; Teletrabalho; USD 130 000 - 180 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Remote work

Competitive USD pay

Paid Time Off

Autonomy

Work with U.S. companies

Resumo da oferta

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 data into reliable core tables and dimensional marts that support analytics and data science.

You will solve complex SQL challenges, engineer billion-row incremental models, administer Snowflake, establish modeling standards, and partner with engineers to optimize data correctness, performance, governance, and cost across

Qualificações

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.
• 3+ years building production solutions with Snowflake.
• Expert SQL skills and ability to optimize datasets.
• Advanced data modeling including dimensional modeling and marts.
• Advanced dbt experience with incremental approaches and billion-row datasets.
• Experience with behavioral/event data, identity resolution, and late-arriving events.
• Deep Snowflake expertise including RBAC, Snowpipe, and cost management.
• Experience with AWS services (S3, IAM, SNS, SQS).
• Ability to read and review Python code.
• Excellent written and verbal English communication.

Responsabilidades

• Design scalable core tables transforming raw event data into reliable datasets.
• Engineer incremental dbt models for billion-row tables with merge and clustering.
• Implement identity-resolution for merged identities and duplicates.
• Create fact and dimension marts and define approved datasets for BI/analysts.
• Tackle complex SQL challenges involving performance and data correctness.
• Ingest from S3 into Snowflake using Snowpipe and schema evolution.
• Collaborate with engineers to define event-driven delivery schemas and data contracts.
• Manage Snowflake environments with RBAC, security policies, and warehouse config.
• Monitor pipeline stability, data freshness, and duplicates.
• Optimize Snowflake/dbt performance and cost.
• Establish data-modeling/dbt standards and review code.
• Produce design docs and coach engineers and analysts.

Conhecimentos

SQL

Snowflake

dbt

Python

Data modeling

Ferramentas

AWS

S3

Parquet

ETL

Descrição da oferta de emprego

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 data into reliable core tables and dimensional marts that support analytics and data science.

You will solve complex SQL challenges, engineer billion-row incremental models, administer Snowflake, establish modeling standards, and partner with engineers to optimize data correctness, performance, governance, and cost across