Senior Data Architect (Snowflake)- Market Research

📋 Description

• Design and build scalable core tables that transform raw event data into reliable, well-structured
• Engineer incremental dbt models for billion-row tables using merge strategies, clustering
• Implement identity-resolution solutions that correctly handle merged identities, late-arriving
• Design fact and dimension marts and define approved datasets for BI developers, analysts, and data
• Solve complex SQL challenges involving performance, correctness, window functions, and
• Design reliable ingestion from Amazon S3 into Snowflake using Snowpipe, stages, storage

🎯 Requirements

• 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
• Advanced data-modeling experience, including dimensional modeling, fact and dimension marts, slowly
• Advanced dbt experience with incremental strategies, snapshots, macros, testing, and billion-row
• Experience working with behavioral or event data, including sessionization, identity resolution

🎁 Benefits

• 100% Remote Work
• Highly Competitive USD Pay
• Paid Time Off
• Work with Autonomy
• Work with Top American Companies
• A Culture That Values You