Senior Data Engineer
Novanta Inc.3 months ago
Remote, United StatesSenior
Base Salary
$101k - $162k/yr
Responsibilities
- Design and build Snowflake transformation layers spanning raw, staging, conformed, and marts layers.
- Migrate legacy SQL views and user-maintained dimensions into versioned, tested dbt models with full lineage.
- Define conformed dimensions, operational facts, star schemas, surrogate keys, fact grain decisions, and SCD Type 1 and Type 2 patterns across a multi-ERP environment.
- Establish modeling, testing, naming, documentation, CI/CD, Git workflow, code review, model contract, and release management standards.
- Partner with report owners and stakeholders on BI migration, semantic equivalence, and dataset cutover.
- Define semantic layers using Snowflake Semantic Layer, dbt Semantic Layer, and Power BI semantic models where applicable.
- Implement data quality testing, observability, and lineage using dbt tests, Elementary, or equivalent tools.
- Partner with IT Audit on SOX-relevant controls for financial data flows and lineage.
- Design warehouse models and metadata for AI/ML, RAG, feature-table, golden-record, LLM retrieval, and agentic application use cases.
- Mentor future Data Engineer and MDM hires and document standards, runbooks, and practices.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field, with equivalent professional experience considered.
- 7+ years of experience in data engineering or analytics engineering, including 4+ years building production workloads on a cloud data warehouse.
- Expert SQL skills including window functions, performance tuning, and incremental load patterns at scale.
- 3+ years of production dbt experience or equivalent transformation framework experience, including macros, tests, snapshots, incremental strategies, exposures, and documentation.
- Experience designing a dbt project from scratch and maintaining it in production.
- Hands-on Kimball dimensional modeling experience with 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 and one orchestrator.
- Hands-on Git and data CI/CD experience, including code review and release management.
- Proficiency in Python for data tooling, automation, data quality frameworks, and lightweight API integration.
- Experience modeling data from a major enterprise ERP such as Oracle, SAP S/4HANA, SAP ECC, or Microsoft Dynamics.
- Strong written communication and ability to create standards, runbooks, and documentation for non-engineers.
- Experience supporting AI/ML, RAG, or agentic workloads from a warehouse layer.
- Preferred experience with SAP ECC or S/4HANA finance and logistics tables, Power BI semantic models, DAX, and certified dataset patterns.
- Preferred experience in manufacturing, medical devices, or another regulated industry; SOX ITGC and IT-audit controls; and MDM tools and processes.
Benefits
- Full range of medical, financial, and other benefits is provided.
- This is a full-time position with an annual salary range of 101,100.00 - 161,800.00 USD.
- Occasional travel to Novanta global locations is required.
- The role is based in a standard office setting and requires use of standard office equipment.
Tech Stack
Categories
Data Engineering
About Novanta Inc.
Novanta Inc. designs and manufactures precision photonics, motion control, vision, and laser subsystems used by medical, life‑science, and advanced industrial OEMs. Its products support applications from minimally invasive surgery and robotics to 3D metal printing, sold as engineered components and integrated sub-systems to equipment makers. The company is headquartered in Bedford, Massachusetts and is publicly traded on Nasdaq under the ticker NOVT, with global operations across the Americas, Europe, and Asia‑Pacific.