Snowflake

Lead / Architect Snowflake Engineer – SSE

Lincoln Rhode Island.

Primary skills: Snowflake, PySpark

Secondary skills: SQL, Python

Mode of Work: Work from Office

About the job

We are seeking a skilled Snowflake Engineer with expertise in PySpark to join our team and contribute to building scalable, efficient, and governed data solutions. The ideal candidate will have hands-on experience in designing and optimizing Snowflake data warehouses, leveraging PySpark for complex ETL/ELT processes. Proficiency in advanced Snowflake features, such as streams, tasks, materialized views, and SQL, is essential. A solid understanding of data governance principles, metadata management, and cloud platforms like AWS or Azure will be highly beneficial.

Know your team

At Value Momentum’s Technology Solution Center, we are a team of passionate engineers who thrive on tackling complex business challenges with innovative solutions while transforming the P&C insurance value chain. We achieve this through a strong engineering foundation and continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in 4 key areas: Platform, App & Infra Engineering, Data & BI Engineering, Core Engineering, Advance Analytics.

Join a team that invests in your growth. Our Infinity Program empowers you to build your career with role-specific skill development, leveraging immersive learning platforms. You'll have the opportunity to showcase your talents by contributing to impactful projects.

Responsibilities

• Design, develop, and manage data pipelines in Snowflake to support scalable and efficient data warehousing solutions.
• Implement and maintain PySpark notebooks, ensuring seamless data ingestion, transformation, and loading into Snowflake.
• Develop and optimize PySpark scripts for advanced data transformation and workflow automation.
• Integrate AWS with Snowflake stages for enhanced data processing
• Collaborate with cross-functional teams to gather requirements and translate business needs into robust technical solutions.
• Monitor and troubleshoot Snowflake, and Pyspark workflows to ensure performance, reliability, and availability.
• Implement and optimize data partitioning, indexing, and caching techniques to enhance query performance in Snowflake.
• Automate repetitive tasks and implement CI/CD pipelines for seamless deployment and monitoring of data workflows.
• Collaborate with stakeholders to gather requirements and translate them into technical solutions.
• Build and maintain comprehensive mapping documents, transformation of business rules, and custom processes for data governance and analytics.

Requirements - Must Have

• 5-7 years of experience in data engineering with expertise in Snowflake, and PySpark.
• Strong hands-on experience with Snowflake, including designing schemas, managing pipelines, and optimizing query performance.
• Proficiency in developing and maintaining Snowpark workflows, with expertise in integrating AWS with Snowflake.
• In-depth knowledge of Snowflake for implementing data governance, metadata management, and data lineage processes.
• Advanced skills in PySpark for complex data transformation and automation tasks
• Solid understanding of Data Warehousing concepts and distributed computing.
• Experience with Agile/Scrum methodologies and excellent problem-solving capabilities.
• Effective verbal and written communication skills for direct client interaction.
• Experience working as both an individual contributor and a team player.
• Experience in the P&C Insurance domain is preferred.

About Value Momentum

Value Momentum is a leading solutions provider for the global property & casualty insurance industry, supported by deep domain and technology capabilities. We offer a comprehensive suite of advisory, development, implementation, and maintenance services across the entire P&C insurance value chain. This includes Underwriting, Claims, Distribution, and more, empowering insurers to stay ahead with sustained growth, high performance, and enhanced stakeholder value. Trusted by over 75 insurers, Value Momentum is one of the largest standalone insurance-focused solutions providers in the US insurance industry.