Data Scientist/Engineer

Posterity Group; Ottawa; Remote; CAD 85,000 - 110,000; Full time

Job summary

A leading consulting firm is seeking a Data Scientist/Engineer to join their team. The ideal candidate will design and maintain data pipelines, ensuring high-quality data for energy analysis models. This role involves collaboration with engineers and analysts in a dynamic work environment focused on the energy transition. The company values diversity and offers a flexible work atmosphere with comprehensive benefits.

Benefits

Health benefits

Four weeks of vacation

Profit sharing

Flexibility on work location and hours

Qualifications

• Three or more years of experience as a Data Scientist/Engineer.
• Legal eligibility to work in Canada and a valid Social Insurance Number.

Responsibilities

• Designing, developing, and maintaining scalable data pipelines.
• Collaborating with energy engineers and analysts for data requirements.
• Implementing data validation and cleaning procedures.

Skills

Python

R

SQL

Statistical Analysis

Predictive Modeling

Data Mining

Education

Bachelor’s or Master’s degree in Computer Science

Data Science

Data Engineering

Information Technology

Tools

MySQL

PostgreSQL

MongoDB

Cassandra

Microsoft Azure

Redshift

BigQuery

Databricks

Hadoop

Spark

Kafka

Apache NiFi

Airflow

Talend

Job description

About Posterity Group

Our Work

Posterity Group Consulting helps clients assess risks and opportunities associated with the energy transition by providing the information, tools, and guidance they need to navigate the future.

Our team of experts provides modelling, analysis, and advice on how policy, technology, and economics influence the energy system. We support clean energy programs, integrated resource planning, policy impact assessment, energy transition scenario analysis, and sector-focused energy forecasting. We are trusted advisors to utilities, energy planners, policy makers, and private sector organizations across North America.

Who We Are

As a consulting company, we use our knowledge and experience to help clients solve challenging problems. The sum of our individual differences, life experiences, knowledge, self-expression, and unique capabilities allow us to solve these problems. These differences make Posterity Group a more interesting and richer workplace. We are committed to cultivating and preserving a culture of diversity, equity, and inclusion, and we want every individual we interact with to experience kindness, consideration, and inclusion. Our values are:

• Responsibility to Act: We strive to make the world a better place by working on the climate crisis
• Honesty: We strive to create a safe space for honesty, which requires vulnerability, openness, collaboration, and accountability
• Continuous Improvement: We strive for continuous improvement at personal and company levels
• Kindness: We engage with kindness and empathy, and we do so fairly and equitably
• Integrity: We have the courage to stand by our beliefs and the facts

We offer a healthy work atmosphere that is purposeful, motivating, and gratifying. Our progressive management policies include:

• Flexibility on work location and hours
• Health benefits, including drug, dental, and supplemental health coverage
• Four weeks of vacation, plus our offices are closed between Christmas and New Year’s Day, and Fridays from Canada Day through to Labour Day.
• Profit sharing.

The Role

We are looking for a versatile professional with expertise in both data science and data engineering for a full-time permanent Data Scientist/Engineer role to join our team. This position will be responsible for designing, building, and maintaining data pipelines that feed into our energy analysis models. You will work closely with analysts and energy engineers across our consulting team to ensure the seamless flow and integrity of data, enabling the development of accurate and reliable energy models. Your role is crucial in ensuring our models have access to high-quality, timely data from a diverse range of sources. Main activities include:

• Designing, developing, and maintaining scalable data pipelines to collect, process, and store large volumes of data from diverse sources
• Collaborating with energy engineers and analysts to understand data requirements and ensure data availability and reliability for energy models
• Preprocessing data to optimize energy model performance and support model development (including machine learning)
• Normalizing energy modeling results and housing these in databases for efficient results visualization
• Implementing data validation and cleaning procedures to ensure data quality and consistency
• Monitoring data pipeline performance, troubleshooting issues, and optimizing for speed and reliability
• Developing and maintaining documentation for data pipelines, sources, and models
• Staying up-to-date with emerging technologies and best practices in data science/engineering and energy demand analysis
• Working with cloud platforms and data storage solutions to manage data infrastructure
• Collaborating with cybersecurity team to implement data security measures and ensure regulatory compliance
• Performing other tasks as required, depending on experience

The ideal candidate will possess:

• Bachelor’s or Master’s degree in Computer Science, Data Science, Data Engineering, Information Technology, or a related field
• Three or more years of experience as a Data Scientist/Engineer or similar role, preferably in the energy or utilities sector
• Proficiency in Python and R
• Knowledge of SQL and experience with relational (e.g., MySQL, PostgreSQL) and NoSQL (e.g., MongoDB, Cassandra) databases
• Experience with cloud platforms such as Microsoft Azure, and data services like Redshift, BigQuery, Databricks
• Knowledge of data warehousing concepts and experience with building data warehouses or lakes
• Understanding of data security best practices
• Strong statistical analysis, predictive modeling (including machine learning), and data mining skills
• Experience with big data technologies such as Hadoop, Spark, Kafka is a plus
• Familiarity with ETL tools like Apache NiFi, Airflow, Talend is a plus
• Legal eligibility to work in Canada and a valid Social Insurance Number at employment start

Salary Range: $85,000 to $110,000, flexible based on experience. Preferred locations are Ottawa, Toronto, or Vancouver, but other Canadian locations considered. Please submit your resume and cover letter by May 30, 2025.

If your career goals and values align with ours, we encourage you to apply and explain why you are a good fit in your cover letter, even if you don't meet all criteria.

Posterity Group is committed to diversity, equity, and inclusion. We welcome applicants from all backgrounds and encourage those who identify as part of an equity-seeking group to mention this in their cover letter.

While we appreciate all applications, only shortlisted candidates will be contacted.

Remote/Telecommute/Work From Home