Lead Data Engineer-Snowflake

Cognizant; 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) Plan with Company Contributions

Disability Coverage

Paid Parental Leave

Employee Stock Purchase Plan

Employee Assistance and Wellbeing

Training, Certification and Pro Dev

Job summary

Cognizant is seeking a Lead Data Engineer – Snowflake in Hartford, CT, delivering scalable, high-performance data platforms for enterprise reporting and analytics. You will lead Snowflake-based solutions, optimize ETL pipelines, and drive data modeling and quality controls in a hybrid work setting.

Join a collaborative Data & Analytics team that partners with business stakeholders to translate analytics requirements into robust data engineering solutions and continuous improvement initiatives.

Qualifications

• 8–12 years of experience in Data Engineering, Data Warehousing, ETL Development, or related disciplines.

Responsibilities

• Lead the design and implementation of Snowflake-based data solutions for trusted information assets.
• Develop and optimize ETL workflows to Snowflake from multiple sources.
• Configure Snowpipe ingestion for reliable batch and near real-time data integration.
• Design and optimize Snowflake data models, schemas, and SQL workloads.
• Drive performance tuning, workload optimization, and capacity planning for Snowflake environments.
• Implement data quality controls and validation frameworks to ensure data reliability.
• Collaborate with stakeholders to translate analytics needs into scalable data solutions.
• Troubleshoot data pipelines and platform issues with root-cause analysis and continuous improvement.
• Develop reusable engineering frameworks, coding standards, and best practices.
• Mentor team members on Snowflake, ETL, data modeling, and engineering practices.

Skills

Snowflake

Snowpipe

ETL development

Data warehousing

SQL development

Data modeling

Cloud platforms

Stakeholder management

Mentoring

Job description

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.

We're excited to meet people who share our mission and can make an impact in a variety of ways. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.

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

Subject to applicable eligibility requirements, Cognizant offers:

• 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