Senior Data Engineer

🕒 il y a 7 jours

Postuler Maintenant

Trouver des Emplois à Distance Similaires

Configurer une alerte email pour les nouveaux emplois

📊 Vérifiez votre score de CV pour ce poste

Améliorez vos chances d'obtenir un entretien en vérifiant votre score de CV avant de postuler.

Télécharger le CV

Novanta Inc.

Site WebLinkedInTous les Emplois

1001 - 5000 employés

🏥 Santé

📦 Logistique

💼 Conseil

Healthcare • Logistics • Consulting

Novanta Inc. est une entreprise technologique de premier plan fournissant des solutions essentielles pour les marchés médicaux et industriels avancés. Avec plus de 30 ans d'expérience, Novanta collabore avec des fabricants d'équipements d'origine (OEM) dans le monde entier pour offrir une large gamme de produits, y compris des dispositifs médicaux, des systèmes de mouvement de précision, des technologies de laser et de guidage de faisceaux, ainsi que des composants de vision industrielle. L'entreprise est reconnue pour son innovation, fournissant des solutions intelligentes et fiables dans les technologies de mouvement de précision, de traitement laser, de robotique et d'automatisation. Novanta dessert principalement les marchés d'Amérique du Nord, d'Europe et d'Asie-Pacifique, et est cotée en bourse sur le Nasdaq sous le symbole '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.

🎯 Exigences

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

🏖️ Avantages

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