Data Engineer
novisto
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 be expected to help maintain data integrity on existing datasets, push performance improvements, develop new data automation, and assist in data corrections on deployed environments.
Your responsibilities will include:
- 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 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);
- Strong documentation skills;
- 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