Snowflake Lead Data Engineering
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.1
Reclaim your time by letting our AI handle the grunt work of job searching.
We continuously scan millions of openings to find your top matches.
Overview
Remote
On-site
Compensation
$50-$53/hour
Job Description
Request ID: 100849-1 Title: Snowflake Lead – Data Engineering Locations: Onsite: San Antonio, TX / New York, NY only Duration: 6 Months Pay Range: $50- $53/Hour on W2/C2C (All inclusive) Requested: Local to San Antonio, TX / New York, NY only! Essential Skills: Good information and sound knowledge in Snowflak and Talend. Skills: Talend Open Studio, Snowflake Experience Required: 10 & AboveRole description: 12+ years in Data Engineering / Analytics (Snowflake, Talend, DBT, Cortex AI, Python)(8+ years hands on Snowflake development & production support)(4+ years’ experience in P&C Insurance customers, managing month end closing activities)(4+ years leading the team as technical lead) Must Have Technical/Functional Skills 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: oFeature engineering datasets for ML models oSnowpark (Python)–based data processing oIntegration with external ML platforms (Databricks / SageMaker / Azure ML where applicable)•Support AI driven insights such as: oClaims triage & risk scoring oFraud detection inputs oPremium leakage and pricing analytics•Guide teams in using Python, SQL, and Snowflake native capabilities for data science workloadsCore Technical Skills•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 solutionsCompany Benefits & Culture
- Inclusive and diverse work environment
- Opportunities for professional growth and development
- Comprehensive health and wellness benefits
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
FAQs About Snowflake Lead Data Engineering Jobs at Artech LLC
What is the work location for this position at Artech LLC?
This job at Artech LLC is located in San Antonio, TX, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Artech LLC?
Candidates can expect a pay range of $50–$53 per hour for this role.
What employment applies to this position at Artech LLC?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at Artech LLC?
You can apply for this role at Artech LLC either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.