CloudHive ยท 15 hours ago
Snowflake Architect
United States
Contract
Remote
Mid Level
3+ years expCloudHive is seeking a Snowflake Data Architect who combines deep hands-on platform expertise with strong business analysis skills. The role involves evaluating datasets, translating data needs into technical specifications, designing scalable transformation logic in Snowflake, and mentoring junior colleagues.
Staffing & Recruiting
Hiring Manager
Levi L.
Responsibilities
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
Qualification
Required
Hands on experience with actuarial data and insurance use cases, such as pricing, reserving, risk, or policy analytics
Minimum three years delivering Snowflake based projects, with a strong command of its architecture, features, and data modeling approaches
Expert level SQL, including complex query patterns, stored procedures, tasks, dynamic tables, materialized views, and performance tuning
Proven track record gathering requirements, producing functional specifications, and collaborating with business partners
Proficiency in Python for automation, orchestration, or data manipulation
Company
CloudHive
CloudHive is your North America and LATAM Snowflake-focused staffing partner.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase