Job description

Position: DBT Lead Developer "Snowflake" Location: ["Remote” Elmwood Park, NJ] Duration: 6-12+ Months Contract We are looking for a skilled and motivated DBT Developer with a strong foundation in ELT processes to join our data team. The role requires hands-on experience with DBT and SQL to build, transform, and model data. Experience working with Snowflake and modern data pipelines will be key to success in this role. Responsibilities: • Design, develop and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting. • Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency. • Design, develop, and maintain ETL/ELT pipelines using DBT for loading data into Snowflake. • Implement data tests, documentation, quality checks and validation processes to ensure data accuracy and consistency. • Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units. Required Skills: • Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience. • Proven experience as a DBT Developer or similar role with a focus on ELT processes and Snowflake data warehousing. • Strong command of SQL for data manipulation, querying, and transformation. • Hands-on experience building and managing data models, transformations, and views using DBT. • Familiarity with cloud-based Data Warehousing solutions, particularly Snowflake. • Excellent problem-solving skills and attention to detail in ensuring data accuracy and quality. • Effective communication skills to collaborate with technical and non-technical stakeholders. • Ability to work independently and as part of a team in a fast-paced, dynamic environment. • Prior experience in optimizing and troubleshooting data processes for performance and reliability. Nice to Have: • Experience with Matillion. • Basic Python knowledge. • Experience with cloud platforms (AWS/Azure)

Requirements

Must-haves

Position: DBT Lead Developer "Snowflake"
Location: ["Remote” Elmwood Park, NJ]
Duration: 6-12+ Months Contract
Design, develop and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting.
Build complex SQL queries within DBT to build incremental models, enhancing data processing efficiency.
Design, develop, and maintain ETL/ELT pipelines using DBT for loading data into Snowflake.
Implement data tests, documentation, quality checks and validation processes to ensure data accuracy and consistency.
Collaborate with data engineers, data analysts, and other stakeholders to understand and meet data requirements for various business units.
Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
Proven experience as a DBT Developer or similar role with a focus on ELT processes and Snowflake data warehousing.
Strong command of SQL for data manipulation, querying, and transformation.
Hands-on experience building and managing data models, transformations, and views using DBT.
Familiarity with cloud-based Data Warehousing solutions, particularly Snowflake.
Excellent problem-solving skills and attention to detail in ensuring data accuracy and quality.
Effective communication skills to collaborate with technical and non-technical stakeholders.
Ability to work independently and as part of a team in a fast-paced, dynamic environment.
Prior experience in optimizing and troubleshooting data processes for performance and reliability.

Nice-to-haves

Experience with Matillion.
Basic Python knowledge.
Experience with cloud platforms (AWS/Azure)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonawsazure

Platform: jobdiva
Effort: medium