Associate Analytics Consultant: New Consultant Accelerator Program (NCAP)

About DSC

DSC is a fast-growing analytics consulting firm helping organizations modernize their data infrastructure, improve reporting, and unlock actionable insights. We work across industries to design, build, and optimize data pipelines, cloud data warehouses, and business intelligence systems. Our clients range from early-stage startups to large enterprise organizations.

We focus on boutique attention and enterprise-grade impact, ensuring our clients can trust their data to drive their decision-making. We pride ourselves on transparent communication and building scalable platforms using modern data stacks and industry-leading BI solutions.

The Role and Program Overview

We are hiring our first cohort for the New Consultant Accelerator Program (NCAP). This is a structured, 12-month pathway designed for emerging analytics professionals who are motivated by continuous learning, rigorous professional development, and rapid technical growth.

The program begins with a 30-day technical bootcamp focused on obtaining two core industry credentials: SnowPro Core and dbt Analytics Engineering certifications. Following the bootcamp, you will work directly with our Senior Consultants on client-facing projects involving data ingestion, modeling, warehousing, and visualization. Given we work across various sectors, you will gain rapid exposure to multiple industries and diverse technologies. Over the course of 12 months, you will transition from supporting delivery to independently managing your own client workstreams.

Key Responsibilities

Data Engineering: Build and maintain data pipelines using Python and APIs.

Modeling and Architecture: Model and transform data using SQL and modern warehousing practices. Develop and optimize cloud data warehouses, including Snowflake, BigQuery, and Databricks.

Business Intelligence: Build insightful dashboards using Power BI, Tableau, or Looker.

Consulting: Translate business requirements into technical data solutions and present findings and recommendations to clients.Governance: Maintain documentation and ensure data quality standards.

Who This Program Is Designed For

This program is specifically designed for aspiring data consultants who are ready to bridge the gap between academic theory and high-impact professional services. We are looking for individuals launching their professional data careers who possess a strong quantitative foundation and are motivated by an accelerated learning path designed to build recognized industry expertise.

Education

A completed post-secondary degree in a quantitative field (e.g., Engineering, Mathematics, Statistics, Computer Science, or Business Analytics).

Core Capabilities

Technical Foundation: Strong SQL fundamentals and a working knowledge of Python for data transformation. You should have a foundational understanding of data modeling principles.

Communication: Strong written and verbal communication skills. You are capable of clearly explaining technical concepts to both technical and non-technical audiences, with the ability to adapt within teams and in client-facing environments.

Mindset: A proactive, high-ownership mindset with a focus on reliability. You are comfortable navigating ambiguity through strong problem-solving skills and can manage multiple client workstreams in an agile, remote setting.

Additional Strengths

Prior experience through internships, co-ops, or personal projects.
Experience with cloud data warehouses such as Snowflake, BigQuery, or Databricks.
Previous exposure to consulting or client-facing work, demonstrating active listening and a client-oriented mindset.
Participation in case competitions, hackathons, or analytics competitions.

Your Growth & Benefits

Bootcamp Incentives: We offer a $500 bonus for each industry certification (SnowPro Core and dbt Analytics Engineering) completed during your first month.

Health and Wellness: Comprehensive group benefits package.

Flexible Time Off: We offer a flexible vacation policy that empowers you to take time off beyond statutory minimums as needed, trusting our team to balance their well-being with their client commitments and work responsibilities.

Structured Mentorship: Direct collaboration and code reviews with Senior Consultants, alongside regular 1:1 sessions with Leadership to build your technical and professional capabilities.

Defined Growth: A clear 12-month roadmap to ensure your progression from Associate to Consultant remains on track.

How to Apply

At DSC, we value clear thinking, structured problem-solving, and concise communication. In lieu of a cover letter, please submit your resume and a structured written response (maximum 1 page, PDF format) to the technical scenario below to careers@datasolutionsinc.ca. Candidates whose submissions align with the core capabilities of the role will be contacted regarding next steps in our selection process.

Scenario:

You are working on an active client project where DSC is building a reporting solution for sales and customer performance. The overall architecture has already been set up, including:

A cloud data warehouse (e.g., Snowflake or BigQuery)
Initial data ingestion from a CRM and billing system
A draft data model and early version of a dashboard

However, the solution is still in progress.

You’ve been assigned a task to refine part of the reporting layer, specifically to improve the accuracy of key metrics (e.g., revenue, active customers, and pipeline stages) and prepare an updated dashboard view for internal review.

As you begin, you notice:

Some fields are inconsistently populated across source systems
Certain metric definitions are unclear or possibly inconsistent with how the client expects to see them
Documentation is incomplete

The Senior Consultant leading the project is unavailable for the next two hours, but the client is expecting an end-of-day update summarizing progress, key findings, and any risks or open questions.

Question:

Describe step-by-step how you would approach this situation, including:

How you would get started given the current state of the project?

How you would validate and refine key metrics despite unclear definitions?

How you would handle inconsistent or messy data?

How you would prioritize your time to deliver meaningful progress by end of day?

Explain how you would communicate progress, assumptions, and risks to both your internal team and the client. Please provide the specific text or bullet points of the update email you would send to the client to summarize your findings and next steps?

One challenge you expect to encounter in this situation and how you would address it?

DSC is committed to providing accommodations for people with disabilities throughout the recruitment process. If you require a suitable accommodation at any stage of the selection process, we will work with you to meet your accessibility needs. To request an accommodation, please contact: careers@datasolutionsinc.ca

Location

Toronto, Canada

Start Date

June 2026

Starting Salary

$60,000 CAD

Job Type

Full time