Sellers & Associates · Data Scientist
Updated · 2026-09-22

Sellers & Associates Data Scientist
Interview Questions & Guide 2026

THE 60-SECOND BRIEF

As a Data Scientist at Sellers & Associates, you will serve as a critical bridge between advanced machine learning capabilities and the high-stakes operational requirements of the U.S. Navy. Your work directly supports NAVWAR mission objectives, focusing on how data exploitation, predictive analytics, and AI-enabled automation can enhance fleet readiness, cybersecurity, and command-and-control efficiency. You aren't just building models; you are crafting tools that directly impact national defense outcomes.

Nearly every loop contains a round whose deliverable is a recommendation to someone non-technical. Practise stating a conclusion, the confidence attached to it, and the cost of being wrong in each direction, because that triple is the artifact being graded.

PracHub has no confirmed round sequence for Sellers & Associates. Treat the sections below as preparation areas and confirm the format with your recruiter.

Design outputs that survive public disclosureAudit disparate impact before any model shipsDefend small-area rates against denominator noise

30 min read

Browse Data Scientist questions

See the practice prompts

12Practice promptsAcross five skill areas
3With worked solutionsIncluded in the practice prompts

As a Data Scientist at Sellers & Associates, you will serve as a critical bridge between advanced machine learning capabilities and the high-stakes operational requirements of the U.S. Navy. Your work directly supports NAVWAR mission objectives, focusing on how data exploitation, predictive analytics, and AI-enabled automation can enhance fleet readiness, cybersecurity, and command-and-control efficiency. You aren't just building models; you are crafting tools that directly impact national defense outcomes.

This role is inherently strategic and collaborative. You will be expected to translate complex technical findings into actionable insights for both technical peers and non-technical government stakeholders. By designing and deploying robust AI/ML models within government-approved, secure environments, you ensure that Sellers & Associates remains at the forefront of providing custom, high-quality engineering support services that meet the unique, evolving needs of our military clients.

Given the nature of our work with government clients, ensure your preparation emphasizes security-mindedness and the ability to work within the constraints of DoD data governance and Responsible AI (RAI) principles.

01

Preparation focus

editorial

No round sequence has been reported for this company, so work the categories below and confirm the format with your recruiter.

What to demonstrate

  • Breadth across SQL, experimentation and product reasoning
  • Ability to state assumptions before choosing a method

How to prepare

  • Drill the practice exercises below and time yourself
  • Prepare three quantified stories about decisions you drove
PracHub interview preparation framework ↗

PracHub editorial advice for the preparation topics above.

01

Suppressing one small cell in a published table and leaving the row and column totals in place

A single suppressed cell is recoverable by subtracting the published cells from the published margin, so primary suppression without complementary suppression protects nothing. Two separately published tabulations of the same underlying data compose as well, meaning two individually safe releases can jointly identify a cell. Either apply complementary suppression across the whole table and check it against the margins, or use a formal mechanism with an accounted budget, remembering that Laplace noise for a count query is scaled to sensitivity over epsilon, that sequential releases add their epsilons, and that noisy counts are not automatically non-negative or additively consistent across aggregation levels until post-processed.

02

Reporting mean or median days to decision over cases that have already been decided

Cases still open at the extract are exactly the slow ones, so restricting to decided cases is length-biased. The pathology is that the metric improves as the backlog of hard cases grows, because those cases are excluded from the sample precisely while they are getting worse. Treat undecided cases as right-censored at (extract_date - submitted_at) and use a Kaplan-Meier estimate, or report the cohort completion curve at fixed horizons such as share decided by day 30 and day 90.

03

Optimising accuracy on a heavily imbalanced target

State the base rate first, then choose the metric from the relative cost of a false positive against a false negative: precision and recall at the operating threshold, PR-AUC, or expected cost. At a 1 percent positive rate, predicting the majority class for everyone scores 99 percent accuracy and is worthless.

04

Reporting a p-value with no effect size or interval

Give the estimated difference with a confidence interval in the units the business cares about, then say whether that whole interval is worth acting on. A p-value only addresses whether you can rule out exactly zero; it says nothing about magnitude.

Choose a category, try a prompt, then open its approach, worked solution or follow-up when you need it.

9 technical prompts3 include a worked solution

How do you ensure your models are reproducible and compliant with stri…

medium
machine learning and modelling

How do you ensure your models are reproducible and compliant with strict data governance standards?

Approach
  1. Set a baseline first, so any model has something honest to beat.
  2. Say how the offline result would be validated online before it is trusted.
  3. Pick an evaluation metric that matches the cost of each error type, not a default.
