Data Engineer

Location: Calgary Headquarters (Hybrid/Remote) Position Type: Full time, salaried Reports to: Director, Analytics Engineering A bout 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 Analyze, design, develop, test, review, document and troubleshoot data pipeline / ELT solutions against multiple structured and unstructured data sources. Support our team of analysts through developing requirements and delivering solutions. Develop code to scrape public websites for data and perform ELT processes. Maintain, monitor, and support production ELT processes and respond to error and emergency issues. Who You Are You have excellent knowledge and experience with Big Data concepts like data lakes, data warehouses, ELT strategies, and best practices. You have a strong understanding of relational and dimensional data modeling. You possess strong analytical and problem-solving skills. You have experience with DBT and SQL, and are proficent with Python. You have extensive experience with cloud-based data processing and warehousing technologies (Databricks, Snowflake, etc) You have experience with Lean and Agile development methodologies (such as Kanban or SCRUM). You are comfortable in entrepreneurial, self-starting, and fast-paced environment, working both independently and with our highly skilled teams. You have experience with other Big Data processing technologies and cloud services (AWS, GCP, Snowflake, Hive, Hadoop, MS SQL, etc.). You have experience with JIRA and similar organizational tools. You have experience building web-scraping tools against publicly available datasets (considered an asset). You have experience with GIS/geospatial data processing, integration, and analysis is (considered an asset). You have experience building or supporting data visualizat…