Excel & Data Analysis Intern

Advertising, subscriptions and transaction fees each bring in a significant share of revenue. More than 1,300 employees work on the product, from search ranking to fraud detection. Support shifts are shared, so engineers spend a few hours a quarter answering customer tickets.

About the internship

Prairiemark is hiring an Excel & Data Analysis Intern for Within 2 weeks. Prairiemark needs a data analytics intern to build reports and dashboards for the Growth Analytics team. This is a remote internship. You will work with our team in Indianapolis, and the stipend is paid monthly in USD. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET. A stable internet connection and a backup power option are required.

Responsibilities

• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Create charts and short slide decks for the monthly review call.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Who you are

• Available for a full-time (work from home) internship for the full duration.
• Are able to join within 15 days.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Clear written English for reports and status updates.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Available 20 to 40 hours a week, Monday to Friday.

Nice to have

• Python with pandas for data cleaning.

What you'll learn

• Certificate, letter of recommendation and flexible hours.
• Presenting numbers in a way non-technical people can act on.
• You will build at least one dashboard that managers use every week.

Program dates: Within 2 weeks, 3 months.

Compensation: $350-$400/month

Benefits for interns

• Internet allowance.
• Free access to paid learning courses.
• Flexible work hours.
• Letter of recommendation.

Duration: 3 months. Start: Within 2 weeks.

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