Back to jobs
New

Intermediate Enterprise BI developer

Canada

StackAdapt is the leading technology company that empowers marketers to reach, engage, and convert audiences with precision. With 465 billion automated optimizations per second, the AI-powered StackAdapt Marketing Platform seamlessly connects brand and performance marketing to drive measurable results across the entire customer journey. The most forward-thinking marketers choose StackAdapt to orchestrate high-impact campaigns across programmatic advertising and marketing channels.

We have an exciting opportunity in the Enterprise Data Office (EDO) with its mandate to serve the business leaders and stakeholders at StackAdapt with trusted data, standard reporting frameworks, and tools, and governed reporting and self-service analytics. Reporting to the Staff BI Architect, the Junior Enterprise BI Developer will be responsible for supporting the development, maintenance, and administration of reports and dashboards leveraging the Business Intelligence (BI) platforms managed by the EDO, such as Tableau and ThoughtSpot.

The Junior Enterprise BI Developer will assist in building official KPI reports and dashboards requested by various business departments, leveraging the business-friendly BI semantic models developed by the BI Architect. This role provides an excellent opportunity to learn and grow within enterprise BI while contributing to meaningful business analytics initiatives.

StackAdapt is a Remote-First company. We are open to candidates located anywhere in Canada for this position.

What You'll Be Doing:

This role will support the development of centralized Business Intelligence reports and dashboards, and assist with the maintenance and administration of these BI assets including:

  • Develop reports and dashboards in Tableau and ThoughtSpot based on specifications from the BI Architect and Senior BI Developers
  • Assist in developing intermediate data structures such as views and materialized views in Snowflake that will be sourced for reports and dashboards
  • Support the maintenance and evolution of semantic models built with tools like dbt or Cube.js
  • Write and optimize SQL queries in Snowflake to support reporting requirements
  • Assist in testing and quality assurance of BI assets before production deployment
  • Help maintain documentation for BI assets, semantic models, and reporting processes
  • Support business users with basic reporting questions and self-service analytics needs
  • Participate in troubleshooting production issues under the guidance of senior team members
  • Contribute to the setup and monitoring of scheduled reports and dashboard refreshes
  • Learn and apply data visualization best practices to create clear, effective dashboards

Within the first 6 months in the role, a successful candidate will obtain a solid understanding of the StackAdapt data and reporting environment including the EDO Snowflake platform and existing BI assets. Successfully build, deploy, and support at least three light-complexity reports/dashboards for the business with guidance from senior team members.

Performance in this role will be evaluated on learning agility, quality of work delivered, ability to work independently on assigned tasks, and responsiveness to feedback from senior team members and business users.

What You'll Bring to the Table

  • 1-2 years of experience in BI development or analytics roles
  • Hands-on experience building dashboards and reports in Tableau and/or ThoughtSpot
  • Solid SQL skills with experience writing queries in Snowflake (e.g., joins, aggregations, CTEs, window functions)
  • Exposure to or basic experience with semantic modeling tools such as dbt or Cube.js
  • Understanding of data visualization principles and dashboard design basics
  • Familiarity with cloud data warehouses (Snowflake, BigQuery, Redshift, etc.)
  • Strong willingness to learn and adapt to new technologies and methodologies
  • Good communication skills and ability to work collaboratively in a team environment
  • Detail-oriented with good problem-solving abilities
  • Experience working with both Tableau and ThoughtSpot
  • Knowledge of Git for version control
  • Exposure to data modeling concepts (star schema, dimensional modeling)
  • Basic understanding of BI platform administration and user access management
  • Experience supporting business users or working in a client-facing capacity
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field
 

StackAdapter's Enjoy:

  • Highly competitive salary
  • Retirement/ 401K/ Pension Savings globally
  • Competitive Paid time off packages including birthday's off!
  • Access to a comprehensive mental health care platform
  • Health benefits from day one of employment
  • Work from home reimbursements
  • Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto
  • Robust training and onboarding program
  • Coverage and support of personal development initiatives (conferences, courses, books etc)
  • Access to StackAdapt programmatic courses and certifications to support continuous learning
  • An awesome parental leave program
  • A friendly, welcoming, and supportive culture
  • Our social and team events!
StackAdapt is a diverse and inclusive team of collaborative, hardworking individuals trying to make a dent in the universe. No matter who you are, where you are from, who you love, follow in faith, disability (or superpower) status, ethnicity, or the gender you identify with (if you’re comfortable, let us know your pronouns), you are welcome at StackAdapt. If you have any requests or requirements to support you throughout any part of the interview process, please let our Talent team know.
 
About StackAdapt
 
We've been recognized for our diverse and supportive workplace, high performing campaigns, award-winning customer service, and innovation. We've been awarded:
 
2024 Best Workplaces for Women and in Canada by Great Place to Work®
 
#LI-REMOTE

Create a Job Alert

Interested in building your career at StackAdapt? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Select...
Select...
Select...
Select...
Select...

Demographic Survey for StackAdapt

Here at StackAdapt, we strive to break down barriers so everyone can thrive. We are a global company and we must reflect the diverse world we work in. We are committed to building an inclusive workforce that fully represents the many different cultures, backgrounds and viewpoints of our employees, our customers and our communities. 

As part of our commitment to diversity, equity and inclusion, we want to understand how we are performing from a talent attraction perspective. Therefore, we would like to invite you to complete this optional and confidential survey to help us evaluate our efforts.

Submission of the information on this form is strictly voluntary and your refusal to provide it will not affect your job application in any way. The information obtained will be kept separate from your name or job application and there is no way we can identify you through the data you submit. This information will be kept secure and confidential and will be used solely to evaluate our diversity, equity and inclusion efforts at StackAdapt.

By choosing to answer the following questions, you consent to our collection and use of this information for our reporting and analytics. Your participation is entirely voluntary.

Select...
Select...
Select...
Select...