Senior Data Architect – Snowflake, Market Research

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Create and develop scalable core tables that transform raw event data into dependable, well-organized datasets.

• Engineer incremental dbt models for tables containing billions of rows using merge strategies, clustering, deduplication, microbatch processing, and idempotent reprocessing.

• Implement identity-resolution solutions that manage merged identities, late-arriving data, and duplicate events.

• Design fact and dimension marts and establish approved datasets for BI developers, analysts, and data scientists.

• Tackle complex SQL challenges associated with performance, accuracy, window functions, and semi-structured data.

• Design ingestion processes from Amazon S3 into Snowflake utilizing Snowpipe, stages, storage integrations, COPY INTO, and schema evolution.

• Collaborate with software engineers on event-driven delivery patterns, schemas, data contracts, and columnar formats like Parquet.

• Manage Snowflake environments, including role-based access control, security policies, integrations, and warehouse configurations.

• Oversee pipeline stability, load failures, data freshness, late-arriving events, and duplicate files.

• Enhance Snowflake and dbt performance and cost efficiency 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, assess architectural trade-offs, and mentor engineers and analysts.

⛳️ Requirements

• 6+ years of experience in Data Engineering, Data Architecture, or Analytics Engineering.

• 3+ years of practical experience building production solutions with Snowflake.

• Proficient SQL skills at an expert level.

• Advanced experience in data modeling, including dimensional modeling, fact and dimension marts, slowly changing dimensions, conformed dimensions, and semi-structured data.

• Extensive dbt experience with incremental strategies, snapshots, macros, testing, and handling billion-row datasets.

• Familiarity with behavioral or event data, including sessionization, identity resolution, late-arriving events, and duplicates.

• In-depth Snowflake expertise covering RBAC, Snowpipe, stages, storage integrations, COPY INTO, schema inference, tasks, streams, clustering, and cost management.

• Basic understanding of AWS services, including S3, IAM, SNS, and SQS.

• Experience designing event-driven data integrations and working with formats such as Parquet.

• Capability to read and review Python code.

• Proven track record of diagnosing and resolving complex data issues with minimal guidance.

• Excellent written and verbal communication skills in English.

• Ability to articulate architectural decisions and technical trade-offs to both engineers and business leaders.

• Candidates must currently reside in Latin America.

🏝️ Benefits

• 100% Remote Work.

• Highly Competitive USD Pay.

• Paid Time Off.

• Work with Autonomy.

• Collaborate with Top American Companies.

• Engagement activities.

• Work-life balance.

• Collaborate with a diverse, multicultural global network.

• Opportunity to work alongside senior talent and seasoned experts.