Senior Data Engineer — Snowflake & dbt Transformation

Novanta Inc.; United States; Remote; USD 101.000 - 162.000; Vollzeit

Zusammenfassung

Novanta Inc. is seeking a Senior Data Engineer in the United States to own the Snowflake transformation layer end-to-end, migrating legacy SQL views to dbt models with full lineage and defining conformed dimensions across a multi-ERP environment.

You will establish modeling, testing, naming, documentation, and CI/CD standards for the team, working with BI, governance, and AI/ML readiness to ensure scalable data pipelines and trusted data across the organization.

Qualifikationen

• 7+ years in data engineering or analytics engineering

Aufgaben

• Own Snowflake transformation layer end-to-end (raw → staging → conformed → marts)
• Migrate legacy SQL views to versioned, tested dbt models with full lineage
• Define conformed dimensions and operat ional facts across multi-ERP environment
• Set modeling, testing, naming, documentation, and CI/CD standards for the team

Kenntnisse

SQL

dbt

Python

Git & CI/CD

Dimensional modeling

Snowflake

Data warehousing

Clear communication

Ausbildung

Bachelor’s degree in Computer Science / Information Systems / Data Engineering or related field

Tools

Fivetran

Airbyte

Informatica

Matillion

dbt Cloud / Airflow

Jobbeschreibung

Novanta Inc. is seeking a Senior Data Engineer in the United States to own the Snowflake transformation layer end-to-end, migrating legacy SQL views to dbt models with full lineage and defining conformed dimensions across a multi-ERP environment.

You will establish modeling, testing, naming, documentation, and CI/CD standards for the team, working with BI, governance, and AI/ML readiness to ensure scalable data pipelines and trusted data across the organization.