Lead Snowflake Data Engineer

IDR, Inc.; Austin (TX); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Competitive compensation package

Full Benefits; Medical, Vision, Dental

Opportunity to join an industry-leading organization

Job summary

A leading healthcare consulting firm is seeking a skilled Lead Snowflake Data Engineer in Austin, TX. The role involves architecting and managing data solutions, leading a team of data engineers, and ensuring seamless integration of Snowflake within a cloud ecosystem. Candidates should have significant experience in data engineering and expertise in Snowflake Data Cloud. This position offers competitive pay, full benefits, and an opportunity to work within a close-knit team culture.

Qualifications

• 7+ years of experience in data engineering with Snowflake-focused initiatives.
• Leading or mentoring experience is required.
• Familiarity with CI/CD and DevOps practices is preferred.

Responsibilities

• Lead design and development of data pipelines in Snowflake.
• Oversee integration using Boomi and optimize data flows.
• Ensure governance and data quality practices are enforced.

Skills

Snowflake Data Cloud expertise

SQL proficiency

Python skills

Data governance knowledge

Data integration experience

Education

Bachelor’s degree in Computer Science or related field

Snowflake’s SnowPro Core Certification

Tools

Boomi Integration Platform

Azure Data Lake

Job description

Overview

We are looking for a skilled and experienced Lead Snowflake Data Engineer to join a top healthcare client in Austin, TX. The Snowflake Engineer will architect, design, and manage data solutions across a modern cloud ecosystem, focusing on integrating Azure Data Lake, Snowflake Data Cloud, Boomi Integration Platform, and OvalEdge Data Governance Platform into a cohesive, scalable, and governed data environment.

APPLY TODAY!

Responsibilities

• Snowflake Development & Architecture: Lead the design, development, and optimization of data pipelines, transformations, and data models within Snowflake.
• Implement and manage Snowpipe, Snowpark, and Streamlit for real-time ingestion, advanced analytics, and interactive applications.
• Architect data structures following bronze, silver, and gold layer principles, ensuring scalable and reliable data flows.
• Champion adoption of Data Lakehouse architecture, blending structured and unstructured data into an enterprise-ready solution.

• Data Integration & Orchestration: Oversee end-to-end data flows leveraging the Boomi Integration Platform, including orchestration, scheduling, and monitoring of ETL/ELT jobs.
• Ensure seamless integration between Azure Data Lake, Snowflake, and other enterprise applications.
• Collaborate with enterprise architects to optimize data movement patterns for performance and cost efficiency.

• Governance & Data Quality: Partner with data governance teams to operationalize data cataloging, lineage, and stewardship within OvalEdge.
• Define and enforce best practices for metadata management, access controls, and data lifecycle policies.
• Establish quality frameworks and monitoring to ensure trustworthy and compliant data delivery.

• Leadership & Collaboration: Lead a team of data engineers, providing technical guidance, mentoring, and code reviews.
• Partner with data analysts, data scientists, and business stakeholders to deliver solutions that meet business needs.
• Advocate for cloud-native best practices and emerging technologies that align with the enterprise data strategy.

Qualifications

• Bachelor’s degree in computer science, Information Systems, Data Management, or related field; or equivalent work experience
• 7+ years of experience in data engineering, with at least 3+ years leading Snowflake-focused initiatives
• Previous experience leading or mentoring a team as this role will act as a hands-on supervisor
• Deep expertise in Snowflake Data Cloud, including Snowpipe, Snowpark, and Streamlit
• Experience with Azure Data Lake (ADLS) and related services
• Hands-on experience with Boomi Integration Platform for data flows, orchestration, and automation. (experience with similar systems will be accepted, Informatica, Mulesoft, Talend, Fivetran)
• Strong SQL and Python skills; proficiency in building scalable and reusable data pipelines
• Snowflake’s SnowPro Core Certification
• Boomi certification (Professional Developer or higher) required within first 90 days. Access to training and certification available via Central Health.

• Preferred Qualifications: Experience with CI/CD and DevOps practices for data engineering (GitHub Actions, Azure DevOps, Terraform, DBT, Coalesce, Rivery, etc); knowledge of machine learning workflows and enabling analytics through Snowpark and external tools; familiarity with OvalEdge or similar data governance platforms (Collibra, Alation, Informatica); exposure to healthcare, financial services, or other highly regulated industries; Snowflake’s SnowPro Advanced: Data Engineer

What’s in it for you?

• Competitive compensation package
• Full Benefits; Medical, Vision, Dental, and more
• Opportunity to join an industry-leading organization
• Close-knit, team-oriented culture

Why IDR?

• 27+ years of proven industry experience in 4 major markets
• Medical, Dental, Vision, and Life Insurance
• ClearlyRated’s Best of Staffing Client and Talent Award winner 10 years in a row

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting

Referrals increase your chances of interviewing at IDR, Inc. Get notified about new Data Engineer jobs in Austin, TX.