Snowflake Data Engineer

Agilyti is seeking a technical lead for a Snowflake data foundation and data transformation project for a CPG / Retail client. The role involves owning platform architecture, data modeling, and Snowflake ML configuration, while leading engagement with an executive team and overseeing various data engineering responsibilities.

Responsibilities:

• Stand up and administrate Snowflake Enterprise from ground zero; administrative workflows, user management, security & governance, environment standup, ingestion & ETL, and analytics enablement
• Engagement lead with a small, highly involved executive team
• Configure ingestion for NetSuite, NetStock, Shopify, and retail partner feeds
• Design data transformation and aggregation patterns; complete historical backfill
• Build unified masters across all sources with a single taxonomy, lifecycle status, and IDs
• Build core data models: Unified Sales Fact, Inventory Positions, Retailer Sell-Through, Marketing and Web Analytics, Supplier/PO
• Define semantic views and governed metrics in collaboration with business leads
• Produce a cross-channel crosswalk and the unmatched exception report
• Configure Cortex Analyst over signed-off semantic views
• Configure spend controls: Resource Monitor, statement timeout, auto-suspend, Cortex model allowlist, per-user Cortex limits, Cortex Code caps, and an account Budget
• Establish Day 1 observability using native Snowflake capabilities
• Reconcile modeled totals to source systems

Requirements:

• 8+ years in data engineering, with production Snowflake delivery
• Executive stakeholder engagement experience, able to translate complex requirements into functional explanations, and vice versa, delivered to a senior audience
• Ability to train and upskill a business-focused, non-technical team on Snowflake and Cortex AI
• Timely, responsive, and reliable for walkthroughs, demos, trainings, and tasks
• Agile planning and execution
• Hands-on Snowflake architecture: RBAC, row-access policies, warehouses, resource monitors, Time Travel
• Dimensional and semantic data modeling across multi-source retail or commerce data
• SQL and dbt for transformation and pipeline configuration
• Experience integrating ERP, e-commerce, or third-party data feeds
• CPG or retail domain experience
• Familiarity with S&OP data structures and forecasting inputs