Intermediate Enterprise BI Developer

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
• 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
• 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.
 
We use artificial intelligence (AI) to streamline the resume reviews of candidates and assess their fit based on the criteria outlined in the job posting. We do not use AI to make any final hiring or interview decisions.
 
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
 
#LI-REMOTE

---