Follow-up
  • What would you monitor after launch to know the model is still valid?
  • How would you choose the decision threshold, and who owns that choice?

What specific steps do you take to evaluate model performance beyond s…

medium
machine learning and modelling

What specific steps do you take to evaluate model performance beyond simple accuracy metrics?

Approach
  1. Set a baseline first, so any model has something honest to beat.
  2. Pick an evaluation metric that matches the cost of each error type, not a default.
  3. Check what information would not exist at prediction time, and exclude it.
Follow-up
  • What would you monitor after launch to know the model is still valid?
  • How would you choose the decision threshold, and who owns that choice?

Explain your process for feature engineering when dealing with unstruc…

medium
machine learning and modelling

Explain your process for feature engineering when dealing with unstructured data in a defense-related context.

Approach
  1. Say how the offline result would be validated online before it is trusted.
  2. Set a baseline first, so any model has something honest to beat.
  3. Frame the prediction: the label, the moment of prediction, and the action it triggers.
Follow-up
  • Where could label leakage enter this setup?
  • How would you choose the decision threshold, and who owns that choice?

Kaplan-Meier days to decision with Greenwood standard errors

mediumWorked solution
survival analysisright censoringgreenwood

apps has application_id, submitted_at, decision_at (NaT while open) and status, and you have a scalar extract_date. Estimate time from submission to decision in days using a Kaplan-Meier survivor function written from scratch. Rows still in status 'submitted' or 'pending_evidence' are right-censored at extract_date minus submitted_at. Return S(t) with Greenwood standard errors, the median, and S at 30, 60 and 90 days. Report the mean over decided rows alongside it. No lifelines and no statsmodels.

Approach
  1. Build duration and an event indicator in one pass: decided rows get event = 1 with duration = (decision_at - submitted_at).days, open rows get event = 0 with duration = (extract_date - submitted_at).days. Count negative durations from backdated decisions and report them rather than clipping to zero, which would invent same-day decisions.
  2. Assemble the risk table: distinct durations ascending, d_i events at each, c_i censored at each, and n_i at risk. Use the standard tie convention that observations censored at time t are still at risk at t, so events are credited before censoring at the same duration.
  3. S(t) is the cumulative product of (1 - d_i / n_i) over event times up to t. Greenwood gives Var(S(t)) = S(t)^2 * sum(d_i / (n_i * (n_i - d_i))) over the same times. Each term of that sum grows as n_i thins, but the sum is multiplied by a falling S(t)^2, so the standard error is not monotone in t: it climbs early, peaks in the interior of the curve, and falls again once S(t) is small. Guard the term where n_i == d_i, which divides by zero at a last event that empties the risk set.
  4. Median is the smallest t with S(t) <= 0.5. If the curve never crosses 0.5 inside observed follow-up, return 'not reached'. Substituting the largest duration there is the same mistake as dropping censored rows, in a different costume.
  5. Put the decided-only mean next to it and state the mechanism, not just the gap: open cases are disproportionately the slow ones, so restricting to decided rows is length biased and the bias grows as the backlog grows.
Worked solution 35 min
  1. Compute duration_days and event for every row, and separately count and report rows with negative durations.
  2. Aggregate to a risk table with columns t, d, c, then derive n as total minus the cumulative sum of (d + c) shifted by one.
  3. Cumulative-product the survival factors for S(t), and cumulative-sum the Greenwood terms before multiplying by S(t)^2 and taking the square root, with an explicit branch for n_i == d_i where the term is undefined and S(t) is already 0.
  4. Read off the median by scanning for the first t with S(t) <= 0.5, and interpolate S at 30, 60 and 90 by taking the last event time at or below each.
  5. Compute the decided-only mean and median and return everything in one summary dict.
EXPECTED RESULTS(t) starting at 1 and non-increasing, a Kaplan-Meier median at or above the decided-only median, S(30), S(60) and S(90) each with a Greenwood standard error, and the string 'not reached' rather than a number when the curve stays above 0.5 through the longest observed follow-up.
Follow-up
  • Two programs report the same Kaplan-Meier median but S(30) differs by 15 points. Which do you escalate, and what do you ask for first?
  • A case can also exit by withdrawal or administrative closure. What does a single curve on 'any exit' get wrong, and what estimator replaces it?
  • Decision events are sometimes backdated by up to three weeks. Which direction does that move the curve, and how would you bound the effect?

