Snowflake Data Engineer
Location: Austin, TX
Job Type: Contract To Hire
Company: IDR
Category: Development and Architecture
Job Description Apply Now
Snowflake Data Engineer Job OverviewWe are seeking a detail-oriented and highly skilled Snowflake Data Engineer to join our team on a full-time basis in Austin, TX. As a Snowflake Data Engineer, you will play a key role in designing, developing, and maintaining scalable data solutions within the Snowflake Data Cloud platform. You will collaborate with cross-functional teams to build robust data pipelines, optimize storage and processing, and support analytics and business intelligence initiatives for a leading healthcare organization. Working in Austin, TX provides a vibrant tech community and access to innovative projects in the healthcare sector.
Key Responsibilities- Snowflake Architecture & Development
- Design and implement Snowflake data warehouses, databases, and schemas to meet organizational requirements.
- Develop ETL/ELT pipelines for efficient data ingestion, transformation, and loading into Snowflake.
- Optimize virtual warehouses, storage, and query performance to ensure high availability and reliability.
- Data Integration & Pipeline Management
- Integrate data from diverse sources including APIs, databases, and cloud storage into Snowflake.
- Utilize Snowpipe, Snowflake Tasks, Streams, and Stored Procedures to automate data workflows.
- Work with tools such as Kafka, Spark, Airflow, or Fivetran for real-time and batch data processing.
- Performance Tuning & Optimization
- Monitor, analyze, and optimize query performance through clustering, partitioning, and use of materialized views.
- Implement advanced features such as data sharing, zero-copy cloning, and time travel for data management.
- Manage resources effectively, including warehouse sizing, auto-suspend features, and scaling practices.
- Security & Governance
- Configure Role-Based Access Control (RBAC) and enforce data security policies to meet compliance standards.
- Ensure data masking, encryption, and compliance with GDPR and HIPAA regulations.
- Implement data lineage tracking and metadata management for transparency and governance.
- Collaboration & Analytics Enablement
- Partner with data analysts, data scientists, and business intelligence teams to deliver clean and structured data sets.
- Support seamless integration of Snowflake with BI tools such as Tableau, Power BI, and Looker.
- Document data models, pipeline designs, and best practices for ongoing knowledge sharing and improvement.
- Minimum 5 years of experience in data engineering, with at least 3 years focused on Snowflake architecture, SQL, stored procedures, and UDFs.
- Proficiency in SQL, Python, or Java for complex data transformations and pipeline development.
- Hands-on experience with cloud platforms such as AWS, Azure, or GCP, and familiarity with data lakes like S3 and ADLS.
- Strong knowledge of data modeling concepts, including star schema and snowflake schema designs.
- Experience with CI/CD, Git, and DevOps practices specifically for data pipelines and workflow automation.
- SnowPro Core Certification
- SnowPro Advanced: Data Engineer Certification
- AWS, Azure, or GCP Data Engineering Certifications
- Competitive compensation package
- Comprehensive benefits including medical, vision, dental, and life insurance
- Opportunity to join an industry-leading organization with a close-knit, team-oriented culture
- Work in a dynamic, growing healthcare environment in Austin, TX
- Over 27 years of proven industry experience across four major markets
- Consistent recipient of ClearlyRated’s Best of Staffing® Client and Talent Award for 10 consecutive years
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite employees to voluntarily self-identify their race or ethnicity, gender, and veteran status (if applicable). Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. You may access this form here.