SelectFromData

Your career at SelectFromData

The Consulting Path

Robin Vale · Principal · SelectFromData

Welcome to the firm. You'll work across five clients — a manufacturer, a bank, an energy utility, a care network, and a global reinsurer. Start with the junior engagements; deliver well and you'll earn the rank to take on the harder work.

Your first assignmentDay One: Read the Order LogNorthforge Industrial · 12 minStart →
The guided path to this assignment:0/18 done
Junior
Medior
Senior
Principal
0★ earned
3★ to Medior

Principal requires at least 2 Senior engagements.

Your engagements

Pick a client and deliver. This is the career path — each engagement is a hands-on SQL exercise. The level badge tells you the SQL it needs.

New to SQL? Engagements assume you can already write queries. You can dive straight inand lean on each engagement's prep panel — or build the basics first.

Totally new? Start with SQL from Zero (45 min) →

Northforge Industrial

Manufacturing & Supply Chain

A heavy-equipment manufacturer. Carriers, inventory, and a sales review that has to be right before the quarterly board.

Inside Northforge Industrial

Northforge builds compressors and mining rigs across nine countries. Its supply chain runs on spreadsheets that became systems that became a pipeline nobody fully understands anymore.

The people. Marco runs operations and wants answers, not caveats; Ina is the analyst who reads the data closely; Petra negotiates the carrier contracts your findings decide; Sef, the plant director, is who it escalates to.

Your remit. The factory floor is unforgiving — a wrong number means a stockout or an overpaid carrier. Your job is to make the data as reliable as the machines.

  1. Day One: Read the Order Log

    JuniorBeginner SQLFree

    12 min · 4 rounds

  2. The First Sales Report

    JuniorBeginner SQLFree

    20 min · 2 rounds

  3. The Carrier Performance Audit

    MediorIntermediate SQLFree

    Reach Medior — 3★ away to unlock

  4. The Annual Sales Review

    MediorIntermediate SQLFree

    Reach Medior — 3★ away to unlock

  5. Meet the Mart: Your First Star Schema

    MediorIntermediate SQLFree

    Reach Medior — 3★ away to unlock

  6. The Freshest Number Wins

    MediorIntermediate SQLFree

    Reach Medior — 3★ away to unlock

  7. The Stockout That Can't Happen Again

    MediorIntermediate SQLFree

    Reach Medior — 3★ away to unlock

  8. The Pipeline That Dropped Rows

    SeniorIntermediate SQLFree

    Reach Senior — 10★ away to unlock

Keystone Bank

Banking & Investments

A retail and investment bank. Monday standups, finance reconciliations, and a marketing team that wants attribution.

Inside Keystone Bank

Keystone is a 150-year-old Amsterdam bank that bolted a modern investment arm onto a mainframe core. The data warehouse is where those two worlds collide — and where the numbers quietly go wrong.

The people. Saskia owns the client relationships and the deadlines; Tom owns the data and the skepticism; Yara is the analyst who actually finds the bug. Olef, the CFO, only appears when real money is on the line.

Your remit. Every engagement here is the same fight in a new costume: the business trusts the dashboard, the dashboard trusts the warehouse, and the warehouse can't be trusted. You are the one closing that gap.

  1. The Weekly Portfolio Overview

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  2. The Budget Overrun Investigation

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  3. The Attribution Argument

    SeniorIntermediate SQL Pro

    Reach Senior — 10★ away to unlock

  4. The Dimension That Broke

    SeniorIntermediate SQL Pro

    Reach Senior — 10★ away to unlock

  5. The Number That Changed Over the Weekend

    SeniorIntermediate SQL Pro

    Reach Senior — 10★ away to unlock

Helios Energy

Energy & Utilities

A consumer energy utility moving into home plans and EV charging. Growth, workforce, and a leaky signup funnel.

Inside Helios Energy

Helios is a utility reinventing itself as a consumer tech company — home energy plans, EV charging, an app with a million signups. Growth is fast, the data model is faster, and nothing is quite consistent yet.

The people. Alex chases commercial growth; Jade builds the data platform under his feet; Rens wants every funnel number yesterday; Paula keeps the workforce side honest when the others are distracted by the curve.

Your remit. Hypergrowth hides its sins in averages. You are the one pulling the real signal out of a company moving too fast to check itself.

  1. The MRR Growth Story

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  2. The Attrition Number Doesn't Add Up

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  3. The Checkout Funnel Leak

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  4. The Sessions That Vanished

    SeniorIntermediate SQL Pro

    Reach Senior — 10★ away to unlock

Lumen Care

Health & Patient CRM

A care network with clinics and a pharmacy arm. Clinician workload and patient retention, where the data is sensitive.

Inside Lumen Care

Lumen runs a network of clinics and a pharmacy arm, where the data is sensitive and the stakes are human. Patient records, clinician workload, retention — every query touches someone's care.

The people. Dr. Patel guards clinical integrity and pushes back hard; Rik runs the data platform; Ana bridges the two as clinical analyst; Tess drives patient retention from the commercial side.

Your remit. Here a data error isn't a wrong dashboard — it's a doctor overloaded or a patient quietly lost. Precision and privacy are not optional.

  1. The Doctor Workload Review

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  2. The Segmentation the Retention Team Needs

    SeniorIntermediate SQL Pro

    Reach Senior — 10★ away to unlock

  3. The Capacity Cliff

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

  4. Two Systems, One Board Report

    MediorIntermediate SQL Pro

    Reach Medior — 3★ away to unlock

Aegis Re

Global Reinsurance & Specialty Risk

A top-five global reinsurer and specialty (re)insurer. Catastrophe treaties, claims leakage, and a multi-currency book where every number lands in front of a regulator.

  1. The Leakage Nobody Booked

    PrincipalIntermediate SQL Pro

    Reach Principal — 30★ away to unlock

  2. The Renewal Year That Lied

    PrincipalIntermediate SQL Pro

    Reach Principal — 30★ away to unlock

  3. One Storm, Counted Twice

    PrincipalIntermediate SQL Pro

    Reach Principal — 30★ away to unlock

Prefer to free-play? Every engagement is also in the case library.