Excel & Data Analysis Intern

Wealth management, mortgage and treasury services each operate as separate lines of business. Our commercial banking group lends to manufacturers, health systems and real estate developers.

About the internship:

Ochrerow Financial is hiring an Excel & Data Analysis Intern for Within 2 weeks. This role is about accuracy first. A wrong number in a report is worse than a late one. Our headquarters is in Berlin, and about a third of the team works remotely from other countries. This is a remote internship. You will work with our team in Berlin, and the stipend is paid monthly in Indian rupees. Working hours overlap with Central European Time. A stable internet connection and a backup power option are required.

Your projects:

• Track marketing campaign results using Google Analytics 4 data.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Create charts and short slide decks for the monthly review call.
• Maintain the data dictionary and keep dashboard filters up to date.
• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.

Who you are:

• Can commit full time, from home, for the whole internship.
• Own a laptop and have stable internet at home.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• A sample dashboard or analysis project you can share.
• Available 20 to 40 hours a week, Monday to Friday.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Clear written English for reports and status updates.

Nice to have:

• Python with pandas for data cleaning.
• Google Data Analytics or Microsoft PL-300 certification.

What you get out of it:

• Top interns are considered for a junior analyst opening.
• How business metrics like CAC, churn and retention are actually calculated.

Program dates: Within 2 weeks, 1 month.

Compensation: ₹34,000 to ₹46,000/month

What we offer:

• Informal dress code.
• Free access to paid learning courses.
• Letter of recommendation.
• Performance bonus.

We may close the role early, so do not wait too long to apply.

Duration: 1 month. Start: Within 2 weeks.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Ochrerow Financial AG.