Location: Calgary Headquarters (Hybrid/Remote)
Position Type: Full time, salaried
Reports to: Director, Analytics Engineering

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.