[Hiring] Senior Data Engineer @Novanta Inc.

Role Description

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.
• Define the conformed dimensions and operational facts that unify our multi-ERP environment across the AET and Medical Solutions segments.
• Set the modeling, testing, naming, documentation, and CI/CD standards for the team.
• Expect to spend most of your time in dbt, SQL, and Python rather than in meetings.

Qualifications

• 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).
• Expert SQL—window functions, performance tuning, and incremental load patterns at scale.
• 3+ years of dbt in production (or an equivalent transformation framework).
• Hands-on experience with Kimball dimensional modeling.
• Production experience with at least one ingestion tool and one orchestrator.
• Hands-on Git and CI/CD for data.
• Proficient in Python for data tooling.
• Direct experience modeling data sourced from at least one major enterprise ERP.
• Strong written communication skills.
• Self-starter who thrives in a fast-paced, multi-ERP environment.
• Experience supporting AI/ML, RAG, or agentic workloads from a warehouse layer.

Requirements

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

Benefits

• The salary for this role will range from 101,100.00 - 161,800.00 USD annual based on full-time employment.
• Performance-based incentive compensation and/or long-term incentives may be available.
• Full range of medical, financial, and other benefits to enhance quality of life.

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.