Published 2026-04-09
Location: 100% Remote (Candidates must be based in Canada and legally authorized to work in Canada)
Start Date: June 2026
Starting Salary: $60,000 CAD.
Year 1 Target Comp: $65,000 to $70,000 (Based on performance and milestone completion)
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 early-career professionals who are motivated by continuous learning, strong professional development, and rapid skill growth.
The program begins with a 30-day technical Bootcamp focused on obtaining two core industry credentials: Snow Pro 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, Big Query, 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 role is designed for early-career professionals, typically within 0-2 years of graduating from a post-secondary program, with consideration for candidates slightly beyond this range who demonstrate strong alignment with the program.
We welcome applicants from Engineering, Math, Statistics, Computer Science, or Business Analytics programs.
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 high-ownership mentality and reliability. You demonstrate strong problem-solving abilities, can manage multiple priorities, and are comfortable working in a fast-paced, remote environment.
Additional Strengths
· Prior experience through internships, co-ops, or personal projects.
· Experience with cloud data warehouses such as Snowflake, Big Query, 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 (Snow Pro 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, we ask that you share a 1-page written response to the technical scenario found below.
To ensure your application is reviewed, please combine your scenario response and resume into a single PDF file. This merged document should be uploaded to the \"Resume\" field on Linked In. 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 Big Query)
· 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:
