Stok leads organizations to decarbonize now. We integrate expertise across ESG and sustainability consulting, carbon, energy engineering, commissioning, and project delivery. From the enterprise to asset level, we provide clients with strategy, management, and technical support to translate bold commitments into impact. Stok is a Certified B Corp and ILFI Just organization, and has been recognized as a Top Impact Company and Best Workplace. Our global team delivers on client ambitions across programs and projects worldwide.
Data Analyst role description:
Stok is seeking a Data Analyst to join our Operations Team. You will design, build, and optimize our data infrastructure with a strong focus on Power BI reporting and analytics. You will be responsible for developing ETL pipelines, ensuring data quality, creating efficient data models and interactive dashboards that support business intelligence solutions.
At Stok, We Seek Culture Add, Not Culture Fit.
Our Values-Aligned Team Members:
Craft innovative ideas and have a say in how the firm operates. We have built self-management and distributive governance into our organizational structure to enable every team member to share input on policies and procedures.
Strive for a better way to do business and create a positive impact through their work. Stok believes in business as a force for good and is a certified B Corp, demonstrating our commitment to maximizing social and environmental impacts, in addition to profit.
Give back in a meaningful way. We donate 3% of profits to causes we believe in through a combination of pro-bono services and donations.
Advocate for a level playing field. Stok has intentionally baked social justice into our operations, which we hold ourselves accountable to through our International Living Future Institute JUST Label.
Participate in a transparent, objective, merit-based compensation and profit distribution processes and policies.
Our purpose is to boldly catalyze an environmentally restorative and socially equitable world, and Stok needs you to fulfill it!
RESPONSIBILITIES
Design, develop, and maintain ETL (Extract, Transform, Load) pipelines to integrate data from various sources into Power BI.
Develop data models and optimize databases for performance and scalability.
Develop interactive dashboards and reports in Power BI
Create and manage on-premises data warehouse.
Work with Deltek cloud platforms to support BI solutions.
Ensure data integrity, accuracy, and security while implementing best practices for data governance.
Automate data workflows and optimize Power Query and DAX queries in Power BI.
Collaborate with teams and stakeholders to understand reporting needs and ensure data accuracy.
Automate reporting processes and improve data visualization techniques
QUALIFICATIONS
What you’ll need to be successful in this role:
Bachelor’s degree in Data Analytics, Business Intelligence, or a related field.
Strong experience with Power BI (DAX, Power Query, and data modeling).
Autonomy is structured into Stok’s culture by design. We value self-management practices, and we know taking time for ourselves is healthy and fosters growth. That’s why we offer:
Flexible work schedules. We work best in different ways, so we empower you to find yours and make a schedule that works for you, the team and clients.
Quiet Fridays: Stok offers everyone two days a month meant to tune out the noise and prioritize what needs to get done (whether that’s work or life related)
Flexible Personal Time Off
Minimum of 80 hours per year for Paid Time Off (PTO) or vacation time
80 hours per year for holiday time (floating holidays)
80 hours per year for wellness (or sick) time
40 hours per year for learning and development
16 hours per year for volunteer time (to give back to your community and the causes that matter most to you!)
Stipends and Perks
Social and environmental justice are critical to our vision, so we bake them into everything we do including the following:
401(k) (world’s first fossil fuel-free and gun-free 401(k) plan so you can invest in a future you believe in) or Registered Retirement Savings Plan (Canada)
Annual Learning and Development stipend
Work from Home stipend (to support remote ergonomics)
Annual US National Parks Pass or Parks Canada Discovery Pass
Donation program
Cellphone benefit
Personal company credit card
Stok will not require team members to be in an office, but our office locations are open for them to collaborate. This role’s preferred location is Edmonton, AB – Calgary, AB, Vancouver, BC or Toronto ON but can be located anywhere in Canada.
COMPENSATION RANGE: $76,000 - $113,000 CAD based on market location and experience.
Data Analyst