Banking Analyst

Banking Analyst manages the work items collected here and this page includes 20 real tasks you can replicate. Expect clear checklists and small pointers about using Microsoft Excel. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

20evidenced tasks
20ready prompts
9tools of the trade
13-2041.00O*NET-SOC code
Open Banking Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Analysing6

Evaluate credit risk

+
Assess the corporate loan applicant's credit by calculating debt service coverage, reviewing three years of…
Assess the corporate loan applicant's credit by calculating debt service coverage, reviewing three years of financial statements, scoring repayment likelihood, and recommend approval, collateral and pricing to the credit committee for the Friday meeting.
The tools that do the workMicrosoft ExcelESCOjob descriptionsO*NETWikipedia

Review credit applications

+
Review the consumer credit application packet, verify employment and income consistency, reconcile the credit…
Review the consumer credit application packet, verify employment and income consistency, reconcile the credit bureau records with submitted statements, identify any missing documents, and return a complete exceptions memo to underwriting by end of day tomorrow.
The tools that do the workMicrosoft WordESCOjob descriptionsWikipedia

Resolve credit issues

+
Investigate the overdue commercial account, map the timeline of missed payments, calculate missed-payment…
Investigate the overdue commercial account, map the timeline of missed payments, calculate missed-payment penalties and potential cure capacity, propose a remediation plan with payment milestones and a recommended next contact person by Wednesday afternoon.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia

Assess borrower’s ability to repay

+
Build a repayment assessment for the small business borrower using three-year cashflow projections, stress…
Build a repayment assessment for the small business borrower using three-year cashflow projections, stress the model under a 20% revenue shock, estimate likelihood of default and recommended loan term adjustments, and submit to the portfolio manager by Friday close.
The tools that do the workMicrosoft ExcelESCOjob descriptions

Confer with clients and credit agencies

+
Call Anna Patel at Riverside Capital and the three credit bureaux today, review the client's six-month…
Call Anna Patel at Riverside Capital and the three credit bureaux today, review the client's six-month payment ledger and the bureau reports, agree any discrepancies, then update the client's credit file and send a one-page summary with my recommendation to relationship manager Mark Chen by 5pm.
The tools that do the workMicrosoft OutlookMicrosoft ExcelESCOjob descriptions

Monitor risk trends for management and sales

+
Produce a two-slide brief for today’s risk huddle: show five-week trend of delinquencies, top three sectors…
Produce a two-slide brief for today’s risk huddle: show five-week trend of delinquencies, top three sectors moving against appetite, and recommended limits adjustments, then circulate to Head of Sales Laura Gomez and the CRO before the 3pm meeting.
The tools that do the workMicrosoft PowerPointMicrosoft Exceljob descriptionsWikipedia
The daily work14

Contact customers to collect payments on delinquent accounts.

+
Call or email the 23 customers flagged as 60+ days past due in the delinquent accounts list, confirm payment…
Call or email the 23 customers flagged as 60+ days past due in the delinquent accounts list, confirm payment plans or next payment dates, record promises to pay and expected amounts in the account notes, and escalate any refusals to Sarah in recoveries by end of day Friday.
The tools that do the workMicrosoft OutlookMicrosoft ExcelO*NET

Generate financial ratios using software

+
Pull the latest balance sheets and income statements for the 15 accounts on the watchlist, calculate current…
Pull the latest balance sheets and income statements for the 15 accounts on the watchlist, calculate current and quick ratios and debt-to-equity for each, flag any with liquidity below the thresholds, and save the ratio table for review at Tuesday credit committee.
The tools that do the workMicrosoft Exceljob descriptions

Review and compare industry and geographic data

+
Compile revenue, default rates and client counts by industry and by region for Q1–Q4 last year, benchmark our…
Compile revenue, default rates and client counts by industry and by region for Q1–Q4 last year, benchmark our portfolio against national industry averages, highlight sectors and geographies with rising defaults, and prepare the comparison table for Thursday's portfolio meeting.
The tools that do the workSASMicrosoft Exceljob descriptions

Evaluate economic and legislative impacts

+
Assess how the proposed interest rate change and the new small-business lending rule would affect default…
Assess how the proposed interest rate change and the new small-business lending rule would affect default probabilities and net interest income across our SME book, quantify impacts for best, base and worst scenarios, and submit the scenario analysis with recommendations to Mark in risk by Wednesday.
The tools that do the workPythonMicrosoft Exceljob descriptions
START

