Solutions Architect

Viral Nation; Canada; On-site; CAD 130,000 - 150,000; Full time

Job summary

A creative digital agency is seeking a Solution Architect in Canada to drive AI-powered data solutions. The role requires expertise in SQL, BI platforms like Sigma and Tableau, and a background in data analytics. The successful candidate will collaborate with various teams to optimize data pipelines and implement scalable analytical systems. The annual salary ranges from $130,000 to $150,000, reflecting performance and market alignment.

Qualifications

• 5+ years in Solution Architecture, Data Analytics, or Business Intelligence.
• Expert in SQL and designing complex data transformations.
• Familiar with cloud data platforms and modern BI tools.

Responsibilities

• Identify opportunities for data and AI-driven impact.
• Build intelligent dashboards and data models.
• Collaborate with teams to ensure data quality and operational efficiency.

Skills

SQL proficiency

Data modeling expertise

Experience with BI platforms

Data warehousing principles

Analytical design skills

Education

Bachelor’s degree in relevant field

Tools

Snowflake

Google BigQuery

Sigma

Tableau

Looker

Power BI

Job description

Overview

At Viral Nation, we specialize in building social-first ecosystems for brands to connect with the modern consumer journey. Our integrated solutions align strategy, talent, media, and technology with culturally relevant creativity to scale the world’s fastest-growing digital brands. Viral Nation offers a fluid, creative, and growth-oriented environment that will support your ambitions to apply your talents in an open, collaborative, and fast-paced culture. Our ability to stay at the forefront of the industry has fuelled our success and will guide us in paving the path forward. We’re driven to push boundaries and think beyond today to deliver strategies, and we’re just getting started.

While we continuously exceed our goals, we need your help – our success is only as great as our people. Strong performance leads to high expectations, and we must keep raising the bar!

Responsibilities

• Partner with executive, strategy, and client teams to identify opportunities where data and AI can deliver measurable impact across creator selection, content performance, audience alignment, and trend forecasting.
• Architect and build robust, intelligent dashboards, models, and frameworks that convert complex datasets into intuitive, actionable solutions.
• Design and implement scalable data models and analytical systems that support enterprise-grade use cases.
• Lead the translation of ambiguous business challenges into concrete technical requirements and AI-powered solutions.
• Develop and optimize advanced SQL queries and data pipelines across platforms like Snowflake and BigQuery to operationalize your models.
• Collaborate with the Data Engineering and AI teams to ensure data quality, infrastructure alignment, and system efficiency.
• Build internal enablement tools that democratize insight — empowering non-technical teams to use, understand, and scale data-driven solutions.
• Experiment with and deploy emerging AI methods (LLMs, embeddings, predictive modelling) to surface new intelligence layers from social and behavioural data.
• Champion data-driven culture by educating internal teams on analytics best practices and data literacy.
• Continuously evaluate and introduce new technologies, frameworks, and methodologies that advance our intelligence capabilities.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Engineering, Business Analytics, or a related field — or equivalent experience demonstrating technical excellence and business fluency.
• 5+ years of experience in Solution Architecture, Data Analytics, Business Intelligence, or similar role, ideally within a data-heavy or AI-enabled environment.
• Expert proficiency in SQL with experience designing performant, complex data transformations.
• Hands-on experience with modern BI platforms such as Sigma, Tableau, Looker, or Power BI.
• Direct experience with Sigma is a strong plus.
• Strong knowledge of cloud data platforms, including Snowflake and Google BigQuery.
• Deep understanding of data modeling, data warehousing, and analytical design principles.
• Product-minded approach with the ability to design intuitive tools and solutions for non-technical users.
• Comfortable operating in ambiguous and fast-evolving problem spaces, transforming open-ended questions into actionable data products.
• Demonstrated passion for uncovering insights in social, consumer, or behavioral data.
• Background in marketing, the creator economy, or social intelligence is a strong asset.

Compensation

This role has an annual salary range of $130,000 to $150,000.

Compensation Philosophy

At Viral Nation, compensation is structured, performance-led, and market-aligned. Pay decisions are intentional, based on role requirements, performance, and market alignment by country, and are set to maintain internal pay equity across comparable roles and levels.

Compensation progression is tied to demonstrated performance, expanded scope, and sustained contribution over time, not tenure alone. Employee compensation is reviewed regularly through formal performance reviews and check-ins to ensure alignment with role expectations and impact.

AI in Recruitment

Viral Nation does not use AI-enabled tools to screen, assess, rank, or select candidates in our recruitment process. Our hiring teams make all hiring decisions.

DEI Commitment

Viral Nation is committed to diversity, equity and inclusion in our agency. Viral Nation welcomes applications from people with visible and non-visible disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruiting and selection process.

Important notes

Viral Nation does not solicit or require applicants to provide sensitive personal information outside of the standard application process. EEO statements and diversity commitments are in place.