Excel & Data Analysis Intern

Call centres in Cary and two other locations handle customer service. Treasure Coast Light & Power is an investor-owned utility serving more than two million electric and gas customers. Founded in 1926, we now have 1,700 employees.

The program:

Treasure Coast Light & Power is hiring an Excel & Data Analysis Intern for Within 2 weeks. Treasure Coast Light & Power needs a data analytics intern to build reports and dashboards for the Revenue Operations team. You will intern remotely with our team in Cary. We have hosted remote interns from several countries before. You will need at least 4 hours of overlap with US Eastern time.

Responsibilities:

Track marketing campaign results using Google Analytics 4 data. Check numbers across sources and flag mismatches before reports go out. Prepare the weekly MIS report and send it to the team lead every Monday. Analyse funnel drop-offs and summarise findings in a one-page note. Answer ad hoc data requests from sales and support within a day or two.

Who you are:

Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program. Available for at least 30 hours a week, work from home. Comfort with numbers and strong attention to detail. Some familiarity with Power BI or Tableau, even from a course or certification. Basic SQL, enough to write SELECT queries with joins and filters.

Nice to have:

Python with pandas for data cleaning. Knowledge of basic statistics such as medians, percentiles and correlation. Experience with Google Analytics 4 or Mixpanel.

What you'll learn:

How business metrics like CAC, churn and retention are actually calculated. Writing SQL against a real production warehouse. Presenting numbers in a way non-technical people can act on.

Program dates: Within 2 weeks, 3 months.

Pay: $350 to $370 monthly

What we offer:

Mentorship from senior team members. Pre-placement offer (PPO) for strong performers. Free access to paid learning courses. Letter of recommendation. Flexible work hours. Internet allowance.

Candidates must be eligible to work in.

Duration: 3 months. Start: Within 2 weeks.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Treasure Coast Light & Power.