Sr. Data Engineer

Project Canary is a SaaS-based data analytics company focused on environmental performance or the E in ESG for energy and additional business sectors. We are the leaders in assessing and scoring responsible operations and provide independent, measured emission profiles, including methane, via high fidelity continuous monitoring technology that helps companies take ESG action. Formed as a Public Benefit Corporation (B-Corp rating score 107), Project Canary’s Denver and Hayward-based team of technologists, engineers, and seasoned industry operators have earned recognition for their uncompromising standards and high-fidelity data.

Project Canary’s mission is to fight climate change and put actionable insights starting with the energy sector. We ingest data from various sources, including our own proprietary environmental sensors/hardware, to calculate carbon emissions from different facilities in real-time via SaaS. The resulting independent data can inform the procurement of offsets in real-time using microtransactions, formulate a data-driven ESG strategy that investors now demand, improve operations by identifying problem areas in minutes, and bolster customer engagement through radical supply chain transparency.

Founded in 2019, Project Canary, PBC has quickly gained recognition as a major mover in the continuous monitoring space. Here are some highlights from last year:

• Fundraise totaling $121M, Series A of $10M in 2021 and Series B of $111M in 2022
• Certified as a B-Corporation with a score of 107.6

• Recognized as Best for the World (top 5% of all B-Corps) in 2 out of 5 categories

• Governance (transparency and ethics)
• Workers (treatment of teammates and culture)

• Additional recognition and awards for our culture (more to come soon!)
• eNPS score of 72 (most recent measurement in Q4 of 2021)

• Headcount growth by 6X and growing
• Revenue growth of 6X and growing

Project Canary’s success is attributed to the motivation, skill, and teamwork of everyone. The team understands the importance of maintaining a culture where relationships are valued, feedback is crucial, and trust in each other and our products/services is paramount. If you enjoy a growth-stage environment, mission-driven work, we want to hear from you.

The Data Engineer will be working with the Core Software Engineering team and reporting to the Director of Software Engineering. This role will entail creating, owning and maintaining multiple ETL processes to support different teams across the business. You will handle the creation of asynchronous data pipelines to populate data lakes. This role will also be the expert on our data storage strategy and know when something should be cached or not.

Job Responsibilities

• Develop real time ETL pipelines across multiple data streams
• Understand and optimize our data caching strategy to reduce database queries
• Populate and maintain Data warehouses/lakes/rdbms (Postgres, Red Shift) include replication
• Strong understanding of ETL and production vs. Development ETLs

Requirements

• Query, View, ETL in Postgres
• Has experience working with Redshift
• Experience with SCADA (supervisory control and data acquisition)
• Experience with AWS (Kinesis, Kafka, Spark, SNS, SQS, Redis/ElastiCache and ElasticSearch)
• Has experience programmatically normalizing and denormalizing data and piping from a DBMS to BI Tools (Tableau, Power BI, Looker)

Benefits

• Full coverage of health, dental, and vision insurance (low deductibles)
• 401K company match (no vesting period)
• Stock options
• Student loan assistance
• Unlimited PTO (minimum rule of taking at least 3 weeks off in a year)

• Company sponsored wellness days (Fall hike, ski/snowboard days and more)
• 12 weeks of fully paid parental leave (gender neutral) including adoptions
• Flex Choice – choice between free parking, free RTD, or wellness assistance
• Salary range: $145,000 - $170,000 annual base
• Flexible work environment - hybrid - must reside near Denver