Description

Design and implement scalable data processing pipelines to extract, transform, and load data into the Enterprise Data Warehouse.

Responsibilities

• Design dimensional, fact, star, and snowflake schemas including conceptual, logical, and physical data models.
• Develop and maintain ETL workflows, mappings, and transformation jobs on Snowflake 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.
• Bachelor’s degree in Computer Science or equivalent work experience.

Preferred Skills

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

Key Skills

Education

Bachelor’s degree in Computer Science