Sr. Snowflake Data Engineer

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 a 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 & LocationThis is a Permanent position based out of South Sioux City, NE. Pay and BenefitsThe 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 & LocationThis is a Permanent position based out of South Sioux City, NE. Application DeadlineThis position is anticipated to close on Nov 17, 2026. Workplace TypeThis is a hybrid position in South Sioux City,NE.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

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.