PUBLIC ENGINEERING CASE STUDY

An evidence-first job-search operating system.

I built a continuously scheduled pipeline that finds fresh Australian data roles, validates the vacancy, ranks opportunity quality, creates truthful application assets and keeps every human decision visible.

Python · pandas · SQLite · Google Sheets API · Streamlit · Caddy · PowerShell · Telegram

END-TO-END WORKFLOW

From a fresh vacancy to a human-approved application.

The pipeline runs continuously on a Windows VPS. Each stage produces auditable evidence for the next, reports partial failures honestly and stops before any external application or message is submitted.

12 minWATCH

Official company and startup career feeds

35 minSCAN

Primary and secondary job-market discovery

08:00FULL

All eleven stages, Sydney time

18:00EVENING

Refresh, organise, report and plan

01 · SOURCE

Official career intelligence

Reads allowlisted Greenhouse, Lever, Ashby, SmartRecruiters and verified portfolio feeds.

02 · DISCOVER

Indeed + LinkedIn

Runs exact, location-aware searches for the approved role families and title variants.

03 · EXPAND

SEEK + Jora + Adzuna

Adds independent source coverage with bounded retries, timeouts and source-level metrics.

04 · QUALITY GATE

Clean and validate

Rejects expired, duplicate, senior, ineligible or incomplete vacancies and validates the live JD.

05 · BUILD

Rank and tailor

Scores the correct base resume, then builds a truthful package only where it can improve the match.

06 · NOTIFY

High-match alerts

Sends time-sensitive Telegram alerts for qualified fresh jobs, without applying automatically.

07 · FOLLOW UP

Day 3 / 7 / 14

Surfaces due follow-ups from recorded application dates while preserving manual message approval.

08 · ORGANISE

Sort the CRM

Colours and orders the Sheet by expiry, status, freshness, priority and application readiness.

09 · PLAN

Career Agent + sprint

Creates the daily apply, tailor, follow-up, contact and interview-preparation scorecard.

10 · LEARN

Market intelligence

Builds employer, semantic-fit, startup, portfolio, research and outcome evidence locally.

11 · CONNECT

Contact intelligence

Ranks up to five verified decision makers and prepares bounded, approval-only referral drafts.

FRESHNESS≤36 hours

Fresh vacancies lead the queue; the sprint highlights approved roles at ≤24 hours.

ROLE + ELIGIBILITYTargeted and truthful

Seniority, work rights, location, employment type and mandatory experience are checked before tailoring.

ATS QUALITY42/60 raw · 70%

The higher-scoring truthful resume wins; unsupported skills or experience are never invented.

EXTERNAL ACTIONHuman approval

Rahul reviews the resume, submits the application and approves every contact message.

CONTROL PLANEGoogle Sheets CRMPrivate dashboard
APPLICATION ASSETSTailored resume PDFCover letter + evidence
OBSERVABILITYTelegram run reportLogs + source metrics
HUMAN LOOPReview → apply → update status

Outcomes return to follow-ups, analytics and the next daily plan.

ENGINEERING EVIDENCE

Built for failure, not just the happy path.

External job sources are noisy and transient. The design makes degraded sources explicit, persists run state before notification delivery and keeps automation recoverable.

Freshness-first

Jobs are timestamped, tiered and sorted so newly posted opportunities cannot be buried by older inventory.

Truthful ATS tailoring

Resume language is constrained to candidate evidence; missing requirements remain visible instead of being invented.

Operational resilience

Restartable Windows services, bounded timeouts, atomic artifacts and source-level run metrics support unattended operation.

Private by default

The command centre, job records, resumes, contacts and credentials remain behind authentication. This case study contains no private pipeline data.

DESIGN DECISIONS

Automation accelerates judgment; it does not replace it.

01

No auto-apply

A human reviews every resume and submits every application. This prevents low-quality volume from outrunning evidence.

02

No automatic cold outreach

Contacts must be professionally relevant and verifiable; messages remain approval-only and bounded.

03

Observable degradation

A partial source failure is reported as degraded—not silently presented as a successful full-market scan.

04

AI with deterministic controls

AI-assisted drafting is surrounded by fixed gates, validation, tests and explicit safety rules.

LET'S TALK

I’m looking for a team where data engineering and practical product thinking meet.