Back to jobs

Senior Data Engineer

Reads like an Analytics Engineer role: dbt models and clean tables.

Pay
USD 101,100–161,800/yearLocation-specific pay — pay source
Compensation The salary for this role will range from 101,100.00 - 161,800.00 USD annual based on full-time employment. Salary offers are based on a wide range of factors including but not limited to location, relevant skills, training, experience, education, etc. Certain roles may be eligible for performance-based incentive compensation and/or long-term incentives. Incentives could be discretionary or non-discretionary depending on the plan.
Read the full posting
Work setting
Remote — work setting source
Listed location: Remote - US
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Design and build the Snowflake transformation layer from raw to marts

  • Migrate legacy SQL views into versioned, tested dbt models with lineage

  • Define conformed dimensions and operational facts using Kimball modeling

  • Set modeling, testing, naming and CI/CD standards for the data team

  • Implement data quality testing, observability and lineage, including SOX controls

From the employer’s posting
Design and build the transformation layer in Snowflake (raw → staging → conformed → marts)
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
Implement data quality testing, observability, and lineage (dbt tests, Elementary, or equivalent), and partner with IT Audit on SOX-relevant controls for financial data flows.

Before you apply

Employer’s visa record
7 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Preferred experience

  • Hands-on experience with Power BI semantic models, DAX, and certified dataset patterns.
  • Familiarity with SOX ITGC and IT-audit controls for financial data lineage at a publicly traded company.
Qualification wording
Hands-on experience with Power BI semantic models, DAX, and certified dataset patterns.
Familiarity with SOX ITGC and IT-audit controls for financial data lineage at a publicly traded company.
Education & alternatives
Mentorship & Team Leadership - Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field; equivalent professional experience considered. - 7+ years in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse (Snowflake strongly preferred; BigQuery, Databricks, or Redshift considered with equivalent depth).
Apply at Novanta

Posting record

Report an error

Open 3 monthsWe first saw this posting 114 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 31, 2026114 days ago
Recorded sightings
206
Last seen by us
Nov 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$101K–$162K against $123K–$190K, the middle half of what similar US postings state.

From 342 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 114

Up longer than most. Similar jobs usually come down between day 7 and day 52.

From 1,781 similar postings that came down. Coming down is not always a hire.

Novanta is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Airbyte
  • Azure
  • BigQuery
  • Databricks
  • dbt
  • Fivetran
  • Informatica
  • Matillion
  • Power BI
  • Redshift
  • SAP
  • Snowflake
  • Airflow
  • Dagster
