Snowflake Architect

CloudHive; United States; Remote; USD 100,000 - 130,000; Part time

Job summary

A technology consulting firm is seeking a Snowflake Data Architect with substantial experience in actuarial data. The role involves evaluating datasets, translating data requirements into specifications, and applying Snowflake best practices. A strong background in advanced SQL and business analysis is essential. This position offers a contract, remote work for candidates based in the US, providing a great opportunity for mid-senior level professionals to make an impact in the insurance industry.

Qualifications

• Minimum three years delivering Snowflake based projects.
• Hands on experience with actuarial data and insurance use cases.

Responsibilities

• Evaluate new datasets and produce documentation for audiences.
• Translate data needs into detailed technical specs and user stories.
• Design and build scalable transformation logic for pre ingested data.
• Apply Snowflake best practices across performance and governance.
• Bridge business and engineering, communicating insights and status.
• Coach junior colleagues on Snowflake usage patterns.

Skills

Advanced SQL

Business analysis

Scripting in Python

Data modeling

Snowflake platform expertise

Job description

President | Snowflake Squad Member | Sales & Technical Sales Pro ❄

Snowflake Data Architect with Actuarial Insurance Experience

Location: Remote (must be US-based)

Overview

We are seeking a Snowflake Data Architect who combines deep hands on platform expertise with strong business analysis skills. Experience working with actuarial data and insurance domains is required.

What you will do

• Source analysis and documentation: Evaluate new datasets, profiling structure, content, lineage, and relationships. Produce clear documentation for technical and business audiences.
• Requirements to specifications: Partner with stakeholders to elicit and refine data needs, then translate them into detailed technical specs and user stories for engineering teams.
• Transformations in Snowflake: Design and build scalable transformation logic for pre ingested data, leveraging Snowflake native features to deliver clean, reliable, and performant datasets.
• Platform excellence: Apply Snowflake best practices across performance, cost management, security, and governance.
• Cross functional liaison: Bridge business and engineering, communicating insights, trade offs, and status to keep all parties aligned.
• Enablement and mentoring: Coach junior colleagues on Snowflake usage patterns, modeling standards, and analytical methods.

What you will bring

• Domain background: Hands on experience with actuarial data and insurance use cases, such as pricing, reserving, risk, or policy analytics.
• Snowflake depth: Minimum three years delivering Snowflake based projects, with a strong command of its architecture, features, and data modeling approaches.
• Advanced SQL: Expert level SQL, including complex query patterns, stored procedures, tasks, dynamic tables, materialized views, and performance tuning.
• Business analysis: Proven track record gathering requirements, producing functional specifications, and collaborating with business partners.
• Scripting: Proficiency in Python for automation, orchestration, or data manipulation.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Consulting and Information Technology

Industries

• Insurance