Senior Data Engineer

Job not on LinkedIn

🔥 13 hours ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Novanta Inc.

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

🏥 Healthcare

📦 Logistics

💼 Consulting

Healthcare • Logistics • Consulting

Novanta Inc. is a leading technology company that provides mission-critical solutions in the Medical and Advanced Industrial markets. With over 30 years of experience, Novanta partners with original equipment manufacturers (OEMs) worldwide offering a wide range of products including medical devices, precision motion systems, laser and beam steering technologies, as well as machine vision components. The company is known for its innovation, providing intelligent and reliable solutions in precision motion, laser processing, robotics, and automation technologies. Novanta serves principal markets in North America, Europe, and Asia Pacific, and is a publicly traded company on Nasdaq under the ticker symbol 'NOVT'.

📋 Description

• 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. • 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, dbt project structure, model contracts, and release management. • Partner with report owners and stakeholders to validate semantic equivalence and minimize disruption during cutover from past datasets. • Implement data quality testing, observability, and lineage, and partner with IT Audit on SOX-relevant controls for financial data flows. • Design models with downstream AI/ML and agent consumption in mind, including documented model contracts and stable surrogate keys. • Mentor and lead the team by setting standards and guiding junior members.

🎯 Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related 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 equivalent transformation framework), including macros, generic and singular tests, snapshots, incremental strategies, exposures, and documentation. • 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. • 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 thriving in a fast-paced, multi-ERP environment with minimal supervision.

🏖️ Benefits

• full range of medical benefits • financial benefits • other benefits to improve quality of life