Data Engineer

Novisto; Montreal; Hybrid; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Generous health benefits

Flexible schedules

4 weeks of vacation

Summer hours

Office in Old Montreal

Job summary

A sustainable data management company in Montreal is seeking a skilled Data Engineer. The ideal candidate will have a strong background in data architecture, SQL, and Python. Responsibilities include monitoring data integrity, developing internal tools, and collaborating with development teams. This position offers generous health benefits, flexible work schedules, and a vibrant work environment in Old Montreal.

Qualifications

• Minimum 5 years of experience as a Data Engineer or Database Administrator.
• Strong expertise in SQL, including optimizing and debugging queries.
• Experience with automation and data integrity monitoring.

Responsibilities

• Assist development teams with data model changes and migrations.
• Develop automation for data integrity monitoring and repair.
• Help identify performance issues and propose solutions.

Skills

Data architecture and modeling

SQL optimization

Python programming

Experience with PostgreSQL

Version control (Git)

Unix-based OS proficiency

Detail-oriented

Team collaboration

Education

Bachelor’s degree in Software Engineering, Computer Science, or Mathematics

Tools

PostgreSQL

SQLAlchemy

Alembic

Go programming

Snowflake

Job description

Overview

We are seeking a skilled and detail-oriented Data Engineer to join our team. This role is critical to ensuring the reliability, performance, and scalability of our data systems. The ideal candidate has a strong background in database management and performance optimization, along with a collaborative mindset to support cross-functional development teams. In this role, you will help maintain data integrity on existing datasets, push performance improvements, develop new data automation, and assist in data corrections on deployed environments.

Responsibilities

• Review and assist development teams in data model changes and data migrations
• Develop automation for data integrity monitoring and repair
• Develop new internal tools to audit and safely modify existing datasets
• Analyse data to find data integrity issues and help resolve the issues
• Perform data corrections on deployed environments based on tickets raised by customer service and internal clients
• Help identify performance issues and assist the development teams in proposing and implementing solutions
• Advise on a solution for integrations with data pipelines coming from clients and other third-party sources
• Maintain and enforce data and database security controls
• Report any risk, incident, or anomalous situation that could affect the security of Novisto or our clients\' data

What we’re looking for

• Minimum 5 years of experience as a Data Engineer or Database Administrator
• Bachelor’s degree in Software Engineering, Computer Science, Mathematics, or equivalent experience and education
• Strong experience with data architecture and modeling
• Experience with large relational databases (PostgreSQL preferred)
• Strong expertise in SQL (writing, optimizing, and debugging complex queries)
• 3+ years of experience in Python, comfortable with contributing code to Python repositories maintained by a dedicated development teams
• Experience with version control (e.g., Git) and collaborative development workflows
• Good communication skills in English
• Experience with automation
• Proficiency in Unix-based OS (Linux, macOS)
• Detail-oriented with a keen eye for spotting data issues
• Team player with a collaborative approach to problem-solving
• Skilled at managing multiple data requests and projects, often with competing deadlines
• Experience with SQLAlchemy and Alembic is preferred
• Familiarity with SaaS development environments is an asset
• Development experience in Go is considered a plus
• Fluent in English — French is an asset
• Experience working with Snowflake is preferred

What we offer

• Join an early-stage, well-financed company
• Advance Novisto’s purpose of contributing to the sustainability of the economy, environment, and society by empowering companies to make better decisions and disclosures through our ESG data management software
• Contribute your knowledge and insights to increase awareness and knowledge of sustainability
• Generous health benefits (100% Insurance coverage & access to Dialogue\'s telemedicine app)
• Flexible schedules & opportunity to work remotely
• 4 weeks of vacation
• Summer hours
• If you prefer to work at the office, we have a beautiful office in Old Montreal, close to downtown and steps away from a metro (subway) station