Project sales

+
Project sales for the next four quarters for our commercial lending pipeline using rolling historical…
Project sales for the next four quarters for our commercial lending pipeline using rolling historical drawdown rates and current pipeline commitments, produce a monthly forecast with upper and lower bounds, and circulate the forecast spreadsheet to Lisa in treasury and the forecasting group before Friday close.
The tools that do the workMicrosoft ExcelMicrosoft SQL ServerWikipedia

Set new customer credit limits

+
Review credit applications for five new customers, calculate exposure under proposed terms, check payment…
Review credit applications for five new customers, calculate exposure under proposed terms, check payment history and financial statements, set recommended credit limits with rationale, and send the limit approvals to Priya in underwriting for sign-off by Wednesday midday.
The tools that do the workSAPMicrosoft WordWikipedia

Maintain customer files with financial statements

+
Update the client folder for account 49271 with the latest audited financial statements, reconcile them…
Update the client folder for account 49271 with the latest audited financial statements, reconcile them against last quarter's ratios, flag any anomalies above 10% variance, and save the updated file to the client repository by end of day Thursday.
The tools that do the workMicrosoft ExcelWikipedia

Evaluate if applications comply with regulations and guidelines

+
Review application 2026-187 against the bank's regulatory checklist, confirm disclosures, debt-service…
Review application 2026-187 against the bank's regulatory checklist, confirm disclosures, debt-service coverage and KYC were met, note any non-compliance with section 4.2, and prepare a compliance summary for credit review by Tuesday morning.
The tools that do the workMicrosoft WordESCO

Acquire additional information from other departments or institutions

+
Request the missing cash flow schedules and bank confirmations for client 33845 from Treasury and Corporate…
Request the missing cash flow schedules and bank confirmations for client 33845 from Treasury and Corporate Banking, explain we need March and April statements to close the file, and ask for a reply within three business days so we can meet the Monday credit committee deadline.
The tools that do the workMicrosoft OutlookESCO

Analyse the credit history of potential customers

+
Pull the credit bureau history and the last three years' repayment records for applicant Rana Patel,…
Pull the credit bureau history and the last three years' repayment records for applicant Rana Patel, calculate delinquency days and trend the probability of default, then draft a two-paragraph risk note for the relationship manager before Friday close.
The tools that do the workSASESCOsee the evidence ↗

Advise on credit rating

+
Produce a succinct credit rating recommendation for company Greenwave Ltd based on the latest financials,…
Produce a succinct credit rating recommendation for company Greenwave Ltd based on the latest financials, including suggested rating, key drivers, covenant breaches, and an upside/downside scenario for the credit committee next Wednesday.
The tools that do the workMicrosoft ExcelMicrosoft WordESCOsee the evidence ↗

Maintain credit history of clients

+
Consolidate and update the credit history ledger for retail clients with delinquency over 30 days, append…
Consolidate and update the credit history ledger for retail clients with delinquency over 30 days, append repayments and charge-off dates, ensure all records match the master client IDs, and circulate the reconciled ledger to Collections by close of business Friday.
The tools that do the workStructured query language SQLESCOsee the evidence ↗

Analyse financial risk

+
Run a fresh portfolio-level risk analysis using the latest loan ledger and payment histories, flag accounts…
Run a fresh portfolio-level risk analysis using the latest loan ledger and payment histories, flag accounts with covenant breaches or rising PD over three quarters, produce a ranked list of top 15 exposures with recommended risk actions by Thursday.
The tools that do the workMicrosoft ExcelStructured query language SQLESCOsee the evidence ↗

Financial statements

+
Prepare a set of reviewed financial statements for client Merton Trading for the quarter, reconcile cash,…
Prepare a set of reviewed financial statements for client Merton Trading for the quarter, reconcile cash, loans and provisions to the general ledger, highlight any unusual movements and draft a one-page CFO note summarising solvency and liquidity concerns by Friday morning.
The tools that do the workMicrosoft ExcelMicrosoft WordESCOsee the evidence ↗

Says who?

These are the pages we read to build this. Open any of them and check us.

Activities this job lives in

The human activities behind the tasks — each with its honest AI ceiling.

The logs, files & records this job keeps

Shared with other careers — the same record means something different in each.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses