Snowflake Engineer – SSE

Snowflake Engineer – SSE
Lincoln Rhode Island (5 Days onsite)

NO H1B & OPT 
Long Term



Primary skills: Snowflake, PySpark
Secondary skills: SQL, Python

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.