Roughly 90 minutes a night on weekdays with one longer weekend block. The plan deliberately cuts scope rather than compressing everything, on the assumption that finishing one thing a night beats half-starting four.

Small steps. Visible outcomes.0 / 7 completed
ONE WEEK · YOUR PACE

Prepare, practise & reflect

One practical outcome each day. Spend longer where you need it.

0 / 7 done
01Fix the scope and set a baseline
  • Read the role description and write the three things the loop will almost certainly test, then write an explicit not-doing list for everything else and keep it visible all week.
  • Take one 20-minute SQL prompt and one 10-minute metric question cold, and write the single sentence that says what blocked each attempt, since that sentence is what decides which two topics get the most evenings.
  • Set the week's one rule: one problem finished to completion every night, including the night you only have 40 minutes.

Deliverable: A one-page scope with an explicit not-doing list and two cold attempts, each carrying one sentence on what blocked it.

Practice prompt ↗Practice prompt ↗Worked solution ↗
02One query pattern, written three times
  • Choose the single pattern most likely to appear (a cohort retention grid, or a funnel counted by user) and write it three times from a blank file rather than editing the previous attempt.
  • On the third attempt, write the grain of every CTE as a comment before writing its body.
  • Stop at 90 minutes even if the third version is imperfect, and write the one thing you would fix with another hour.

Deliverable: Three independent versions of the same query plus a note on what changed between them.

Practice prompt ↗Practice prompt ↗
03Only the statistics you will be asked to defend
  • Write, in under 200 words, how you would decide whether a difference between two groups is real: the test, its assumptions, and what you would switch to when an assumption fails.
  • Compute a 95 percent confidence interval for a difference in proportions by hand on realistic numbers, then write in one sentence what changes if the two samples are paired rather than independent.
  • Write your answer to "what does a p-value mean", check it against a definition, and delete the version that describes it as the probability the hypothesis is true.

Deliverable: A 200-word written answer and one hand-computed interval you can reproduce under pressure.

Practice prompt ↗Practice prompt ↗
04One case, and the assumptions holding it up
  • Answer one product case aloud in 20 minutes with a recording running, then listen back with a pen and mark every claim you asserted without saying what it rested on: an assumed user behaviour, an assumed data source, an assumed baseline rate, an assumed grain.
  • Pick the three assumptions the recommendation actually depends on, write how you would check each one against data, and say which one being wrong would flip the recommendation rather than merely weaken it.
  • Write the four-step structure you used onto a card small enough to hold in working memory when you are nervous.

Deliverable: One recording, three load-bearing assumptions each with a written check, and a four-step structure card.

Practice prompt ↗Practice prompt ↗Worked solution ↗
05Your own work, timed
  • Write a 90-second version and a four-minute version of your main project, and time both out loud rather than reading them.
  • Prepare answers to the two follow-ups that always come: what you would do differently, and how you knew it worked.
  • Put one number in the first sentence and be able to say exactly where that number came from and what it excludes.

Deliverable: Two timed narratives with one defensible number in the opening line.

Practice prompt ↗Practice prompt ↗
06The one full rehearsal, in a longer weekend block
  • Run a 60-minute mock covering query work, a case and a behavioural question in a single sitting with no breaks, because sustained attention is the thing evenings have not trained.
  • Immediately afterwards, and before hearing any feedback, write the three moments you lost the thread.
  • Spend the rest of the block only on those three moments, and on nothing you merely feel shaky about.

Deliverable: Mock notes naming three failure moments with a specific fix written under each.

Practice prompt ↗
07Taper
  • Write the 20-minute warm-up you will actually do on the morning of the interview: one query you can already write from a blank file, one metric you can define out loud, and nothing you have never seen before.
  • Re-read only your own notes from this week, and open no new material.
  • Write down the logistics: the tool you will be asked to work in, whether lookups are allowed, and the sentence you will use when you do not know something.

Deliverable: A one-page card holding the case structure, the project numbers, and the logistics.

Practice prompt ↗Worked solution ↗

Expand any day for tasks and deliverables. Your progress is saved on this device.

Interviewers here are not checking whether you can describe a project. They want the decision you made, why you made it under the information you had, and what changed afterwards that someone else could measure. A story that ends at 'I built a model' has no ending. Say what the model caused, or what you stopped doing because of it.

How do you handle imbalanced datasets when training classification mod…

medium
behavioural and stakeholder questions

How do you handle imbalanced datasets when training classification models for operational anomalies?

