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.

Internship overview:

Treasure Coast Light & Power is hiring an Excel & Data Analysis Intern for Within 2 weeks. Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. The company is based in Cary, the US. Our team works from several countries. You will intern remotely with our team in Cary. We have hosted remote interns from several countries before. Core hours are 9:00 AM to 1:00 PM US Eastern.

Your projects:

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Track marketing campaign results using Google Analytics 4 data
• Maintain the data dictionary and keep dashboard filters up to date
• Join a weekly call with the analytics lead to review your work
• Answer ad hoc data requests from sales and support within a day or two
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery

Basic qualifications:

• Available for at least 30 hours a week, work from home
• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Available 20 to 40 hours a week, Monday to Friday
• Comfort with numbers and strong attention to detail

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification
• Prior project with real business data from a college club, family business or freelance client

What you'll learn:

• Certificate, letter of recommendation and flexible hours
• Top interns are considered for a junior analyst opening
• Presenting numbers in a way non-technical people can act on

Program dates: Within 2 weeks, 3 months.

Compensation: $250 - $260 monthly

Perks:

• Performance bonus
• Informal dress code
• Free access to paid learning courses
• Flexible work hours
• 5 days a week

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.