IDR, Inc.

IDR is seeking a Data Engineer to join one of our top clients in Pennington, NJ. This role is perfect for a seasoned professional with a strong background in data engineering, looking to leverage their skills in a dynamic and collaborative environment. If you are passionate about data modeling, transformation pipelines, and optimizing performance, we encourage you to apply today!

Position Overview/Responsibilities for the Data Engineer:- Design and implement scalable data models and transformation pipelines using DBT on Snowflake- Write efficient and maintainable PL/SQL code for complex data processing and transformation tasks- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver high-quality solutions- Optimize Snowflake performance through query tuning, clustering, and resource management- Ensure data quality, integrity, and governance through testing, documentation, and monitoring- Participate in code reviews, architecture discussions, and continuous improvement initiatives- Maintain and enhance CI/CD pipelines for DBT projectsRequired Skills for Data Engineer:- 8+ years experience in data engineering or a related field- Strong hands-on experience with DBT (modular SQL development, testing, documentation)- Proficiency in Snowflake (data warehousing, performance tuning, security)- Advanced knowledge of PL/SQL and experience with stored procedures, functions, and packages- Solid understanding of data modeling concepts (star/snowflake schemas, normalization)- Experience with version control systems (e.g., Git) and CI/CD practices- Familiarity with orchestration tools (e.g., Airflow, dbt Cloud, Prefect) is a plusWhat’s in it for you?- Competitive compensation package- Full Benefits; Medical, Vision, Dental, and more!- Opportunity to get in with an industry leading organization- Close-knit and team-oriented cultureWhy IDR?- 25+ Years of Proven Industry Experience in 4 major markets- Employee Stock Ownership Program- Medical, Dental, Vision, and Life Insurance- ClearlyRated's Best of Staffing® Client and Talent Award winner 11 years in a row;