Approach
  1. State the situation in two sentences and spend the rest on your reasoning.
  2. Close with what you would do differently, concretely.
  3. Quantify the outcome, including what you would not claim credit for.
Follow-up
  • What would you do differently if you ran that project again?
  • How did you know the outcome was caused by your change?

Can you describe a time you had to choose between a complex deep learn…

medium
behavioural and stakeholder questions

Can you describe a time you had to choose between a complex deep learning model and a simpler statistical approach? What was the outcome?

Approach
  1. Pick a story where you drove the decision, not one where you observed it.
  2. Name the disagreement or constraint, and how you resolved it with evidence.
  3. Quantify the outcome, including what you would not claim credit for.
Follow-up
  • What did you decide not to do, and why?
  • How did you know the outcome was caused by your change?

Turn "how many people are we missing" into a scoped estimate

easy
scopingcoveragestakeholder communication

A programme director stops you and asks, "how many people are we missing?" You have fact_application, dim_constituent and dim_geography and nothing else. Before writing any SQL you owe her a written scope in thirty minutes: the question restated as something estimable, the denominator you will build and where it comes from, what the data cannot tell her, and a delivery date. Produce that scope note in under 300 words, plus the three clarifying questions whose answers would change the estimate.

Approach
  1. Restate the request as a coverage estimand before negotiating anything else: distinct constituent_id with status = 'approved' and decision_at inside a named program year, over a modelled count of eligible constituents in the same geography and year. Say out loud that the denominator cannot come from fact_application, because every row there belongs to someone who already found the system.
  2. Write the three questions whose answers move the number by more than the analysis will: which program_code and which rule_version_id define eligibility, which geo_level and vintage_year is the denominator drawn at, and whether "missing" means never created an application, created one but has submitted_at IS NULL, or was denied on a procedural denial_reason_code. Those are three different interventions and only the first is a pure outreach problem.
  3. Name the denominator pipeline concretely: survey microdata plus a microsimulation of the eligibility rule in force at that rule_version_id, with the income and household definitions stated because reported_income_cents in the administrative table is self-reported and heaps on round values.
  4. State the non-answers before they are asked for: the estimate is a count, not a list of people, and the gap cannot be attributed to a cause without a design.
  5. Commit to a date and offer an interim artefact on day one, the funnel from created_at to submitted_at to decision_at by channel, so the director has something concrete while the denominator is built.
Follow-up
  • The director asks for the names of the people who are missing so outreach can call them. What do you say, and what could you legitimately produce instead?
  • Your modelled eligible population comes out 40 percent above the applicant count. What checks do you run before anyone sees that number?
  • 01

    How do you handle imbalanced datasets when training classification models for operational anomalies?

  • 02

    Can you describe a time you had to choose between a complex deep learning model and a simpler statistical approach? What was the outcome?

  • 03

    A programme director stops you and asks, "how many people are we missing?" You have fact_application, dim_constituent and dim_geography and nothing else. Before writing any SQL you owe her a written scope in thirty minutes: the question restated as something estimable, the denominator you will build and where it comes from, what the data cannot tell her, and a delivery date. Produce that scope note in under 300 words, plus the three clarifying questions whose answers would change the estimate.

PracHub interview preparation framework ↗
Is this an official Sellers & Associates interview guide?

No. It is PracHub's own research and practice material for the Data Scientist role at Sellers & Associates. Rounds and questions reflect what candidates have reported, not a process Sellers & Associates has published, and they change over time. Confirm the current format and scope with your recruiter.

PracHub interview research ↗
How long does the interview process typically take?

The timeline can vary depending on contract requirements and security clearance verification, but we aim for an efficient process. Most candidates progress from the initial screen to a final decision within a few weeks.

PracHub interview research ↗
What is the most important trait for a candidate to demonstrate?

Beyond technical skill, we look for adaptability. The ability to take a high-level operational goal and translate it into a specific, executable data project is what differentiates top-tier candidates.

PracHub interview research ↗
Is this role primarily remote?

This position is based in the San Diego/Coronado area to support local NAVWAR mission objectives. While some flexibility may exist, the nature of the work generally requires a physical presence to interact with secure systems and mission teams.

PracHub interview research ↗
How much does the interview focus on coding?

Expect a mix of conceptual whiteboard-style problem solving and practical coding questions focused on Python and data manipulation. We want to see how you think through a problem, not just that you know the syntax.

PracHub interview research ↗
Sources & methodology 3 sources ↗

No official company page is cited. Rounds and questions come from candidate reports and PracHub editorial material; each source shows the date it was read.