Technical Analyst, Data

About Orennia

“The impediment to action advances action. What stands in the way becomes the way.”

• Marcus Aurelius

There are very few times in history where society has faced a critical test that forced us to align around a common objective. We are confronting such a moment today: the fight against climate change. Reducing CO2 emissions is the primary (and perhaps sole) solution. A transition to renewable electricity as our primary power source is what stands in the way in reducing CO2 emissions.  At Orennia, we believe what stands in the way becomes the way.

2022 saw the most investments ever in new wind and solar projects. As America de-carbonizes its energy stack, the annual investment in new power generation is expected to double by 2030. With trillions in capital needing to be deployed, Orennia helps investors make more informed decisions using data, analytics, and machine learning/artificial intelligence.

Why Join Orennia?

At Orennia, you will become part of a collaborative culture and do work that matters. As a company enabling the energy transition, we believe that a diversity of perspectives generates better solutions. We trust and support each other, ask hard questions and solve complex problems. Guided by a spirit of inquiry, we design for people at every scale, creating spaces that elevate individuals, their communities, and the institutions that serve them.

The Opportunity

We are looking for a Technical Analyst, Data to join our rapidly growing company in the energy transition sector. The ideal candidate is naturally curious, enjoys problem-solving, has a strong dedication to quality, and is highly adaptable. We are based out of Calgary, Alberta however open to our Technical Analyst, Data being remote or hybrid.

Responsibilities

• Help identify, diagnose, and understand issues in our large (multi-Terabyte) and complex relational database.
• Propose practical solutions to these problems and describe trade-offs between multiple alternatives.
• Communicate with the data engineering and analyst teams to foster a shared understanding of these issues and their solutions.
• Help organize our efforts for resolving issues and developing new product features.
• Help design data structures that empower our core products and analytics.

Required Qualifications

• 3+ years of relevant experience working with relational databases.
• Extensive experience with SQL at an intermediate to advanced level.
• Strong practical understanding of database design and normalization.
• Deep attention to detail, quality, and pragmatism.
• Dedication to continuous learning, improvement, and growth.
• Strong communication skills, with emphasis on clarity and conciseness.
• Comfortable in entrepreneurial, self-starting, and fast-paced environment, working both independently and with our highly skilled teams.
• Interest and passion for the product we build, the industry we’re in, and the needs of the users we serve.
• Ability to work in Canada or USA without a visa/sponsorship.

Desirable Qualifications

• Hands-on experience building data-driven applications, especially for large data sets.
• Practical experience with Snowflake.
• Experience or familiarity with DBT.
• Experience with other Big Data / Data Warehouse platforms and technologies.
• Experience with non-relational / NoSQL databases and data sets.
• Good understanding of statistics and data analysis methods.
• Working knowledge of Python-based data analysis tools.
• Experience with JIRA or similar organizational tools.
• BSc/BA in Computer Science, Engineering, or a related field.

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

Our Pledge to Fostering an Inclusive and Safe Workplace:

Orennia is an Equal Opportunity Employer. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age, or disability.