Data Engineer

Work in Ottawa; Ottawa; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A data and analytics company in Ottawa is seeking a Data Engineer to enhance their data infrastructure. The ideal candidate will design high-performance data solutions, work with technologies like Snowflake and MongoDB, and collaborate across teams. This role offers a hybrid work environment, competitive salary, and numerous benefits including healthcare and personal development days. If you're passionate about data and innovation, we encourage you to apply.

Benefits

Healthcare cover, including vision and dental

Long Term Disability Cover

Competitive salary and equity participation

Paid personal development days

Annual paid volunteer day

Qualifications

• Proven experience managing and optimizing massive datasets, ensuring high performance.
• Deep expertise in Snowflake and MongoDB Atlas.
• Experience with real-time ETL/ELT pipelines using Kafka.

Responsibilities

• Collaborate with technical teams to understand data requirements.
• Migrate customer data from legacy systems.
• Plan and implement scalable data solutions on cloud platforms.

Skills

Data modeling

Python

SQL

Collaboration

Agile methodologies

Education

Bachelor’s or Master’s in Computer Science, Data Engineering

Tools

Snowflake

MongoDB Atlas

AWS

Kafka

Docker

Kubernetes

Job description

Ottawa’s tech sector is growing, and so are the opportunities! If you’re exploring your next role in tech, Work in Ottawa can help you learn about leading employers and exciting careers in Canada’s capital.

Led by Invest Ottawa, the city’s lead economic development agency, this initiative works alongside tech companies, recruiters and search firms, and community partners to spotlight the incredible innovation happening here and help connect great people with great opportunities.

We are excited to partner with Noda to attract top talent for Data Engineer.

Noda is a data and analytics company for the commercial built environment. We reimagine how modern buildings operate — because a better world needs better buildings. Better buildings are more efficient, more sustainable, and more resilient. They are intelligent, autonomous ecosystems that anticipate and adapt, seamlessly.

With commercial building operations accounting for nearly 30% of global emissions, we’re on a mission to turn buildings into a force for positive change, powering a more efficient, more sustainable world. We do this with smart software, careful use of modern artificial intelligence, sophisticated data models, and custom interfaces to building systems – and a lot of in-depth knowledge about how commercial buildings actually run.

We’re a young, nimble company where we very much value creative thinking, a love of team work, and a determination to solve the problem, whatever it is. Priorities can shift fast, so adaptability and flexibility come with the territory. The consequence is that you’ll have a chance to make a real impact, backed by a supportive team.

About the Role

Noda is looking for a Data Engineer to join our software development team in Ottawa, Canada, reporting to our Chief Software Architect. You will join a close-knit team of developers using data technologies such as Snowflake, MongoDB, and PostgreSQL. In this role, you’ll focus on designing, building, and optimizing our data infrastructure to support scalable, high-performance analytics and business intelligence. You will work with modern data technologies, ensuring efficient data pipelines, ETL processes, and database performance tuning. Collaborating closely with data analysts, software engineers, and business stakeholders, you will help shape the future of our data platform, enabling data-driven decision-making across the company.

The position will be based out of our Ottawa office, with flexibility to work in a hybrid arrangement.

What you’ll be doing

• Collaborate with technical teams to understand data requirements and deliver data integration solutions.

• Migrate customer data from legacy systems, ensuring data accuracy, consistency, and minimal disruption.

• Perform data modeling, including dimensional modeling, to create structured datasets for analytics and reporting purposes.

• Plan and implement scalable data solutions on cloud platforms such as AWS, Snowflake, and Mongo Atlas.

• Ensure data governance practices are followed to maintain data quality, integrity, and compliance with industry standards.

• Implement data security best practices and ensure compliance with data privacy regulations (e.g., GDPR, CCPA).

• Work in an Agile environment, collaborating with cross-functional teams and using project management tools to deliver projects effectively.

What you will need

• Bachelor’s or Master’s in Computer Science, Data Engineering, or equivalent experience

• Proven experience managing and optimizing massive datasets (billions of rows / multi-terabyte tables), ensuring high performance and cost-efficiency.

• Deep expertise in Snowflake and MongoDB Atlas (including Federation and CDC) as primary data stores.

• Hands-on experience building real-time ETL/ELT pipelines using Kafka, Kafka Connectors, Estuary.

• Familiarity with Vector Databases and the data infrastructure required to support LLM/RAG applications.

• Proficiency in Python and SQL for data modeling (DBT), query tuning, and general automation.

• Experience with AWS and containerized environments (Docker/Kubernetes).

• A collaborative communicator who is adaptable in a fast-paced DevOps environment.

Why we think you’ll love it here

• Huge responsibility and fascinating challenges – you’ll be joining us early on in our journey, with plenty of autonomy and room to develop your role.

• Joining a fast-growing team of brilliant people building solutions at the forefront of smart building technology!

We offer a great work environment, a clear development path, and many tangible benefits, here just a handful:

• Office in Ottawa to use when you like
• Healthcare cover, including vision, dental.
• Critical Illness Cover & Life Insurance Policy
• Accidental Death, Dismemberment and Specific Loss
• Long Term Disability Cover
• Pension - Registered Retirement Savings Plan
• Enhanced paternity, maternity and adoption leave.
• Competitive salary and equity participation.
• Highly flexible and autonomous working.
• Paid personal development days.
• Annual paid volunteer day to help out a charity of your choice

At Noda, we value diverse perspectives and believe great ideas come from people of all backgrounds. If you're excited about this role but don’t meet every requirement, we encourage you to apply—we’d love to hear from you!

Work in Ottawa utilizes a secure, closed AI environment for the initial screening of resumes, ensuring your data remains safe while helping us efficiently identify top candidates. We encourage all applicants to apply, even if you do not meet every requirement if you possess relevant skills, enthusiasm and eagerness to grow, we want to hear from you! To enhance your visibility, consider including relevant keywords in your resume.

If you require any accommodation during the hiring process, please reach out to [e-mail].