Kodiak Solutions - Architect 2, Data

• 10+ years of experience across data architecture, data engineering or analytics engineering. • Expert-level Snowflake experience spanning semantic views and integrations; security controls, including row-level security (RLS), masking policies, and role management; and performance and cost optimization • Extensive experience in data architecture, with a focus on designing and implementing data frameworks. • Familiarity with Medallion and Lambda architecture patterns • Proficiency in developing data models, architecture, and governance procedures. • Familiarity with modeling techniques for online transaction processing (OLTP) systems and with dimensional modeling for analytics. • Experience with data modeling and design tools such as Erwin, ER Studio, or comparable modeling platforms. • Expert level experience with dbt, including incremental model design, custom materialization and test harness strategy, • Hands-on or architectural exposure to Sigma, Acceldata, Collibra, or related data stack is a plus. • Experience designing, implementing, or operating SQL Server. • Experience with CosmosDB or MongoDB is a plus