Solutions Architect

Viral Nation; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading digital solutions company in Canada is seeking a Solution Architect specializing in Data Solutions. The ideal candidate will have over 5 years of experience in solution architecture with a strong background in SQL, data modeling, and business intelligence tools. This role involves building intelligent dashboards, converting complex datasets into actionable solutions, and advocating for a data-driven culture. A commitment to diversity and inclusion is at our core, welcoming applications from all backgrounds.

Benefits

Diversity and inclusion initiatives

Collaborative work environment

Qualifications

• 5+ years of experience in Solution Architecture or a similar role.
• Expert proficiency in SQL with experience in data transformations.
• Hands-on experience with modern BI platforms.

Responsibilities

• Identify opportunities for data and AI to drive impact.
• Build intelligent dashboards and data models.
• Translate business challenges into technical requirements.

Skills

SQL proficiency

Data modeling

Analytical design principles

Building dashboards

Business Intelligence tools

Cloud data platforms

Education

Bachelor’s degree in Computer Science, Data Science, Engineering, Business Analytics

Tools

Snowflake

BigQuery

Sigma

Tableau

Power BI

Job description

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!

We have one of the largest and most advanced proprietary data infrastructures in the world, spanning social, customer, and sourced datasets. The next step is transformation — turning that data into scalable, AI-driven solutions that unlock new value for our teams and our clients. We’re seeking a Solution Architect, Data Solutions — part innovator, part engineer, part strategist — who can take this immense data foundation and create global-leading, intelligence-based tools, models, and managed solutions. This is a role for a true builder of applied intelligence, capable of bridging advanced data science with real-world business impact.

What You'll Do Here:

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

You’ll Need To Have:

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

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.