EENSEK · AI Workforcebuilt by It's Sorted
Open vacancy · ENSEK is hiring this

Product Manager — Payments & Refund

Payments, arrears & refunds PM · vacancy

Here's what AI can do for this role — and what still needs a human. Built straight from ENSEK's own job advert, running live on my_db.ensek_demo.accounts. Not a slide about AI. The job, getting done.

What the AI does

Every line on the left is lifted from ENSEK's actual job ad. If a card lacks a harvested JD line, it is omitted. On the right is the AI doing it — with eligible cards running live against the warehouse and offline inspection clearly labelled in the workspace.

Their job ad asks

“Own the strategy, vision and roadmap for payment and refund processing — engaging users, stakeholders and commercial partners to define, validate and iterate it continuously, using competitive intelligence and AI tools to inform positioning.”

AI delivers, live

What's the shape of the arrears book — how many accounts, what segments, and what's the revenue at risk?

table
Their job ad asks

“Drive internationalisation of payment capabilities, ensuring the platform supports compliant payment processing across each regulatory jurisdiction without bespoke builds.”

AI delivers, live

How is the book balanced — what share of active accounts are in credit versus in debt, and by how much?

bar chart
Their job ad asks

“Define and track key product outcomes — implementing dashboards for real-time performance visibility, running A/B and multivariate test and learn, and using data to drive continuous improvement in quality and user experience.”

AI delivers, live

Which active accounts have credit balances large enough for a refund review — the refund queue?

deviation
Their job ad asks

“Create and maintain a prioritised roadmap, working with your team to validate what adds value now and in future, drafting PRDs and specifications.”

AI delivers, live

Where do arrears and churn risk concentrate together — the accounts most at risk of self-disconnecting before intervention?

table
Their job ad asks

“Build long-term stakeholder relationships, implementing communications strategies and influencing effectively to drive alignment and outcomes.”

AI delivers, live

Where do arrears concentrate by tariff type and region — which products and geographies drive the debt book?

bar chart

What stays human

The honest other half. AI does the analysis; a person owns the decision — especially where regulation, fairness and accountability bite.

How it works

Ask in English

A plain-English question — the same one the job ad describes — is translated to SQL by the agentic backend.

LIVE — computed now against 27.6M rows

Curated cards run server-side against MotherDuck when eligible. The workspace separately labels any local inspection path.

Real data, live

Runs against my_db.ensek_demo.accounts. No synthetic numbers.

Self-falsifying

Each figure carries a falsifier — recomputed from the result set, not a stored number, so it can't quietly drift.

Where it plugs in

Function / Ignition surface: Arrears · Balance · Refunds · Risk intersection. Grounded in the real ENSEK: Ignition — a real-time, event-driven meter-to-cash SaaS platform for energy suppliers · 7M+ accounts · regulated by Ofgem.

Watch it do the job — for real

It's the role getting done: curated questions run live server-side against the warehouse; local inspection is labelled inside the workspace.

Open the live workspace →

Provenance. Representative ENSEK-style operational dataset (480 accounts · 424 active · 54 in arrears). Schema mirrors my_db.ensek_demo.accounts. Seed 20260609 — reproducible. No real ENSEK or customer data.

It's Sorted — I took ENSEK's job ads and didn't write a report on what AI could do. I built it. Get the rest sorted →