Lead Data Engineer-Snowflake

Cognizant Technology Solutions Corporation; Hartford (CT); Hybrid; USD 115,000 - 135,000; Full time

Benefits offered by this job

Medical, Dental, Vision, and Life Ins.

Paid Holidays and PTO

401(k) with company contributions

Short-Term and Long-Term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Employee Assistance and Wellbeing

Training, Certification, and Prof Dev

Job summary

Cognizant Technology Solutions Corporation is seeking a Lead Data Engineer – Snowflake in Hartford, CT. The role focuses on designing scalable cloud-based data platforms to support enterprise reporting and analytics.

You will mentor engineers, optimize Snowflake workloads, and collaborate with business stakeholders to deliver reliable data assets. The hybrid role allows flexible work arrangements within the Eastern Time Zone.

Qualifications

• 8-12 years of experience in Data Engineering, Data Warehousing, ETL Development, or related disciplines.
• Strong hands-on experience with Snowflake, Snowflake SQL, and Snowpipe.
• Proven experience designing and implementing enterprise-scale ETL and data integration solutions.
• Expertise in Snowflake performance tuning, optimization, and workload management.
• Experience designing cloud-based data warehouses and modern analytics platforms.
• Strong SQL development and data modeling skills.
• Experience implementing data quality validation, reconciliation, and monitoring processes.
• Proven ability to lead technical initiatives and collaborate effectively across distributed teams.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

Responsibilities

• Lead design and implementation of Snowflake-based data solutions.
• Develop and optimize ETL workflows into Snowflake environments.
• Configure and support Snowpipe-based ingestion processes.
• Design and optimize Snowflake data models, schemas, and SQL workloads.
• Drive performance tuning, workload optimization, and capacity planning.
• Implement data quality controls, validation frameworks, and exception handling.
• Collaborate with stakeholders to translate analytical requirements.
• Troubleshoot data pipeline and platform issues with root-cause analysis.
• Develop reusable engineering frameworks, coding standards, and best practices.
• Mentor team members on Snowflake, ETL development, and data modeling.

Tools

Snowflake

Job description

Lead Data Engineer – Snowflake

About the role

As a Lead Data Engineer – Snowflake , you will make an impact by designing and delivering scalable, high-performance data solutions that enable critical business insights and operational excellence. You will be a valued member of the Data & Analytics team and work collaboratively with business stakeholders, data architects, analysts, and engineering teams to develop modern cloud-based data platforms that support enterprise reporting, analytics, and decision-making.

In this role, you will:

• Lead the design and implementation of Snowflake-based data solutions that transform raw data into trusted, business-ready information assets.
• Develop and optimize ETL workflows that integrate data from multiple internal and external sources into Snowflake environments.
• Configure and support Snowpipe-based ingestion processes to enable reliable batch and near real-time data integration.
• Design and optimize Snowflake data models, schemas, and SQL workloads to support enterprise analytics and reporting requirements.
• Drive performance tuning, workload optimization, and capacity planning activities across Snowflake environments.
• Implement data quality controls, validation frameworks, and exception handling processes to ensure data accuracy and reliability.
• Collaborate with business and technical stakeholders to translate analytical requirements into scalable data engineering solutions.
• Troubleshoot and resolve data pipeline and platform issues through root cause analysis and continuous improvement initiatives.
• Develop reusable engineering frameworks, coding standards, and best practices that improve delivery speed and solution quality.
• Mentor team members and provide technical guidance on Snowflake, ETL development, data modeling, and engineering best practices.

Work model

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, Hartford, CT is the preferred location with a hybrid work model . Qualified candidates located within the Eastern Time Zone may also be considered for a remote work arrangement based on project and business needs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.

What you need to have to be considered

• 8-12 years of experience in Data Engineering, Data Warehousing, ETL Development, or related disciplines.
• Strong hands-on experience with Snowflake, Snowflake SQL, and Snowpipe.
• Proven experience designing and implementing enterprise-scale ETL and data integration solutions.
• Expertise in Snowflake performance tuning, optimization, and workload management.
• Experience designing cloud-based data warehouses and modern analytics platforms.
• Strong SQL development and data modeling skills.
• Experience implementing data quality validation, reconciliation, and monitoring processes.
• Proven ability to lead technical initiatives and collaborate effectively across distributed teams.
• Strong analytical, problem-solving, communication, and stakeholder management skills.

These will help you stand out

• Experience within the Property & Casualty Insurance industry.
• Knowledge of underwriting, claims, policy administration, billing, or insurance analytics data domains.
• Experience supporting near real-time data ingestion and streaming architectures.
• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform (GCP).
• Experience establishing enterprise data engineering standards, reusable frameworks, and automation approaches.
• Experience supporting large-scale data modernization initiatives and cloud transformations.

Compensation

Applications will be accepted until November 20, 2026.

The annual salary for this position is between $115,000- $135,000 , depending on experience, qualifications, geographic location, and other factors permitted by applicable law.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable compensation plans.

Pay Transparency

The salary range provided reflects Cognizant's good-faith estimate of compensation for this position at the time of posting. Actual compensation offered will be determined based on several factors, including but not limited to relevant experience, technical expertise, certifications, education, internal equity, geographic location, and business needs.

Cognizant is committed to providing competitive compensation and a comprehensive benefits package designed to support the health, well-being, and financial security of our associates.

Benefits

• Medical, Dental, Vision, and Life Insurance
• Paid Holidays and Paid Time Off
• 401(k) Plan with Company Contributions
• Short-Term and Long-Term Disability Coverage
• Paid Parental Leave
• Employee Stock Purchase Plan
• Employee Assistance and Wellbeing Programs
• Training, Certification, and Professional Development Opportunities

Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.