Solution Architect / Sr. Solution Architect - Snowflake

Solution Architect / Sr. Solution Architect – Snowflake 

Alpha Financial Markets Consulting (Alpha FMC) group, the leading global consultancy to the Insurance and InsurTech industries. We are a boutique management consulting firm that offers the world’s best Insurance and Financial Services groups a competitive edge through our expertise and industry insight. Our global Insurance Division is of a uniquely high calibre and by focusing on Insurance alone we build deep knowledge and experience within our industry.  

To clients, we are a trusted partner for creating programs, however, we are so much more to our employees. At Alpha, we pride ourselves in being a meritocratic environment perfect for building a career, meeting great people, as well as a rewarding place to work. 
 

About Alpha Insurance Technology Services 

As technology specialists, Alpha Insurance Technology Services: 

Provide knowledgeable resources who can implement, configure and support the major platforms used by our clients. 

Form a range of partnerships with key vendors to position itself as a preferred implementation partner for major business applications. 

Assist clients with their journey to the next generation of cloud-based architectures. 

Help clients to define and implement their future state data architectures. 

Help clients with bespoke development that complements their core application architecture. 

Provide knowledgeable and client-focused support for client’s major applications, including upgrades, migrations and business-as-usual issue management. 

 

Responsibilities 

• Design, build, and optimize enterprise-scale Snowflake environments, including database architecture, schema design, data modeling, and performance tuning across large and complex datasets.
• Serve as the internal and client-facing Snowflake subject matter expert — defining standards, best practices, and governance frameworks for Snowflake implementation and ongoing operations.
• Lead the design and delivery of end-to-end data pipelines into and out of Snowflake, including ingestion, transformation, and consumption layers, leveraging Snowflake-native capabilities (Streams, Tasks, Dynamic Tables, Snowpipe) wherever appropriate.
• Architect and implement Snowflake data sharing, data marketplace, and cross-cloud/cross-region replication strategies for client environments.
• Define and enforce Snowflake security architecture including role-based access control (RBAC), column-level and row-level security, data masking policies, and network policies.
• Lead Snowflake performance optimization activities including clustering keys, materialized views, query profiling, warehouse sizing, and cost governance.
• Drive adoption of Snowflake best practices across client delivery teams, including query optimization, warehousing strategy, and data lifecycle management.
• Translate business and technical requirements into Snowflake-first solution designs, defining required work packages, resourcing, and delivery approach.
• Define and socialize technical approaches for Snowflake-based implementations including data migration strategies, SDLC standards, and integration patterns — influencing client teams toward best practice.
• Lead and mentor a team of data engineers, providing technical direction and code/design review within a Snowflake-centric delivery model.
• Present solution designs, architecture options, and delivery recommendations to business and technology stakeholders at all levels.
• Contribute to Alpha's internal Snowflake IP, accelerators, and proposition development.
• Participate in project team meetings and communicate effectively across internal and client peers, architects, analysts, project managers, and technology teams. 

 

Requirements 

• Bachelor's degree in a related field and at least 5 years of data engineering experience, with a minimum of 3 years of hands-on Snowflake implementation experience.
• Snowflake certification(s): SnowPro Core at minimum; SnowPro Advanced: Data Engineer or Architect strongly preferred.
• Familiarity across the Snowflake platform including: Virtual Warehouses, Snowpipe, Streams & Tasks, Dynamic Tables, Data Sharing, Marketplace, Time Travel, Fail-safe, Zero-Copy Cloning, and Snowflake Cortex.
• Proven experience designing and implementing Snowflake security models, like RBAC, data masking, row-level security, and network policy configuration. 
• Strong experience with Snowflake performance tuning, like query optimization, clustering strategy, materialized views, warehouse rightsizing, and credit cost management.
• Experience integrating Snowflake with modern orchestration and transformation tools, particu