Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Company Overview