Snowflake Data Engineer
Posted
Description
IDR is seeking a Snowflake Data Engineer to join one of our top clients for an opportunity in Richardson, Texas. In this role, you will help modernize and scale an enterprise data platform by building reliable ELT pipelines and optimizing a cloud data warehouse environment. The ideal candidate is comfortable partnering with technical stakeholders to deliver trusted, analytics-ready data using modern engineering and modeling practices.
Position Overview for the Snowflake Data Engineer:
Position Overview for the Snowflake Data Engineer:
- Build and enhance scalable ELT pipelines to support enterprise reporting and analytics initiatives
- Develop and optimize Snowflake data warehouse solutions, including performance tuning and operational automation
- Create modular transformation frameworks using dbt (models, macros, testing, and incremental processing)
- Implement modern data modeling approaches such as Data Vault 2.0 and/or Medallion (Bronze/Silver/Gold) architecture
- Collaborate with engineers and stakeholders to improve data quality, reliability, and maintainability across datasets
- 7+ years' hands-on data engineering experience building, managing, and optimizing Snowflake data warehouses, including performance tuning, streams, tasks, and Snowpipe
- Must have at least 2+ years' production-level experience developing ELT pipelines using dbt Core or Cloud, including models, macros, incremental processing, and testing.
- Expert-level SQL development, including complex queries, CTEs, window functions, data transformations, and performance optimization.
- Hands-on experience with Data Vault 2.0 and/or Medallion Architecture, including Bronze, Silver, and Gold layers, dimensional modeling, and star schemas
- Experience with at least one legacy platform (Informatica, DataStage, Teradata, SQL Server, or Oracle), ideally involving migrations to Snowflake
What's in it for you?
- Competitive compensation package
- Full Benefits; Medical, Vision, Dental, and more!
- Opportunity to get in with an industry leading organization.
Why IDR?
- 25+ Years of Proven Industry Experience in 4 major markets
- Employee Stock Ownership Program
- Dedicated Engagement Manager who is committed to you and your success.
- Medical, Dental, Vision, and Life Insurance
- ClearlyRated's Best of Staffing® Client and Talent Award winner 12 years in a row.
Skills
Sign in to read and join the discussion.