Senior Data Engineer – Snowflake | dbt | SQL | Python

Work Authorization: Applicants must be legally authorized to work in the United States. Employer sponsorship, including H-1B sponsorship or visa transfers, is not available for this position now or in the future.

KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a Senior Data Engineer – Snowflake | dbt | SQL | Python.

Location: Remote – Nationwide U.S. search; required biweekly onsite travel to Columbia, Missouri.

Travel: Every other week, arriving Sunday evening, working onsite Monday through Thursday, and departing Thursday after work. Remote during alternating weeks. Business travel expenses covered.

Relocation: Relocation assistance available for candidates interested in moving closer to the client location.

Employment Type: Full-Time / Direct Hire

Target Start Date: November 1, 2026

Compensation: $110,000–$130,000 base salary, with flexibility to $150,000 for highly qualified candidates. Exceptional candidates above this range may be considered.

About the Company

Our client is an established consulting firm serving the financial services industry, bringing together specialist, sector-focused strategy, management consulting, and technology expertise to support the entire client transformation lifecycle.

The organization is a trusted advisor for complex change programs, partnering with enterprise clients across financial services, including the insurance industry.

Its people are at the heart of everything it does. The firm offers a genuinely rewarding place to work, with a merit-based environment where careers can flourish and a welcoming culture where employees can connect, collaborate, and thrive.

As the organization continues to grow, it is seeking collaborative, innovative, and ambitious professionals to help shape the next chapter of its growth.

Why Join?

• Established yet entrepreneurial: Enjoy the stability of an established consultancy with the energy of a fast-growing business.
• Exposure to senior leadership: Whether in an internal or client-facing role, employees have opportunities to work with and learn from experienced leaders.
• Learning and growth opportunities: Tailored training, mentorship, and up to five days of paid training time per year. Employees are given significant responsibility and autonomy, allowing them to develop their skill sets quickly.
• Performance-driven culture with real impact: Advancement is based on impact and capability, not tenure or quotas. Employees have autonomy and can see the tangible difference their ideas and decisions make.

Position Overview

Our client has a fast-growing team of dedicated consultants with deep experience from working both within the industry and consulting. Successful candidates should expect a diverse range of complex and strategic engagements across the financial services market, particularly within insurance.

As the organization continues to expand its client base and expertise, it is seeking experienced Senior Data Engineers to support its growth. You will be responsible for identifying and implementing technical solutions for a range of complex data engineering challenges facing enterprise clients.

Over the course of each project, you will work with large datasets, design and develop data pipelines, implement data ingestion and transformation solutions, and collaborate with technical teams and client stakeholders to solve their unique business challenges. You'll play a proactive role in driving programs forward and engaging directly with client stakeholders.

This is a hands-on technical consulting position requiring strong Snowflake, dbt, SQL, and Python experience, along with excellent client-facing communication skills.

What You Will Be Doing

• Design, implement, and maintain data pipelines, data integration solutions, and data architecture.
• Apply hands-on Snowflake expertise to ensure efficient and scalable data storage, processing, and analytics.
• Design, develop, and maintain ETL/ELT pipelines supporting data ingestion, transformation, and delivery.
• Develop and maintain dbt models and transformation workflows.
• Use advanced SQL and Python to develop, optimize, automate, and troubleshoot data engineering solutions.
• Support data modeling, data quality, performance optimization, and production troubleshooting.
• Collaborate with engineering teams and client stakeholders to implement scalable, reliable data solutions.

What We're Looking For

Required Qualifications

• 5–7 years of professional Data Engineering experience, including hands-on development of enterprise data solutions.
• 2 years of recent, hands-on Snowflake experience, including data ingestion, storage, transformation, data modeling, performance optimization, and security.
• Hands-on experience with dbt (Data Build Tool) for data transformation and modeling.
• Advanced SQL skills for complex queries, data manipulation, optimization, and troubleshooting.
• Strong Python programming and scripting experience for data engineering and automation.
• Strong understanding of data engineering principles, data modeling, ETL processes, and data warehousing concepts.
• Experience designing, developing, and maintaining production data pipelines.
• Experience with cloud platforms, such as AWS or Azure, and working with cloud-based data solutions and services.
• Familiarity with data quality, data governance, and data lifecycle management practices.
• Strong problem-solving and troubleshooting abilities, with the ability to diagnose and resolve data engineering issues.
• Excellent client-facing communication and interpersonal skills, with the ability to confidently engage with client stakeholders, articulate complex technical problems and solutions clearly, and represent the consulting organization professionally.
• Ability to work effectively with cross-functional teams and stakeholders.
• Proven track record of building and sustaining lasting relationships with team members.
• Intellectual capacity and ability to think in new, innovative ways to understand complex issues and develop creative solutions.
• Ability to comfortably multitask and engage in multiple initiatives concurrently.
• Ability to perform essential functions of the position, with or without reasonable accommodation.

Preferred Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field.
• Experience with Qlik Replicate and Qlik Compose for data integration and replication.
• Experience with Astronomer / Apache Airflow for data pipeline orchestration.
• Experience with comparable ingestion and integration technologies, such as Fivetran or Airbyte.
• Experience with GitHub or comparable version-control and development workflows.
• Previous professional consulting experience is a plus, particularly with a Big Four consulting firm or comparable management or technology consulting organization.
• Experience within financial services, preferably within the insurance industry.

Work Arrangement & Travel

The initial engagement requires biweekly onsite travel to Columbia, Missouri.

• Sunday: Fly into Missouri in the evening.
• Monday–Thursday: Work onsite, beginning at approximately 8:00 AM Monday.
• Thursday: Depart after the workday.
• Alternate week: Work remotely from within the United States.

Approved business travel expenses, including airfare, lodging, and ground transportation, are covered.

Relocation assistance is available for candidates interested in relocating closer to the client location.

The initial engagement is expected to last approximately one year, with potential for extension. As a full-time employee of the consulting organization, you may transition to other client engagements afterward.

Future assignments may have different travel expectations, potentially up to 75% travel, while some other engagements are fully remote.

Candidates must be comfortable committing to the current biweekly travel schedule.

Compensation & Perks

As part of the team, you will be rewarded with the following:

• Competitive base salary of $110,000–$130,000, with flexibility for highly qualified candidates.
• Annual profit-sharing opportunity of approximately 5–10%, depending on level, paid in July.
• 401(k) matching.
• 25 days of annual paid time off.
• Supplemented medical, dental, and vision coverage.
• Reimbursement for eligible commuting, mobile phone, and home internet expenses.
• Choice of laptop, subject to client-specific security requirements.
• North America team-wide training and retreats.
• Sponsorship toward professional certifications and training, supported by five days of paid training time.
• Annual performance reviews and opportunities for professional advancement.