Senior Snowflake Solutions Engineer

Resourceful is sourcing senior-level talent for a high-visibility engagement with one of the world's leading global investment management firms. This engagement is focused on designing and building next-generation AI capabilities on top of the client's Snowflake and Sigma environment.

Phase 1 (6 Weeks): The immediate priority is designing development workflows, patterns, and methodologies for building AI solutions on top of Snowflake and Sigma. The team will establish the architectural foundation and engineering standards that will guide all subsequent development.

Phase 2 (9+ Months): Upon successful completion of the initial phase, the engagement is expected to extend into a longer-term initiative to reimagine data governance, analytical interfaces, and AI-driven reporting - including intelligent chatbot experiences powered by Snowflake Cortex.

This is a hands-on, senior technical leadership role. The Senior Snowflake Solutions Engineer will serve as the Snowflake subject matter expert within a lean, high-caliber team, working directly with client stakeholders on-site in New York.

WHAT YOU'LL DO

Architecture & Engineering Leadership

• Design and architect scalable, production-grade data engineering workflows and pipelines on Snowflake
• Define reusable development patterns, standards, and methodologies for AI/ML workloads on Snowflake's Cortex AI layer
• Serve as the primary Snowflake subject matter expert for the client engagement team
• Lead hands-on technical delivery - this is a practitioner role, not purely advisory

Snowflake + Sigma + AI Integration

• Design integrations between Snowflake and Sigma Computing for advanced analytics and business reporting
• Leverage Snowflake Cortex and Snowpark to build AI/ML workflows directly within the Snowflake data cloud
• Develop AI-driven reporting interfaces, including chatbot and conversational analytics capabilities
• Partner with the Forward-Deployed AI Engineer to align data architecture with AI/ML model requirements

Governance & Standards

• Design and implement data governance frameworks, access controls, and data product standards in Snowflake
• Establish data quality, lineage, and observability practices for the Snowflake environment
• Document architectural decisions, technical standards, and engineering runbooks for client knowledge transfer

Stakeholder Engagement

• Work on-site at the client's New York offices in a client-facing, consultative capacity
• Collaborate directly with client technology and business stakeholders to understand requirements and translate them into technical architecture
• Communicate technical concepts clearly to both engineering audiences and business decision-makers

• Must be a U.S. Citizen or Permanent Resident (Green Card holder) - no visa sponsorship available for this engagement
• 8+ years of experience in data engineering, data architecture, or cloud data platform roles
• Expert-level Snowflake proficiency, including:
• Snowflake architecture, Snowpark, data sharing, and performance optimization
• Exposure to or strong interest in Snowflake Cortex AI and native ML capabilities
• Role-based access control (RBAC), data governance, and security best practices
• Demonstrated ability to design development patterns and engineering methodologies for AI/ML on a cloud data platform
• Strong track record of hands-on technical delivery in a senior individual contributor or architect capacity
• Proven ability to work on-site with large enterprise clients in a consulting or professional services context
• Exceptional communication skills - able to engage credibly at the architecture, engineering, and executive levels, * Experience in financial services, asset management, or similarly regulated industries
• Familiarity with AI-driven reporting, conversational analytics, or chatbot development (e.g., Snowflake Cortex Analyst, LLM-powered BI)
• Proficiency with Python, dbt, or modern data transformation frameworks
• Experience on Azure, AWS, or GCP cloud platforms alongside Snowflake
• Prior engagement at large institutional asset managers, global investment firms, or similarly complex financial services organizations
• Snowflake SnowPro Core Certification or higher
• Familiarity with Sigma Computing or similar BI tools in a Snowflake-connected environment