Senior Data Architect – Snowflake, Market Research

• Design and build scalable core tables transforming 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 handling 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 ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage integrations, COPY INTO, and schema evolution
• Partner with software engineers on 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

• 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
• 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 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
• Candidates must be currently based in Latin America

• 100% Remote Work
• Highly Competitive USD Pay
• Paid Time Off
• Work with Autonomy
• Work with Top American Companies
• Engagement activities
• Work-life balance
• Collaboration with a diverse, multicultural global network
• Opportunity to work with senior talent and seasoned experts