Sql data analyst Jobs in Ottawa, ON

Connect with us to discover our latest job opportunities! Even if nothing suits you right now, stay in touch — your perfect role may be just around the corner!

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!