Description

You will build and maintain data pipelines and warehousing solutions using Snowflake.

Responsibilities

• Design and develop system components for ETL/ELT processes to move data from source systems to target applications.
• Participate in data modeling sessions and create detailed data mapping specifications.
• Develop processes for audit, balancing, reconciliation, and error handling.
• Perform internal design and code reviews to ensure quality and performance optimization.
• Document data flows and technical designs for both internal and external stakeholders.

Required Skills

• 7+ years of Data Warehousing experience.
• 3+ years of hands-on implementation experience with Snowflake concepts.
• Proficiency in SQL and PL/SQL.
• Experience with Python scripting and Unix.
• Strong understanding of CI/CD and code versioning using GitHub.
• Experience with ELT/ETL tools.
• Knowledge of Agile Scrum methodology.
• Bachelors or Masters in IT, Computer, Software, or a related field.
• Domain knowledge in P&C Insurance, specifically Commercial Property, General Liability, Inland Marine, Product Liability, Auto, and Umbrella.

Preferred Skills

• Knowledge of Streamsets.
• Knowledge of Data Vault.

Key Skills

Education

Bachelors or Masters in IT, Computer, Software