> Markdown version of [/jobs/ext/1948567-snowflake-lead-data-engineering](https://www.wearedevelopers.com/jobs/ext/1948567-snowflake-lead-data-engineering). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Snowflake Lead Data Engineering

- **Company:** Northern Base
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Training Data, Artificial Intelligence, Amazon Web Services, Data Analysis, ARM Architecture, Cyber Security, Continuous Integration, Data Validation, Information Engineering, Extract Transform Load (ETL), Data Masking, Fraud Prevention and Detection, Python (Programming Language), Machine Learning, NumPy, Performance Tuning, Query Optimization, Role-Based Access Control, Azure Machine Learning, SQL Databases, Talend, Data Processing, Cloud Platform System, Feature Engineering, Data Ingestion, Sql Optimization, Snowflake, Pandas, Scikit Learn, Data Analytics, Qlikview, Star Schema, Machine Learning Operations, Databricks
- **Published:** August 6, 2026
- **Apply:** https://www.careerjet.com/jobad/useaf03d47a6d8b25a937273e39896b946

## About the Role

Snowflake: Advanced SQL, Performance Tuning, Security, Snowpipe, Streams & Tasks
Data Engineering: ELT/ETL patterns, data modeling, CDC concepts
Python: Data processing, automation, Snowpark (preferred)
Strong understanding of cloud data platform architecture (AWS preferred)
AI / Analytics Skills
Hands on exposure to AI/ML pipelines (feature preparation, training data creation)
Experience supporting ML models through data engineering and operationalization
Familiarity with Python ML libraries (scikit learn, pandas, NumPy) applied from a data engineering perspective
Understanding of model lifecycle support (data refresh, monitoring, retraining inputs)
Domain & Soft Skills
Insurance domain experience (P&C / Specialty Insurance strongly preferred)
Strong communication skills for onsite customer interaction
Ability to translate business requirements into scalable data & AI solutions

## Description

Snowflake, Cortex AI, Python and Insurance Domain on AWS Cloud, Talend ETL
Roles & Responsibilities
The Snowflake Lead will serve as the onsite technical lead for CLEARBROOK 's enterprise data platform, responsible for end to end Snowflake solution design, development leadership, and AI/advanced analytics enablement. The role requires deep hands on expertise in Snowflake, strong data engineering fundamentals, and the ability to integrate AI/ML driven use cases into the Snowflake ecosystem while coordinating with offshore teams.
Snowflake Production Support
Perform root cause analysis for job failures and data analysis & fixes
Perform Month End Closing Activities
Snowflake Development & Architecture
Lead design and development of Snowflake schemas, tables, views, streams, tasks, and Snowpipes
Define and enforce best practices for performance optimization (warehouse sizing, clustering, query tuning)
Own Snowflake security architecture: RBAC, role hierarchy, data masking, row/column level security
Oversee promotion of code across environments using CI/CD practices
Data Engineering & Integration
Lead development of batch and near real time ingestion pipelines using Talend / Qlik Replicate / Snowpipe
Ensure data quality checks, reconciliation, and schema drift handling
Guide integration from insurance source systems (Policy, Claims, Billing, Reinsurance) into Snowflake
Provide technical oversight for SQL, Python, and ELT based transformations
AI / Advanced Analytics Enablement
Enable AI/ML use cases on Snowflake, including:
o Feature engineering datasets for ML models
o Snowpark (Python) based data processing
o Integration with external ML platforms (Databricks / SageMaker / Azure ML where applicable)
Support AI driven insights such as:
o Claims triage & risk scoring
o Fraud detection inputs
o Premium leakage and pricing analytics
Guide teams in using Python, SQL, and Snowflake native capabilities for data science workloads


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Vectorize all the things! Using linear algebra and NumPy to make your Python code lightning fast.](https://www.wearedevelopers.com/videos/562-vectorize-all-the-things-using-linear-algebra-and-numpy-to-make-your-python-code-lightning-fast)
- [Advanced Typing in TypeScript](https://www.wearedevelopers.com/videos/496-advanced-typing-in-typescript)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [How to implement convenient Python bindings to C++](https://www.wearedevelopers.com/videos/618-how-to-implement-convenient-python-bindings-to-c)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)