Novanta

Novanta

Senior Data Engineer

Remote - US · Senior · Full-time

Sponsorship not specified$101k-$162kDetected 1 day ago
PythonCode ReviewGitSQLBigQuerySnowflakeRedshiftDatabricksAzureCI/CDGitHub ActionsDevOpsMachine LearningAirflowdbtData EngineeringData VisualizationLLMsRAGComplianceAccountingSAPLogisticsERP

> stay_score

odds of building a lasting career here

54Sponsors, lottery-bound
Cap-exempt (no lottery)0
Sponsors this role80
Entry-level history0
PERM / green-card track0
Lottery odds (Level III)83
Fits your clock70

Sponsors, but it's cap-subject — you still face the weighted lottery (~45% per draw at Level III). Good if you win; have a cap-exempt backup on your list.

Lottery odds assume a STEM candidate.

Personalize to your clock →

> community_outcomes

No reports yet — be the first to help the next applicant.

About the role

  • 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.

Responsibilities

  • 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.
  • 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.
  • 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.
  • Novanta supports all aspects of your life's needs.

Requirements

  • You have found it with a culture that embraces teamwork, collaboration and empowerment.
  • 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.
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field
  • Occasional travel is required to Novanta global locations.

Nice to have

  • 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.
  • 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).
  • 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.
  • BigQuery, Databricks, or Redshift considered with equivalent depth).

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.

Benefits

  • Ability to use vision to read a computer screen and read printed materials.
  • This position provides a full range of medical, financial, and other benefits to make your quality of life better

Company info

  • 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.
  • 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).

Equal opportunity

  • Novanta is proud to be an equal employment opportunity and affirmative action workplace.
  • Please call +1 781-266-5700 if you need a disability accommodation for any part of the employment process.
Apply directly at Novanta →Create a free account for alerts like thisView Novanta immigration profile

This listing is sourced directly from Novanta's careers page and normalized into a canonical job model.