Description

You will design and implement scalable data processing pipelines, dimensional models, and ETL workflows on Snowflake to support enterprise data warehousing and BI solutions.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical data models, including dimensional, fact, star, and snowflake schemas.
• Develop and maintain ETL workflows, mappings, and transformation jobs using SnowSQL and Snowpipe.
• Build scalable data pipelines to integrate data from ERP, CRM, and HRIS applications into BI solutions.
• Partner with BI teams to design reports and dashboards while ensuring data integrity and quality.
• Provide production support for ETL processes and resolve technical issues within the data warehouse.

Required Skills

• 6-8 years of experience in data warehousing and data integration projects.
• Expertise in Snowflake, including SnowSQL, Snowpipe, JavaScript UDFs, and stored procedures.
• Strong proficiency in SQL and relational databases such as Oracle or SQL Server.
• Hands-on experience with Python, Big Data, and Redshift or BigQuery.
• Experience with data migration from on-premise sources to Snowflake.
• Proficiency in UNIX/Linux shell scripting.

Preferred Skills

• Knowledge of IICS/Informatica.
• Experience within the Insurance domain.

Bachelor’s degree in Computer Science or equivalent work experience.

Key Skills

Education

Bachelor’s degree in Computer Science