Data Analytics Engineer

Build a career powered by innovations that matter! At Novanta, our innovations power technology products that are transforming healthcare and advanced manufacturing—improving productivity, enhancing people’s lives and redefining what’s possible.
We create for our global customers engineered components and sub-systems that deliver extreme precision and performance for a range of mission-critical applications—from minimally invasive surgery to robotics to 3D metal printing.
Novanta is one global team with over 26 offices located in The Americas, Europe and Asia-Pacific.
Looking for a great place to work? You have found it with a culture that embraces teamwork, collaboration and empowerment.
Come explore Novanta.
This position is part of Novanta’s Corporate and Shared Services global teams.
Novanta’s Corporate and Shared Services teams play an important role in executing the company’s strategic mission and operations.
Included in Corporate and Shared Services are the business functions including Finance, Accounting, Human Resources, Information Technology, Legal, Compliance, Corporate Development and Corporate Marketing.
The Corporate and Shared Services teams work closely with all Novanta business units to support operating initiatives contributing to the organization’s financial success.
Job Summary As a Data Analytics Engineer, you will be responsible for building and maintaining the data layer for our analytics stack, top to bottom.
Your role will span multiple disciplines from data engineering to data analytics and visualization across all stages of data maturity for the purpose of delivering robust Business Intelligence solutions.
You will consider software engineering best practices including version control, automated testing, documentation, code review and continuous integration, as essential to any data stack.
Primary Responsibilities Design, develop and maintain scaled, automated, user-friendly systems, reports, dashboards, etc.
Write complex, production-quality (i.
e.
, accurate, performant, and maintainable) data transformation code to solve the needs of analysts, and business stakeholders (ex.
MS SQL Server, Oracle, and Snowflake) Analyze assigned projects for data quality issues.
Troubleshoot and resolve issues as they arise.
Automate standard report creation and sharing using tools or scripts Convert raw data into consumable information applying business logic and utilizing clean engineering workflows Ensure that data, systems, architecture, business logic, and metrics are well-documented Support the acquisition of external data sets, interpreting data layouts, structures, fields, and values to incorporate new data into the core analytics database Serve as a catalyst for sharing knowledge, information, and ideas throughout the company as it relates to business intelligence Interface with business customers to gather data and metrics requirements, then driving analytic projects to solve complex challenges Draw insights from data and clearly communicate findings to stakeholders and external customers Provide exceptional customer service to stakeholders through project execution and timely delivery of solutions Required Experience, Education, Skills and Competencies Bachelor’s degree in Information Technology preferred or relevant experience.
3+ years - Experience with MS SQL Server and Snowflake 3+ years - Experience with ETL/ELT Tools (ex.
Mulesoft, API, Informatica) 3+ years - Experience using Power BI, Tableau, or similar data visualization tool Expert SQL Fluency (Well versed in CTEs and window functions) Demonstrated ability in data modeling, ETL/ELT, data pipelines, EDW Experienced building data warehouse infrastructure and BI tables Motivated individual with strong analytic, problem solving, and troubleshooting skills Travel Requirements Less than 20% Compensation and Benefits The base pay for this position ranges from $90,000 to $120,000 depending on the geographic market Dependent on the position offered, annual bonuses and other forms of compensation may be provided as part of the compensation package.
Novanta supports all aspects of your life.
This position provides a full range of benefits including paid parental and family leave.
Novanta is proud to be an equal employment opportunity and affirmative action workplace.
We consider all qualified applicants without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, military and veteran status, disability, genetics, or any other category protected by federal law or Novanta policy.
Please call +1 781-266-5700 if you need a disability accommodation for any part of the employment process.