Proviniti · 1 day ago
Senior Snowflake Subject Matter Expert (SME)
Berkeley Heights, NJ
Contract
Hybrid
Senior Level
$100/hr - $125/hrProviniti is seeking a Senior Snowflake Subject Matter Expert (SME) to drive technical excellence across their Snowflake data platform. This hands-on role involves collaborating with the Chief Architect and engineering teams to deliver scalable, secure, and cost-efficient solutions for analytics, reporting, and AI use cases.
Big DataBlockchainInformation Technology
Hiring Manager
Giardy Babila
Responsibilities
Provide Snowflake solution architecture for enterprise data warehousing and analytics workloads
Define and maintain Snowflake reference patterns for:
Database/schema/object design
Warehouse strategy (sizing, scaling, workload isolation)
Data sharing patterns (internal/external where applicable)
Streams, Tasks, and automation approaches
Review designs and implementations to ensure alignment with architecture standards and best practices
Lead and support implementation of modern warehousing patterns (layered/medallion, domain modeling, semantic/certified views)
Partner with engineering and analytics teams on:
Dimensional and analytical modeling
Curated datasets that support BI and downstream consumption
Data quality and reliability patterns (checks, SLAs, lineage-friendly design)
Tune and optimize Snowflake usage across teams:
Query performance (pruning, clustering strategy, optimization patterns)
Warehouse utilization (right-sizing, multi-cluster, workload separation)
Cost controls (credit usage visibility, guardrails, sustainable defaults)
Establish repeatable practices for monitoring and continuous optimization
Implement and reinforce Snowflake security patterns:
RBAC design and role hierarchy
Secure views
Masking and row-level controls where required
Ensure Snowflake implementations support auditability and policy-driven access
Lead technical enablement and implementation patterns for Snowflake Cortex
Partner with architecture, data, and business stakeholders to:
Identify viable Cortex use cases
Design governed, scalable AI patterns close to the data
Help teams operationalize AI features safely (controls, permissions, audit considerations)
Mentor engineers and analysts working in Snowflake; raise overall platform maturity
Create lightweight documentation: patterns, examples, “golden paths,” do/don’t lists
Act as the Snowflake escalation point for tough problems (performance, design tradeoffs, governance)
Qualification
Required
Advanced Snowflake expertise in enterprise environments (hands-on, not just conceptual)
Strong experience with: Snowflake SQL, query optimization
Warehouses, resource management, and workload isolation
Streams/Tasks and automation patterns
Data warehousing architecture and data modeling
Proven ability to implement secure, governed data access (RBAC, secure views, masking/row policies as needed)
Ability to translate business needs into practical, scalable technical designs
Strong communication skills—able to influence across engineering + stakeholders
Preferred
Experience with Snowflake Cortex and AI/LLM-enabled data use cases
Familiarity with BI ecosystems (e.g., Power BI) and semantic layer practices
Experience building medallion-style architectures and “certified” data products/views
Snowflake certifications (SnowPro Core / Advanced) are a plus
Experience operating in regulated/compliance-conscious environments
Company
Proviniti
Proviniti provides turnkey solutions that transform corporate IT into to high-performance, agile environments.
Founded in 2017
501-1000 employees
H1B Sponsorship
Proviniti has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
Funding
Current Stage
Late StageLeadership Team
Steven McCaffrey
CEO and Senior Managing Partner
Recent News
Company data provided by crunchbase