Snowflake Data Architect Hands on Python

LTM; Hartford (CT); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Comprehensive Medical Plan

Disability Coverage

401(k) Plan with Company match

Life Insurance

Vacation Time and Sick Leave

Paid Holidays

Job summary

LTIMindtree is seeking a Snowflake and Python Data Engineer Lead (Onshore) for Hartford, CT (Onsite). The role requires deep expertise in Snowflake cloud, Python, and SnowSQL with 10–14 years of experience leading large enterprise data projects.

You will develop ETL pipelines, ingest data from CSV/JSON/XML, and ensure data integrity and compliance. Strong SQL and Snowflake skills are essential, along with collaboration across teams and basic insurance domain knowledge.

Qualifications

• Must be proficient in Snowflake features: writing complex queries, stored procedures, UDFs, etc.
• Programming languages: Python, SQL, SnowSQL – all mandatory.
• Experience with any ETL tool is acceptable.
• 10–14 years of experience as a technical lead in large-scale enterprise data projects.

Responsibilities

• Requires 10 to 14 years of experience with proven expertise as a Technical Lead in large-scale enterprise data projects on Snowflake cloud.
• Good knowledge and experience in Snowflake and Python.
• Develop ETL pipelines using Snowflake SQL.
• Data ingestion by extracting data from different types of files (CSV, JSON, XML).
• Implement data validation and transformation logic to ensure data integrity, consistency and compliance.
• Good understanding of ETL concepts and processes.
• Collaborate with teams to resolve issues.
• Basic knowledge of insurance domains.

Skills

Snowflake

Python

SQL

SnowSQL

ETL

Tools

ETL Tool

Job description

Overview

Snowflake and Python Data Engineer Lead (Onshore) – Hartford, CT (Onsite)

Responsibilities

1. Requires 10 to 14 years of experience with proven expertise as a Technical Lead in large‑scale enterprise data projects on Snowflake cloud.
2. Good knowledge and experience in Snowflake and Python.
3. Develop ETL pipelines using Snowflake SQL.
4. Data ingestion by extracting data from different types of files (CSV, JSON, XML).
5. Implement data validation and transformation logic to ensure data integrity, consistency and compliance.
6. Good understanding of ETL concepts and processes.
7. Collaborate with teams to resolve issues.
8. Basic knowledge of insurance domains.

Qualifications / Eligibility Criteria

• Must be proficient in Snowflake features: writing complex queries, stored procedures, UDFs, etc.
• Programming languages: Python, SQL, SnowSQL – all mandatory.
• Experience with any ETL tool is acceptable.
• 10–14 years of experience as a technical lead in large‑scale enterprise data projects.

Compensation & Benefits

Actual compensation within the displayed range will be dependent upon the individual's skills, experience, performance, and internal equity.

• Comprehensive Medical Plan covering Medical, Dental, Vision
• Short‑Term and Long‑Term Disability Coverage
• 401(k) Plan with Company match
• Life Insurance
• Vacation Time, Sick Leave, Paid Holidays
• Paid Paternity and Maternity Leave

The salary range reflects the minimum and maximum target for the position across all U.S. locations. Individual pay is determined by work location, job level, and additional factors such as skill set, experience, education, and training. Depending on the position, additional compensation may be provided as part of overall compensation such as an annual performance‑based bonus, sales incentive pay, and other variable compensation.

Equal Opportunity Employer

LTIMindtree is an equal‑opportunity employer committed to diversity. Employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family‑care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap, disability, genetic information, union affiliation, sexual orientation or preference, or any other characteristic protected by applicable law.