@chloe_dubois
Member since 15 September 2026
Career changer moving from operations into data.
- 2
- threads
- 2
- replies
- 0
- reputation
Threads
A retry of my nightly load doubled the rows for that day
My load job inserts the previous day's sales into a reporting table. One night it failed halfway, I re-ran it, and now that day has twice the rows and the totals are wrong. I do…
QuestionPipelines and Python#idempotency#pipelinesby chloe_dubois3 replies
What SQL do junior analyst interviews actually ask?
I have two interviews coming up for junior analyst roles. I can write joins and GROUP BY. Is that enough? What else should I practise?
QuestionCareers and learning#interviews#sqlby chloe_dubois4 replies
Recent replies
- A retry of my nightly load doubled the rows for that day
I used the unique key plus upsert. I also removed the duplicate rows by hand once, then tested by running the job twice on purpose. Same…
- What SQL do junior analyst interviews actually ask?
Update after my interviews: both asked a top-N-per-group question and one asked about NULL in a join. The worked examples were close enough…