DBT Lead for Teradata-to-Snowflake Migration (Remote)

MassGenics, Inc.; New York (NY); Hybrid; USD 83,000 - 90,000; Full time

Benefits offered by this job

Medical & pharmacy coverage

Dental/vision insurance

401(k)

Job summary

Innova Solutions is seeking a DBT (data build tool) Developer Lead for a remote, full-time contract in the United States. You will lead DBT development, design and maintain models, and drive the Teradata to Snowflake migration with a focus on modular, tested SQL.

Collaborating with data engineering, analytics, and business teams, you’ll ensure accurate data delivery, apply best practices, and document transformations while leveraging Git for version control.

Qualifications

• Hands-on experience with DBT development.
• Strong proficiency in SQL and data modeling.
• Experience with DBT core concepts and workflow.
• Understanding of data warehousing principles.
• Experience working with cloud platforms.
• Ability to write modular, reusable, and tested code.
• Familiarity with Git and version control tools.
• Experience with Teradata to Snowflake migration.

Responsibilities

• Lead and support DBT development for the Teradata to Snowflake migration.
• Design, build, and maintain DBT models, transformations, and workflows.
• Develop modular, reusable, and tested SQL-based code.
• Perform data modeling and support data warehouse design.
• Write and optimize SQL for data transformation and analytics.
• Apply DBT best practices including testing, documentation, and workflow management.
• Partner with data engineering, analytics, and business teams to ensure accurate data delivery.
• Validate migrated data and troubleshoot transformation issues.

Skills

DBT development

SQL

Data modeling

DBT concepts

Cloud platforms

Modular code

Git

Migration (Teradata to Snowflake)

Tools

Snowflake

Teradata

Git

Job description

Innova Solutions is seeking a DBT (data build tool) Developer Lead for a remote, full-time contract in the United States. You will lead DBT development, design and maintain models, and drive the Teradata to Snowflake migration with a focus on modular, tested SQL.

Collaborating with data engineering, analytics, and business teams, you’ll ensure accurate data delivery, apply best practices, and document transformations while leveraging Git for version control.