Embedded & Systems Software
$101,100 - $161,800 USD yearly
Design and build the Snowflake transformation layer.
Originally posted July 30, 2026 by the employer.
About the role
The Senior Data Engineer owns Novanta's governed transformation layer end-to-end, designing and building the Snowflake transformation layer (raw → staging → conformed → marts) and migrating legacy SQL views into versioned, tested dbt models.
What you'll do
- Design and build the transformation layer in Snowflake as the governed foundation for downstream reporting and AI/ML use cases.
- Migrate existing SQL views to dbt-style versioned, tested models with full lineage.
- Define conformed dimensions and operational facts across Novanta's multi-ERP environment using Kimball dimensional modeling principles.
- Set modeling, testing, naming, documentation, and CI/CD standards for the team, including Git workflows, code review practices, and release management.
- Implement data quality testing, observability, and lineage using dbt tests, Elementary, or equivalent.
- Design models with downstream AI/ML and agent consumption in mind, including documented model contracts and stable surrogate keys.
What you'll need
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field, or equivalent professional experience.
- 7+ years in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse (Snowflake, BigQuery, Databricks, or Redshift).
- Expert SQL proficiency, including window functions, performance tuning, and incremental load patterns at scale.
- 3+ years of dbt in production, including macros, generic and singular tests, snapshots, incremental strategies, exposures, and documentation.
- Hands-on experience with Kimball dimensional modeling, including star schemas, conformed dimensions, fact grain decisions, surrogate keys, and SCD Type 1 and Type 2 patterns.
- Production experience with at least one ingestion tool (Fivetran, Airbyte, Informatica, or Matillion) and one orchestrator (dbt Cloud, Airflow, Dagster, or Azure Data Factory).
- Hands-on Git and CI/CD for data (GitHub Actions, Azure DevOps Pipelines, or GitLab CI), including code review and release management practices.
- Proficient in Python for data tooling, including dbt macros, automation scripts, data quality frameworks, and lightweight API integration.
- Direct experience modeling data sourced from at least one major enterprise ERP (Oracle, SAP S/4HANA, SAP ECC, Microsoft Dynamics, or comparable).
- Strong written communication skills to author standards, runbooks, and documentation.
Nice to have
- Table-level experience with SAP ECC and/or S/4HANA finance and logistics tables.
- Hands-on experience with Power BI semantic models, DAX, and certified dataset patterns.
- Prior data engineering or analytics experience in manufacturing, medical devices, or another regulated industry.
- Familiarity with SOX ITGC and IT-audit controls for financial data lineage.
- Exposure to MDM tooling and processes (Reltio, Informatica MDM, Stibo, or comparable).
Skills: Snowflake, dbt models, dimensional modeling, data quality testing, CI/CD
Market context
- Employer posting date: 30 Jul 2026
- First seen in our index: 31 Jul 2026 (our observation date)
- Last confirmed on the employer's career site: 18 Nov 2026
- Specialty: Infrastructure/Platform Software (Infrastructure Platform)
- Comparable active jobs: 1056 at 98 employers, as of 18 Nov 2026
- Related specialties (Software, Firmware & Systems family): 6840 active jobs at 180 employers
How we counted: postings read from employer career sites; dates are our observations unless labelled as the employer's. How we count