Where the posting names them
Summary The Senior Data Engineer owns Novanta’s governed transformation layer end-to-end. As a senior individual contributor, you will design and build the Snowflake transformation layer (raw → staging → conformed → marts), migrate legacy SQL views and user-maintained dimensions into versioned, tested dbt models with full lineage, and define the conformed dimensions and operational facts that unify our multi-ERP environment across the AET and Medical Solutions segments. You will set the modeling, testing, naming, documentation, and CI/CD standards that the future Data Engineer and MDM hires on this team will inherit. This role is hands-on; you should expect to spend most of your time in dbt, SQL, and Python rather than in meetings. About the team
- 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 — dbt macros, automation scripts, data quality frameworks, and lightweight API integration. You are not required to be a software engineer; you are required to write maintainable Python that solves data problems. - Direct experience modeling data sourced from at least one major enterprise ERP (Oracle, SAP S/4HANA, SAP ECC, Microsoft Dynamics, or comparable).
- Design and build the transformation layer in Snowflake (raw → staging → conformed → marts) as the governed foundation for all downstream reporting and AI/ML use cases. - Migrate existing SQL views to dbt-style versioned, tested models with full lineage. Conformed Dimensions & Dimensional Modeling
- 7+ years in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse (Snowflake strongly preferred; BigQuery, Databricks, or Redshift considered with equivalent depth). - Expert SQL—window functions, performance tuning, and incremental load patterns at scale. - 3+ years of dbt in production (or an equivalent transformation framework), including macros, generic and singular tests, snapshots, incremental strategies, exposures, and documentation. You have designed a dbt project from scratch and maintained it in production.
- Hands-on experience with Kimball dimensional modeling — 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.
- 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 — dbt macros, automation scripts, data quality frameworks, and lightweight API integration. You are not required to be a software engineer; you are required to write maintainable Python that solves data problems.
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field; equivalent professional experience considered. - 7+ years in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse (Snowflake strongly preferred; BigQuery, Databricks, or Redshift considered with equivalent depth). - Expert SQL—window functions, performance tuning, and incremental load patterns at scale.
- Define conformed dimensions and operational facts across Novanta’s multi-ERP environment using Kimball dimensional modeling principles — star schemas, surrogate keys, fact grain decisions, and SCD Type 1 and Type 2 patterns where appropriate. - Set modeling, testing, naming, documentation, and CI/CD standards for the team, including Git workflows, code review practices, dbt project structure, model contracts, and release management. BI Migration & Governance
- Partner with report owners and stakeholders to validate semantic equivalence and minimize disruption during cutover from past datasets. - Define and own the semantic layer where applicable (Snowflake Semantic layer, dbt Semantic Layer, Power BI semantic models) so that metric definitions are consistent across BI, AI, and embedded use cases. - Implement data quality testing, observability, and lineage (dbt tests, Elementary, or equivalent), and partner with IT Audit on SOX-relevant controls for financial data flows.
- Define and own the semantic layer where applicable (Snowflake Semantic layer, dbt Semantic Layer, Power BI semantic models) so that metric definitions are consistent across BI, AI, and embedded use cases. - Implement data quality testing, observability, and lineage (dbt tests, Elementary, or equivalent), and partner with IT Audit on SOX-relevant controls for financial data flows. AI / ML & Agentic Readiness
- Expert SQL—window functions, performance tuning, and incremental load patterns at scale. - 3+ years of dbt in production (or an equivalent transformation framework), including macros, generic and singular tests, snapshots, incremental strategies, exposures, and documentation. You have designed a dbt project from scratch and maintained it in production. - Hands-on experience with Kimball dimensional modeling — star schemas, conformed dimensions, fact grain decisions, surrogate keys, and SCD Type 1 and Type 2 patterns.
- Familiarity with SOX ITGC and IT-audit controls for financial data lineage at a publicly traded company. - Exposure to MDM tooling and processes (Reltio, Informatica MDM, Stibo, or comparable). Compensation
- Table-level experience with SAP ECC and/or S/4HANA finance and logistics tables (e.g., BSEG, BKPF, MARA, EKKO, VBAK). - 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.
- Proficient in Python for data tooling — dbt macros, automation scripts, data quality frameworks, and lightweight API integration. You are not required to be a software engineer; you are required to write maintainable Python that solves data problems. - 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—able to author standards, runbooks, and documentation that non-engineers can follow.
Preferred Qualifications - Table-level experience with SAP ECC and/or S/4HANA finance and logistics tables (e.g., BSEG, BKPF, MARA, EKKO, VBAK). - Hands-on experience with Power BI semantic models, DAX, and certified dataset patterns.
Transformation Layer Design & Build - Design and build the transformation layer in Snowflake (raw → staging → conformed → marts) as the governed foundation for all downstream reporting and AI/ML use cases. - Migrate existing SQL views to dbt-style versioned, tested models with full lineage.

Your next step

Complete your application on novanta.wd5.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Workday

  • You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
  • “Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
  • Your application status lives in that employer’s Candidate Home, under the same sign-in.

Already applied? Track this application

Job description

View original posting ↗

Build a career powered by innovations that matter!  At Novanta, our innovations power technology products that are transforming healthcare and advanced manufacturing—improving productivity, enhancing people’s lives and redefining what’s possible.  We create for our global customers engineered components and sub-systems that deliver extreme precision and performance for a range of mission-critical applications—from minimally invasive surgery to robotics to 3D metal printing.

Novanta is one global team with over 26 offices located in The Americas, Europe and Asia-Pacific.  Looking for a great place to work?  You have found it with a culture that embraces teamwork, collaboration and empowerment.  Come explore Novanta.

Summary

The Senior Data Engineer owns Novanta’s governed transformation layer end-to-end. As a senior individual contributor, you will design and build the Snowflake transformation layer (raw → staging → conformed → marts), migrate legacy SQL views and user-maintained dimensions into versioned, tested dbt models with full lineage, and define the conformed dimensions and operational facts that unify our multi-ERP environment across the AET and Medical Solutions segments. You will set the modeling, testing, naming, documentation, and CI/CD standards that the future Data Engineer and MDM hires on this team will inherit. This role is hands-on; you should expect to spend most of your time in dbt, SQL, and Python rather than in meetings.

About the team

Novanta’s Corporate & Shared Services team serves as a strategic partner to the company’s global business units, providing the expertise, systems, and infrastructure that enable growth, operational excellence, and innovation. Comprised of professionals across Finance, Accounting, Human Resources, Information Technology, Legal, Compliance, Corporate Development, and Corporate Marketing, the team collaborates closely with leaders across the organization to drive business performance, support strategic initiatives, enhance employee and customer experiences, and ensure the scalability of Novanta’s global operations

