Sr. Snowflake Data Engineer

TEKsystems; United States; Hybrid; USD 140,000 - 165,000; Full time

Job summary

Great West Casualty Company is seeking a Senior Data Engineer to design and build a cloud-based data platform using Snowflake and Azure, enabling enterprise reporting, governance, and analytics for a leading property & casualty insurer.

You will partner with leadership, architects, and engineers to establish standards, modernize pipelines, and ensure scalable, auditable data solutions that inform strategic decisions and business outcomes across the organization.

Qualifications

• Masters Degree required.
• 5+ years of experience building cloud-based data solutions.
• Strong hands-on experience with Snowflake.
• Strong experience with Microsoft Azure data technologies.
• Advanced SQL development and optimization skills.
• Experience designing and implementing scalable enterprise data platforms.
• Experience defining data architecture, governance, and quality standards.
• Experience building data warehouses and modern cloud data lake solutions.
• Ability to lead architectural discussions and influence technical direction.
• Excellent communication skills with experience working directly with business leadership.
• Experience integrating data from multiple source types and formats.
• Proven ability to develop reliable, transparent, and auditable data solutions.

Responsibilities

• Design, build, and maintain cloud-based data solutions using Snowflake, Azure, SQL, and related technologies.
• Develop and optimize enterprise data pipelines supporting analytics and reporting initiatives.
• Define data architecture standards, data storage layers, and data engineering best practices.
• Evaluate and recommend technologies, tools, and architectural approaches to meet business needs.
• Structure and organize data across data lakes and data warehouse environments.
• Ingest and transform data from multiple sources and formats, including structured and semi-structured data.
• Implement data quality controls, governance processes, and audit-ready solutions.
• Collaborate with business stakeholders to understand reporting requirements and data needs.
• Communicate technical concepts effectively to both technical and non-technical audiences.
• Mentor junior engineers and provide technical leadership within the team.

Education

Masters Degree

Tools

Snowflake

Azure

SQL

Data Warehouses

Data Lake

Databases

Job description

Industry: Property & Casualty Insurance

Job Description

Join a growing data engineering team focused on transforming how a leading property and casualty insurance organization manages and leverages enterprise data. Following a large-scale implementation of claims, policy, and billing platforms, the organization is investing heavily in building an in-house, enterprise-grade data ecosystem and reducing reliance on vendor-managed solutions.

This Senior Data Engineer will play a key role in designing and building a scalable, transparent, and audit-ready data platform using Snowflake and Azure technologies. You will help define the future-state architecture, establish data engineering standards, modernize data pipelines, and influence long-term data strategy across the organization.

This is a highly visible opportunity for an experienced engineer who enjoys both strategic architecture discussions and hands-on development. You will partner closely with leadership, architects, business stakeholders, and fellow engineers to create a cloud-based data platform that supports enterprise reporting, analytics, governance, and business-critical decision making.

Key Project Initiatives

• Build and implement a new enterprise data platform in Snowflake to replace a legacy vendor-driven data solution.
• Support the organization’s transition to full ownership of its data ecosystem and reporting infrastructure.
• Design scalable data ingestion, transformation, and governance frameworks across multiple business domains.
• Modernize data pipelines supporting claims, policy, and billing data.
• Establish data quality, auditing, and governance standards for enterprise-wide analytics.
• Create a transparent and reliable reporting environment that improves data accessibility across the business.
• Partner with architects and business leaders to define future-state data architecture and technology direction.

Responsibilities

• Design, build, and maintain cloud-based data solutions using Snowflake, Azure, SQL, and related technologies.
• Develop and optimize enterprise data pipelines supporting analytics and reporting initiatives.
• Define data architecture standards, data storage layers, and data engineering best practices.
• Evaluate and recommend technologies, tools, and architectural approaches to meet business needs.
• Structure and organize data across data lakes and data warehouse environments.
• Ingest and transform data from multiple sources and formats, including structured and semi-structured data.
• Implement data quality controls, governance processes, and audit-ready solutions.
• Collaborate with business stakeholders to understand reporting requirements and data needs.
• Communicate technical concepts effectively to both technical and non-technical audiences.
• Mentor junior engineers and provide technical leadership within the team.

Required Qualifications

• Masters Degree required.
• 5+ years of experience building cloud-based data solutions.
• Strong hands-on experience with Snowflake.
• Strong experience with Microsoft Azure data technologies.
• Advanced SQL development and optimization skills.
• Experience designing and implementing scalable enterprise data platforms.
• Experience defining data architecture, governance, and quality standards.
• Experience building data warehouses and modern cloud data lake solutions.
• Ability to lead architectural discussions and influence technical direction.
• Excellent communication skills with experience working directly with business leadership.
• Experience integrating data from multiple source types and formats.
• Proven ability to develop reliable, transparent, and auditable data solutions.

Preferred Qualifications

• Experience with Databricks.
• Experience with AWS S3 or Azure Blob Storage.
• Familiarity with Kafka and Apache Spark.
• Insurance or Property & Casualty industry experience.
• Experience working with enterprise reporting and analytics platforms.
• Experience partnering with consulting organizations and cross-functional technology teams.

Work Environment

• Hybrid work environment.
• Candidates must live within driving distance of Sioux City, Iowa, for occasional team meetings and events.
• Monday through Friday schedule.
• Collaborative, highly visible team with significant influence on enterprise data strategy.
• Opportunity to serve as Senior technical leader and help shape the future of data engineering within the organization.
• Please note, at this time the client is not able to employee candidates in the following states: CA, WY, MS, WV, DC, DM, DE, NJ, RI, VT, NY, ME

Why Apply?

This is an opportunity to help build a modern enterprise data platform from the ground up rather than simply maintain existing systems. You’ll have direct influence on architecture, technology selection, governance standards, and overall data strategy while working on a highly strategic initiative that will impact reporting, analytics, and decision-making across the entire organization.

Job Type & Location

This is a Permanent position based out of South Sioux City, NE.

Pay and Benefits

The pay range for this position is $140000.00 - $165000.00/yr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Great West Casualty Company offers a comprehensive employee Great West Company Benefits package featuring a standard 37.5-hour workweek and broad hybrid work flexibility. [1] (https://orgreatwest.com/careers/benefits)

Job Type & Location

This is a Permanent position based out of South Sioux City, NE.

Application Deadline

This position is anticipated to close on Nov 17, 2026.

Workplace Type

This is a hybrid position in South Sioux City,NE.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.