Required skills
- Snowflake
- dbt
- SQL
- Data Vault 2.0
- Medallion Architecture
- Dimensional Modeling
- Snowpipe
- Snowflake Streams
- Snowflake Tasks
Languages: English
Job description
Project overview
To Apply for this Job Click Here
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.
- 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
Requirements
What’s in it for you?
Why IDR?
#LI-Hybrid
IDR is an equal opportunity employer. We provide reasonable accommodations for disabled employees and do not discriminate based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, criminal history, or any other protected category under applicable federal, state, or local laws. We consider all qualified applicants, including those with criminal histories, in compliance with applicable Fair Chance laws.
To comply with civil rights laws, we invite applicants to voluntarily self-identify their race, ethnicity, gender, and veteran status. This information is confidential, optional, and will not affect your application. You may access this form here.
Pursuant to pay transparency laws, salary ranges and benefits will be disclosed where required by law. Compensation is based on factors such as experience, skills, and qualifications.
If you require a reasonable accommodation during the application or interview process, please contact Human Resources.
To Apply for this Job Click Here
- 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
- Competitive compensation package
- Full Benefits; Medical, Vision, Dental, and more!
- Opportunity to get in with an industry leading organization.
- 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.
Project details
- Start: flexible
- Remote: hybrid
- Location: Richardson, Texas, US
- Rate: 55-60 EUR/h
- Languages: English
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on jobs.idr-inc.com