Transformation Layer Design & Build

  • Design and build the transformation layer in Snowflake (raw → staging → conformed → marts) as the governed foundation for all downstream reporting and AI/ML use cases.

  • Migrate existing SQL views to dbt-style versioned, tested models with full lineage.

Conformed Dimensions & Dimensional Modeling

  • Define conformed dimensions and operational facts across Novanta’s multi-ERP environment using Kimball dimensional modeling principles — star schemas, surrogate keys, fact grain decisions, and SCD Type 1 and Type 2 patterns where appropriate.

  • Set modeling, testing, naming, documentation, and CI/CD standards for the team, including Git workflows, code review practices, dbt project structure, model contracts, and release management.

BI Migration & Governance

  • Partner with report owners and stakeholders to validate semantic equivalence and minimize disruption during cutover from past datasets.

  • Define and own the semantic layer where applicable (Snowflake Semantic layer, dbt Semantic Layer, Power BI semantic models) so that metric definitions are consistent across BI, AI, and embedded use cases.

  • Implement data quality testing, observability, and lineage (dbt tests, Elementary, or equivalent), and partner with IT Audit on SOX-relevant controls for financial data flows.

AI / ML & Agentic Readiness

  • Design models with downstream AI/ML and agent consumption in mind: documented model contracts, stable surrogate keys, semantically clear column names, and metadata sufficient for LLM-based retrieval and tool use.

  • Partner with the AI/analytics team on feature-table patterns, golden-record exposure, and the data foundations required to support emerging agentic applications across Finance, Operations, and Commercial.

Mentorship & Team Leadership

  • Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field; equivalent professional experience considered.

  • 7+ years in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse (Snowflake strongly preferred; BigQuery, Databricks, or Redshift considered with equivalent depth).

  • Expert SQL—window functions, performance tuning, and incremental load patterns at scale.

  • 3+ years of dbt in production (or an equivalent transformation framework), including macros, generic and singular tests, snapshots, incremental strategies, exposures, and documentation. You have designed a dbt project from scratch and maintained it in production.

  • Hands-on experience with Kimball dimensional modeling — 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 — dbt macros, automation scripts, data quality frameworks, and lightweight API integration. You are not required to be a software engineer; you are required to write maintainable Python that solves data problems.

  • 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—able to author standards, runbooks, and documentation that non-engineers can follow.

  • Self-starter who thrives in a fast-paced, multi-ERP environment with minimal supervision and competing stakeholder priorities.

  • Experience supporting AI/ML, RAG, or agentic workloads from a warehouse layer (feature tables, embeddings, semantic metadata).

Preferred Qualifications

  • Table-level experience with SAP ECC and/or S/4HANA finance and logistics tables (e.g., BSEG, BKPF, MARA, EKKO, VBAK).

  • 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 at a publicly traded company.

  • Exposure to MDM tooling and processes (Reltio, Informatica MDM, Stibo, or comparable).

Compensation

  • The salary for this role will range from 101,100.00 - 161,800.00 USD  annual based on full-time employment. Salary offers are based on a wide range of factors including but not limited to location, relevant skills, training, experience, education, etc.

  • Certain roles may be eligible for performance-based incentive compensation and/or long-term incentives. Incentives could be discretionary or non-discretionary depending on the plan.

  • Novanta supports all aspects of your life’s needs. This position provides a full range of medical, financial, and other benefits to make your quality of life better

Travel Requirements

Occasional travel is required to Novanta global locations.

Physical Requirements

Mobility to work in a standard office setting and to use standard office equipment, including a computer. Ability to use vision to read a computer screen and read printed materials.

Novanta is proud to be an equal employment opportunity and affirmative action workplace. We consider all qualified applicants without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, military and veteran status, disability, genetics, or any other category protected by federal law or Novanta policy.

Please call +1 781-266-5700 if you need a disability accommodation for any part of the employment process.

About Novanta

People
About 3,000 in 2025, about the same as the year before.Annual report (SEC Form 10-K)
Company
Listed as NOVT.

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Compensation The salary for this role will range from 101,100.00 - 161,800.00 USD annual based on full-time employment. Salary offers are based on a wide range of factors including but not limited to location, relevant skills, training, experience, education, etc. Certain roles may be eligible for performance-based incentive compensation and/or long-term incentives. Incentives could be discretionary or non-discretionary depending on the plan.
Location & working pattern

Remote - US

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.