Careers & Skills

Most Analytics Bugs Are Data Bugs. Five Checks That Catch Them Before the Meeting.

Five validation checks every analyst should run before trusting a table: duplicates, NULL key columns, out-of-range values, cross-field arithmetic, orphan references. Tested on a 2,010-row orders table with 50 planted defects; the checks flagged 51 rows, and the misses are as instructive as the catches.

Ibrahim Denis Fofanah·Oct 11, 2026·8 min

Window Functions Are SQL's Most Underused Feature. Five Patterns Cover Nearly Everything.

Five window-function patterns that cover most analytics SQL: dedupe with ROW_NUMBER, top-N per group with RANK, period comparisons with LAG, running totals with explicit frames, bucketing with NTILE. Every query ran and its output is shown; a 200,000-row timing test puts the window function at 0.46s against 5.92s for the equivalent self-join on 5,000 rows.

Ibrahim Denis Fofanah·Oct 6, 2026·8 min

I Filed 49 Data Job Applications in Two Weeks. The Funnel Was the Hard Part.

49 filed applications, 27 distinct portals, 5 fast rejections. What my own September job ledger reveals about junior data hiring in fall 2026.

Ibrahim Denis Fofanah·Oct 1, 2026·7 min

The Data Scientist Role Is Splitting Into Three Jobs. Here's Which One to Become.

The classic data-scientist bundle is unbundling into the analyst, the ML engineer, and the AI engineer. BLS still projects 34% growth, but the generalist entry seat is the one shrinking. Here is how to pick your one.

Ibrahim Denis Fofanah·Sep 25, 2026·7 min

OpenAI Uses 3.1 Agent-Workdays for Every Human Day. The Bottleneck Moved.

OpenAI reports 3.1 agent-workdays for every human research day. That does not mean 3.1× productivity, it means the scarce work has shifted toward judgment.

Ibrahim Denis Fofanah·Sep 25, 2026·13 min

Data Science Is Growing 34.6%. The Entry Door Is Still Getting Narrower.

BLS projects data-scientist employment to grow 34.6% through 2035. That does not mean the first job is easier to get: AI is changing junior work and raising the value of judgment, verification and context.

Ibrahim Denis Fofanah·Sep 18, 2026·7 min

AI Is Broadening Jobs Before Titles Change. The Evidence Is Narrower Than It Sounds.

OpenAI found that some workers repeatedly used AI for tasks outside their occupational boundaries. The signal is real, but the sample is a selected slice of active ChatGPT users, not the workforce.

Ibrahim Denis Fofanah·Sep 17, 2026·8 min

A Portfolio Project Without Tests Is Just a Screenshot

A polished dashboard shows what you built. A tested, rerunnable project shows why the result should be trusted. Here is the minimum audit trail every serious data portfolio needs.

Ibrahim Denis Fofanah·Sep 8, 2026·8 min

AI Won't Replace Data Scientists. It Will Replace Lazy Ones.

AI writes the Python, the SQL and the first draft of the dashboard. It cannot attend your meetings, choose your metric, or be accountable for the decision. A working division of labour, and a churn model that failed for none of the reasons you would expect.

Ibrahim Denis Fofanah·Jul 23, 2026·11 min

Why AI Keeps Rejecting Your Resume, and Why It Is Probably Not Your Resume

Career advice says fix your resume. A peer-reviewed audit of embedding-based resume rankers suggests the rejection is a property of the retrieval system. What is real, what is cargo cult, and what to do.

Ibrahim Denis Fofanah·Jul 18, 2026·7 min

93% of AI Adoption Isn't Happening in AI Jobs

Ibrahim Denis Fofanah·Jul 18, 2026·10 min

Excel or Python First? What Data Analyst Job Postings Actually Say

SQL appears in 80%+ of data analyst postings, Excel in 60%, Python in 50%. Here's the learning order that matches the market, and the trap that costs beginners a year.

Ibrahim Denis Fofanah·Jul 12, 2026·5 min