Data Analyst

DATA ANALYST (Power BI Focus) 

Calgary/Edmonton, AB; Vancouver, BC; Toronto, ON; Remote Canada

FTE (1.0)

Remote/Hybrid

 

Description 

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). 

• Strong analytical and problem-solving skills. 

• Demonstrated effective Project Management experience 

• Self-starter 

• Data visualization capabilities 

Additional experience we’d be excited for you to bring (not required, but a bonus to our team and our clients):    

• Knowledge of Python or SQL. 

• Knowledge of Vena, or any similar Excel-based FP&A platforms. 

• Knowledge of on-premises data server. 

How We Support You - Health Benefits 

US-Based Team Members 

• Medical, dental and vision coverage (can also include dependents) 

• Employer-funded and tax-deductible Health Reimbursement Account 

• Employee-funded and tax-deductible Flexible Spending and Health Savings Accounts 

• Mental health concierge service 

• Life, accidental death, long-term and short-term disability coverage 

 

Canada-Based Team Members 

• 50% Employer-funded group health benefit plan 

• Employer-funded Health Spending and Wellness Spending Accounts 

• Employee Assistance Program 

• Life, Accidental Death, Long-Term Disability coverage 

Paid Time Off Benefits 

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.