Jobs.ca
Jobs.ca
Language
StackAdapt logo

Intermediate Enterprise BI Developer

StackAdaptabout 23 hours ago
Remote
Mid Level
full_time

Top Benefits

Competitive salary
401(k) retirement plan
Generous paid time off, including birthday off

About the role

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 program
  • 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:

Ad Age Best Places to Work 2024

G2 Top Software and Top Marketing and Advertising Product for 2024

Campaign’s Best Places to Work 2023 for the UK

2024 Best Workplaces for Women and in Canada by Great Place to Work®

#1 DSP on G2 and leader in a number of categories including Cross-Channel Advertising

About StackAdapt

Technology, Information and Internet
1001-5000

Discover the multi-channel programmatic advertising platform used by digital marketers around the world. StackAdapt is a digital advertising platform that specializes in native, display, video, connected TV, audio, in-game, and DOOH advertising.

Our state-of-the-art platform is where some of the most progressive work in machine learning meets cutting-edge user experience. StackAdapt is designed around the three core pillars of programmatic—planning, executing and analyzing.

StackAdapt is ranked as the number 1 DSP on G2. For six consecutive years with over hundreds of reviews, StackAdapt has been recognized as a high performer and the highest-ranking DSP in customer satisfaction by G2. StackAdapt was also recognized as an Enterprise Fast 15 winner as part of the Technology Fast 50™ program in 2023 and is one of Ad Age’s Best Places to Work in 2024.

Learn more about StackAdapt here: www.stackadapt.com. And if you're looking for a change, we'd love to have you on our team—check out our open roles by visiting: www.stackadapt.com/careers.

StackAdapt is headquartered in Toronto, Canada. We have teams and client support across North America, EMEA, APAC, and LATAM.