Data Engineer

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 • 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 visualizations (considered an asset). • 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. • 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. Orennia is an Equal Employment Opportunity (EEO) employer. We are committed to creating a diverse and inclusive workplace where all employees and applicants are treated fairly and with respect, regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, age, disability, marital status, veteran status, or any other characteristic protected by applicable provincial, federal, state, or local law. We believe in fostering a work environment that promotes equal opportunities for all individuals and strive to eliminate any barriers to employment and advancement. We are dedicated to providing equal opportunities in hiring, promotions, compensation, benefits, training, and all other aspects of employment. At Orennia, diversity, inclusion, and fairness are not only important values but also critical to our success as an organization. We encourage all qualified individuals to apply and join us in our mission to create a workplace that reflects the diverse communities we serve. Please contact a member of our people & culture team (hr@orennia.com) should you require accommodations.