Data Engineer

Orennia; Calgary; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Data Engineer to join their innovative team. This role is crucial for developing data and analysis pipelines that support the energy transition. The ideal candidate will possess strong technical skills and a collaborative mindset, working alongside experts to drive impactful solutions. You will engage in exciting projects that contribute to a net-zero future while enjoying a supportive work environment that values growth and development. This is a fantastic opportunity for those eager to make a difference in a dynamic and fast-paced setting.

Benefits

Comprehensive health benefits

Dental and vision benefits

Savings program with company matching

Learning and development budget

Generous time off

Paid vacation days

Paid sick days

Qualifications

• Experience with Big Data concepts and ELT strategies.
• Proficient in Python, SQL, and cloud-based data technologies.

Responsibilities

• Develop and maintain data pipeline/ELT solutions.
• Support analysts by delivering data solutions and requirements.
• Monitor and troubleshoot production ELT processes.

Skills

Big Data concepts

Data lakes

Data warehouses

ELT strategies

Analytical skills

Problem-solving skills

DBT

SQL

Python

Cloud-based data processing

Lean and Agile methodologies

Web-scraping tools

GIS/geospatial data processing

Education

Bachelor's degree in Computer Science or related field

Tools

Databricks

Snowflake

AWS

GCP

JIRA

Job description

Location: Calgary Headquarters (Hybrid/Remote)

Position Type: Full time, salaried

Reports to: Director, Analytics Engineering

About Orennia

Orennia provides an all-in-one platform for accurate data, predictive analytics and actionable insights across the energy transition. We drive faster capital allocation decisions and help our clients maximize returns across the solar, wind, storage, power, RNG, CCUS, clean fuels and hydrogen sectors. The technology that powers Orennia’s platform delivers an unparalleled experience, distilling information into actionable insights to give our clients a competitive edge.

As the world decarbonizes its energy stack, trillions in capital need to be deployed. Global investment in the energy transition must quadruple to over $5 trillion annually to stay on the 1.5°C pathway, according to the International Renewable Energy Agency. Without accurate data and predictive analytics, developers and investors will struggle to deploy capital efficiently and maximize returns. Orennia’s platform expedites the energy transition with effective and robust information for smarter capital allocation choices.

Why Join Orennia?

People are at the heart of the best technology companies. We’ve brought together some of the industry’s top experts and brightest minds in data orchestration, analytics, software development, and industry insights to uncover opportunities where others can’t. At Orennia, you’ll become part of a collaborative culture and do work that matters. We trust and support each other, ask hard questions and solve complex problems together. Guided by a spirit of inquiry, our team has a product-driven, continuous delivery mindset to drive our innovation forward.

The Opportunity

As a Data Engineer, you will play an integral role in the development of our products, including building out our data and analysis pipeline. The ideal candidate has an entrepreneurial mindset, high technical proficiency, and is highly adaptable. You will collaborate with cross-functional teams engaging with a variety of experts and perspectives. Our people are passionate and have a strong belief in our mission. Our efforts impact individuals and communities, all the while working toward a net-zero future. If you’re hungry for opportunity, growth, and something meaningful in a dynamic, fun and challenging environment, we’d love to hear from you.

What You’ll Do

1. Analyze, design, develop, test, review, document and troubleshoot data pipeline / ELT solutions against multiple structured and unstructured data sources.
2. Support our team of analysts through developing requirements and delivering solutions.
3. Develop code to scrape public websites for data and perform ELT processes.
4. Maintain, monitor, and support production ELT processes and respond to error and emergency issues.

Who You Are

1. You have excellent knowledge and experience with Big Data concepts like data lakes, data warehouses, ELT strategies, and best practices.
2. You have a strong understanding of relational and dimensional data modeling.
3. You possess strong analytical and problem-solving skills.
4. You have experience with DBT and SQL, and are proficient with Python.
5. You have extensive experience with cloud-based data processing and warehousing technologies (Databricks, Snowflake, etc).
6. You have experience with Lean and Agile development methodologies (such as Kanban or SCRUM).
7. You are comfortable in an entrepreneurial, self-starting, and fast-paced environment, working both independently and with our highly skilled teams.
8. You have experience with other Big Data processing technologies and cloud services (AWS, GCP, Snowflake, Hive, Hadoop, MS SQL, etc.).
9. You have experience with JIRA and similar organizational tools.
10. You have experience building web-scraping tools against publicly available datasets (considered an asset).
11. You have experience with GIS/geospatial data processing, integration, and analysis (considered an asset).
12. You have experience building or supporting data visualizations (considered an asset).
13. Deep intellectual curiosity with a results-focused relentless pursuit of answers. Ability to work in a fast-paced start-up environment, embrace change and ambiguity.
14. You are hungry to learn and contribute. Our organization is growing and this role is an exceptional opportunity to grow with us.

Why You’ll Love Orennia

At Orennia, you'll join a high performing, people-focused team where everyone has a role to play. We offer our regular, full-time employees a competitive total rewards package, comprehensive health, dental and vision benefits, a savings program that includes company matching, and a learning and development budget to master your craft. In addition, we offer generous time off with regular company holidays, paid vacation days and paid sick days.

We thank all applicants in advance for their interest and for taking the time to apply; however, only applicants invited for an interview will be contacted.

In keeping with our values, Orennia is proud to be an equal opportunity employer. Orennia provides equal employment opportunities to all employees and all qualified applicants for employment without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Please contact a member of our People & Culture team ([e-mail]) should you require accommodation at any point during our interview processes.