Project briefs · Finance & Accounting

KeyBank · Summer 2027

Risk Management Intern: a project built for this posting

A 10.5-week paid internship in KeyBank's risk management group in Cleveland, aimed at students graduating in December 2027 or May 2028. Interns work on real risk analysis and get coaching and feedback throughout the summer.

Build this project for free →

Free, any major, no coding needed. Your project for this posting: Transaction Risk Monitoring Dashboard (Excel/Google Sheets).

Company
KeyBank
Posting title
2027 Summer Risk Management Internship Program- Cleveland
Location
Cleveland, OH
Season
Summer 2027
Pay (as posted)
$23 per hour plus a $2,000 summer sign-on bonus (as posted)
Majors named
Finance, Accounting, Actuarial Science, Economics

Checked open on the employer's careers site on 2026-11-18. Read the full posting ↗

What this role is really testing

Risk identification and assessmentData analysis and reportingControl testing and quality assuranceRegulatory and compliance reasoningStructured written communicationQuantitative reasoning with financial dataProcess improvement analysis

The project

Transaction Risk Monitoring Dashboard (Excel/Google Sheets)

A structured spreadsheet that ingests a small set of mock bank transactions, flags potentially suspicious activity using rule-based logic (large cash amounts, rapid frequency, round-number patterns), and produces a one-page summary report with risk ratings and recommended next steps. This directly mirrors AML transaction monitoring, operational risk reporting, and the data analytics responsibilities listed across every placement area in the internship.

  1. Build a mock transaction dataset with 20–30 rows covering columns like Transaction ID, Date, Account ID, Transaction Type, Amount, Country, and Frequency Count. Vary the data so some rows contain red-flag patterns: amounts over $10,000, multiple transactions from the same account within 24 hours, round-dollar amounts (exactly $5,000 or $9,999), or transactions originating from a high-risk country code. Use conditional formatting to color-code each row Red, Yellow, or Green based on how many flags it triggers.
  2. Add a 'Risk Scoring' column using an IF/COUNTIF formula that assigns 1 point per flag per transaction and maps the total to a risk tier (0 = Low, 1 = Medium, 2+ = High). Create a second tab called 'Control Testing Log' with columns for Control Name, Description, Test Performed, Pass/Fail, and Finding, populate it with three rows documenting the rules you just built as if you were a compliance analyst validating that each control works as intended.
  3. On a third tab titled 'Risk & Compliance Summary Report', write a structured one-page memo using text boxes or formatted cells that includes: (1) a pie or bar chart of transaction volume by risk tier pulled from your data, (2) a plain-English executive summary of findings in 3–4 bullet points, and (3) a 'Recommended Actions' section with one specific process improvement suggestion (e.g., flagging velocity rules should auto-escalate same-day repeat transactions above $5,000 to a senior analyst queue). Save it as a shareable link or PDF so a recruiter can open it in one click.
Build this project for free →

Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.

Questions

Do I need to know how to code?

No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.

Where did this project come from?

Provieo read the KeyBank posting and generated it on 2026-11-11. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.

Is Provieo connected to KeyBank?

No. This is an independent project idea based on a public posting. It does not guarantee an interview.