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: Enjoy the freedom to work from the location that helps you thrive. All it takes
• Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond
• Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to
• Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on
• Work with Top American Companies: Grow your expertise working on innovative, high-impact projects