A Systematic Approach to the Technical Interview Process

A Systematic Approach to the Technical Interview Process is about the non-code half of being a successful data professional. Careers are built on communication, judgement and sustained learning as much as on algorithms; this lesson helps you invest in those skills deliberately.

Why Systematic Approach Technical Matters

Technical skills get you hired; these skills are what make you effective, promotable and resilient across the ten- to twenty-year arc of a career.

• Write the way you think — long-form writing sharpens judgement.
• Invest in feedback loops with peers and mentors.
• Ship public artefacts (blogs, talks, open source) to build credibility.
• Optimise for compounding: depth now, options later.

How Systematic Approach Technical Shows Up in Practice

In a typical project, a systematic approach to the technical interview process is combined with the rest of the Career & Leadership toolkit. You rarely use any one technique in isolation; the real skill is knowing which combination fits the problem you are trying to solve, and being able to explain that choice to a non-technical stakeholder.

Relevant from your first promotion conversation through to founding your own company or leading a research group.

• Communicating Strategic Vision Enterprise Data Assets
• Narrative Frameworks for Data-driven Communication
• Methodologies of Transfer Learning and Domain
• Architectural Patterns for Data-intensive Applications

Back to the Data Science curriculum →

# Example 1: Weekly deep-work time tracker -- A Systematic Approach to the Technical
import pandas as pd

logs = [
    ("2026-04-20 08:30", "2026-04-20 11:15", "research"),
    ("2026-04-20 13:00", "2026-04-20 15:30", "coding"),
    ("2026-04-21 09:00", "2026-04-21 10:00", "meetings"),
    ("2026-04-21 10:30", "2026-04-21 13:00", "coding"),
    ("2026-04-22 09:30", "2026-04-22 12:30", "writing"),
]

df          = pd.DataFrame(logs, columns=["start", "end", "category"])
df["start"] = pd.to_datetime(df["start"])
df["end"]   = pd.to_datetime(df["end"])
df["hours"] = (df["end"] - df["start"]).dt.total_seconds() / 3600

by_cat = df.groupby("category")["hours"].sum().sort_values(ascending=False)
print(by_cat.round(2))
print(f"\ntotal deep-work hours this week: {df['hours'].sum():.1f}")

# Example 2: Interview-prep spaced repetition scheduler -- A Systematic Approach to the Technical
from datetime import date, timedelta

topics = {
    "sql-window-functions":          {"ease": 2.3, "last": "2026-04-10"},
    "bias-variance-tradeoff":        {"ease": 2.5, "last": "2026-04-18"},
    "transformer-attention":         {"ease": 2.1, "last": "2026-04-05"},
    "ml-system-design-recommender":  {"ease": 1.8, "last": "2026-04-01"},
}

today = date.fromisoformat("2026-04-22")
plan  = []
for topic, info in topics.items():
    interval = max(1, int((info["ease"] - 1.3) * 6))
    next_due = date.fromisoformat(info["last"]) + timedelta(days=interval)
    overdue  = (today - next_due).days
    plan.append((topic, next_due, overdue))

plan.sort(key=lambda row: -row[2])
print(f"{'topic':<32} {'next review':<12} overdue days")
for topic, d, over in plan:
    print(f"{topic:<32} {str(d):<12} {over:>+4}")

# Example 3: Portfolio project impact scoring -- A Systematic Approach to the Technical
import pandas as pd

projects = pd.DataFrame([
    {"name": "Churn model v2",        "impact_usd":  420_000, "effort_days": 35, "visibility": 4},
    {"name": "Exec KPI dashboard",    "impact_usd":   80_000, "effort_days": 10, "visibility": 5},
    {"name": "Data quality tooling",  "impact_usd":  160_000, "effort_days": 22, "visibility": 2},
    {"name": "Recommender rewrite",   "impact_usd": 1_100_000, "effort_days": 80, "visibility": 5},
])

projects["roi_per_day"] = projects["impact_usd"] / projects["effort_days"]
projects["score"]       = (0.6 * projects["roi_per_day"].rank(pct=True)
                         + 0.4 * projects["visibility"].rank(pct=True))
print(projects.sort_values("score", ascending=False).round(2))

# Example 4: Role-level salary benchmarking -- A Systematic Approach to the Technical
import numpy as np
import pandas as pd

rng = np.random.default_rng(0)
df  = pd.DataFrame({
    "role":      rng.choice(["Analyst", "Scientist", "ML Engineer", "Director"], 400),
    "years_exp": rng.integers(0, 18, 400),
    "region":    rng.choice(["NA", "EU", "APAC"], 400),
    "base_usd":  rng.normal(145_000, 32_000, 400).clip(60_000, 350_000).round(-2),
})

summary = (
    df.groupby(["role", "region"])
      .agg(median=("base_usd", "median"),
           p25=("base_usd", lambda s: s.quantile(0.25)),
           p75=("base_usd", lambda s: s.quantile(0.75)),
           n=("base_usd", "count"))
      .round(0)
)
print(summary)

# Example 5: Personal skill-gap prioritisation -- A Systematic Approach to the Technical
import pandas as pd

required = pd.Series({
    "python": 4, "sql": 4, "statistics": 4, "ml_modeling": 4,
    "deep_learning": 3, "mlops": 3, "communication": 4,
    "leadership": 3, "business_acumen": 3, "product_sense": 3,
})
current = pd.Series({
    "python": 4, "sql": 3, "statistics": 3, "ml_modeling": 3,
    "deep_learning": 2, "mlops": 1, "communication": 3,
    "leadership": 2, "business_acumen": 2, "product_sense": 2,
})

gap = (required - current).sort_values(ascending=False)
print("priority skills to invest in (desc):")
for skill, g in gap[gap > 0].items():
    print(f"  {skill:<18} +{g} levels")