waypointjobs

TECHNOLOGY PARTNERS INC

Principal Data Engineer (Snowflake & Azure Lakehouse | Technical Lead)

st. louis, MO

Check who can apply and the requirements below before continuing.

About this opportunity

TECHNOLOGY PARTNERS INC lists this Principal Data Engineer (Snowflake & Azure Lakehouse | Technical Lead) opportunity in st. louis, Missouri. Review the employer’s description below for duties, qualifications and application requirements.

Job description

Technology Partners is currently seeking a talentedPrincipal Data Engineer (Snowflake & Azure Lakehouse | Technical Lead).

Do you have experience leading large-scale Snowflake data architectures, building production-grade pipelines, and driving client-facing data engineering engagements?

Let us help you make your next big career move a reality!

What You Will Be Doing:

You will serve as the hands-on technical lead for a high-stakes, enterprise data modernization program focused on transforming large-scale claims data ingestion into a modern Snowflake + Azure lakehouse architecture. This is a delivery-critical role where you own the technical outcome, lead architecture decisions, build core pipelines, and act as the primary engineering voice with senior client stakeholders. You will operate in a fast-paced, high-visibility environment, balancing execution, leadership, and client engagement.

Key Responsibilities:

Lead the design and implementation ofend-to-end data architectureacross Snowflake and Azure environments

Build and deliver multipledata architecture patterns(Snowflake-native, hybrid Azure + Snowflake, event-driven ingestion, and notebook‑based workflows)

ImplementMedallion Architecture (Raw ? Silver ? Gold)with full lineage, governance, and promotion rules aligned with business definitions

Design and implementreal‑tim ingestion pipelinesusing Snowpipe, Event Grid, and secure file ingestion (e.g., PGP-encrypted sources)

Develop scalable pipelines for high-volume, multi-source data ingestion, transformation, and validation usingSnowpark (Python/Scala)

Build and optimizedbt Core modelsincluding transformations, testing, and data quality enforcement

Configure and manageAzure data services(ADLS Gen2, Azure Data Factory, Blob Storage, Private Endpoints, Managed Identity)

Develop and maintainoperational dashboardsfor monitoring pipeline health, SLA adherence, and data quality (targeting 99.5% uptime)

Leadclient-facing technical discussions, demos, and working sessionswith executive stakeholders

Translate complex technical decisions into clear business outcomes and data value narratives

Scope work, estimate delivery timelines, and manage technical risks and change requests

Lead and mentor supporting engineering resources while ensuring high-quality deliverables

Drive AI/ML integration initiatives includingSnowflake Cortex, Streamlit, and Azure AI services

Ensure all architecture, pipelines, and transformations are well-documented and production-ready

Required Skills & Experience:

5+ years of experience indata engineering, with at least 2+ years in atechnical lead or principal role

Deep, hands‑on expertise in: Snowflake architecture and optimization

Snowpark (Python/Scala)for pipeline development

Advanced SQL(complex transformations, performance tuning, schema design)

dbt Core(modeling, testing, incremental processing, source management)

Strong experience withAzure cloud ecosystem, including: ADLS Gen2, Azure Data Factory, Azure Functions

Event Grid, Blob Storage, Private Endpoints, Managed Identity

Proven experience buildingevent-driven and streaming data pipelines(e.g., Snowpipe)

Experience implementingMedallion/Lakehouse architecture patternsin production environments

Experience withdata governance tools(e.g., Microsoft Purview or equivalent)

Proven ability to operate inclient-facing consulting environments, managing stakeholders and delivering under pressure

Strong leadership, communication, and problem‑solving skills

Ability to balance speed of delivery with system reliability and scalability

Desired Skills & Experience:

Experience withAI/ML integration on data platforms(Snowflake Cortex, Streamlit, Azure AI Foundry, or similar)

Exposure toPGP/GPG encryption workflowsin automated pipelines

Familiarity withIceberg table formatsor modern table storage frameworks

Experience buildinglightweight data applications or UI layers(e.g., Streamlit)

Domain knowledge ininsurance, claims, or TPA data ecosystems

Experience scaling data platforms across multiple business domains

Advanced degree in Computer Science, Data Engineering, or related quantitative field

Pay:

$87.50 - $125.00 /hr.

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to provide sponsorship at this time or accept candidates who would require a corp-to-corp agreement.

If this position sounds like you,WE SHOULD TALK!

Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!

Keywords:

Principal Data Engineer, Snowflake, Snowpark, Azure, ADLS Gen2, Data Lakehouse, Medallion Architecture, dbt Core, SQL, Python

Looking for more opportunities with Technology Partners? Check out technologypartners.net/jobs!

All offers of employment at Technology Partners are contingent upon clear results of a thorough background check and drug screening that meet corresponding laws and regulations at the city, state and federal level.

Pay ranges are influenced by candidate qualifications, experience, and role specifics, with the actual rate determined considering skills, market conditions, and are subject to change by the employer; pay negotiations follow all state and federal legal guidelines.

#J-18808-Ljbffr

Worksite address

st. louis, MO, 63146, US

Who can apply

Review the original listing for work authorization, qualifications and employer requirements.

Ready for your next step?Apply on the official website
Apply on WhatJobs ↗

Explore related searches

Current related jobs

Transportation Security Administration

USAJOBS

IT SPECIALIST (DATAMGT)

Annapolis Junction, MD

$121,785.00 – $187,093.00 per yearfull time

This position is located in the Enterprise Technology & Data | Data and AI Division. The incumbent serves as IT Specialist (DATAMGT) for the Data…

Closing date 2026-10-21View job

Air Force Services Agency

USAJOBS

IT Specialist (System Developer/Data Integration)

Kelly AFB, TX

$40.00 – $48.00 per hourfull time

This position is Non-appropriated Fund (NAF) will be assigned to the Air Force Services Center at Port San Antonio, TX. This is a regular full-ti…

Closing date 2026-11-05View job

Deputy Assistant Secretary for Information and Technology

USAJOBS

IT Specialist (Systems Admin)

Philadelphia County, PA · Austin, TX

$63,795.00 – $99,404.00 per yearfull time

Deliver secure and high availability infrastructure solutions supporting VA's mission. Serve as an operational service provider of foundational c…

Closing date 2026-10-26View job

Transportation Security Administration

USAJOBS

IT SPECIALIST (DATAMGT)

Annapolis Junction, MD

$121,785.00 – $187,093.00 per yearfull time

This position is located in the Enterprise Technology & Data | Data and AI Division. The incumbent serves as IT Specialist (DATAMGT) for the Data…

Closing date 2026-10-21View job

Army National Guard Units

USAJOBS

IT SPECIALIST (NETWORK/SYSADMIN) (TITLE 32)

Draper, UT

$75,278.00 – $97,867.00 per yearfull time

This National Guard position is for a IT SPECIALIST (NETWORK/SYSADMIN) (TITLE 32), Position Description Number D2727000 and is part of the G4, lo…

Closing date 2026-10-29View job

Administrative Office of the U.S. Courts

USAJOBS

Information Technology Specialist (Security)

Washington, DC

$121,785.00 – $197,200.00 per yearfull time

This position is located in the Defender Services Office (DSO) and will provide support to the Office Chief, Defender Services IT Program Officer…

Closing date 2026-10-29View job