SQL Data Analyst Intern

Catastrophe teams deploy adjusters within days of a major storm. January renewals keep everyone busy for a few weeks.

The program

Ferrycrest Mutual is hiring an SQL Data Analyst Intern for Immediately. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote internship with a team based in New York City. The stipend is paid at the end of each month. You will need at least 4 hours of overlap with US Eastern time. A stable internet connection and a backup power option are required.

Responsibilities

• Create charts and short slide decks for the monthly review call.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Maintain the data dictionary and keep dashboard filters up to date.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Answer ad hoc data requests from sales and support within a day or two.

Basic qualifications

• Can start immediately or within two weeks.
• Women starting or restarting their careers are encouraged to apply.
• Available 20 to 40 hours a week, Monday to Friday.
• Clear written English for reports and status updates.
• Must be able to follow up on data requests without constant reminders.

Nice to have

• Familiarity with DAX in Power BI.
• Knowledge of basic statistics such as medians, percentiles and correlation.
• Prior project with real business data from a college club, family business or freelance client.

What you'll learn

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

Program dates: Immediately, 3 months.

Pay: $400 - $450 monthly

Perks

• Flexible work hours.
• Internet allowance.
• Certificate.
• Job offer on successful completion.
• Free access to paid learning courses.

Shortlisted candidates will hear from us within two weeks.

Duration: 3 months. Start: Immediately.

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