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