Data Analyst Intern

Yarrowframe Bank is a regional bank with over 200 branches and 4,000 employees across New York. Our commercial banking group lends to manufacturers, health systems and real estate developers.

Internship overview:

Yarrowframe Bank is hiring a Data Analyst Intern for Sep 2027. Yarrowframe Bank needs a data analytics intern to build reports and dashboards for the Growth Analytics team. We are headquartered in New York City and have been hiring remotely since 2020. Remote internship with a team based in New York City. The stipend is paid at the end of each month. Core hours are 9:00 AM to 1:00 PM US Eastern.

What you'll do:

• Join a weekly call with the analytics lead to review your work.
• Maintain the data dictionary and keep dashboard filters up to date.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Check numbers across sources and flag mismatches before reports go out.
• Track marketing campaign results using Google Analytics 4 data.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Create charts and short slide decks for the monthly review call.

Basic qualifications:

• Currently enrolled in a bachelor's or master's degree, graduating 2028.
• Available for the full internship period.
• Clear written English for reports and status updates.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.
• Laptop with Excel or Google Sheets and a stable internet connection.

Nice to have:

• Prior project with real business data from a college club, family business or freelance client.
• Python with pandas for data cleaning.

What you'll learn:

• Presenting numbers in a way non-technical people can act on.
• Certificate, letter of recommendation and flexible hours.
• How business metrics like CAC, churn and retention are actually calculated.
• Top interns are considered for a junior analyst opening.

Program dates: Sep 2027, 6 months.

Intern pay: €2,050 - €2,700/month

Perks:

• Letter of recommendation.
• Paid public holidays.
• Possibility of a full-time offer.
• Internet allowance.
• Certificate of completion.

Duration: 6 months. Start: Sep 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Yarrowframe Bank.