Logo of Huzzle

Intern - Data Analyst and Report Writer

  • Internship
    Full-time
    Summer Internship
  • Data
    Banking & Finance
  • Livermore

AI generated summary

  • You must have strong Excel, PowerPoint, and Microsoft Office skills, be a junior or senior with a 3.0+ GPA, possess excellent communication and organizational skills, and have a desire to learn.
  • You will collect and analyze data, categorize qualitative insights, create pivot tables and charts, update executive reports, conduct research, and assist with various administrative tasks.

Requirements

  • Must have proven desire and ability to study and learn new concepts and technologies quickly.
  • Must be very proficient with the following tools:
  • - Excel (pivot tables & charts),
  • - PowerPoint (create master templates and integrate with Excel)
  • Good working knowledge of: Microsoft (Word, Visio, Outlook).
  • Additional tools would be helpful: PowerBI, Tableau
  • Overall strong working knowledge of Windows based personal computers.
  • Familiar with fundamental principles of business communications
  • Excellent organizational skills
  • Strong English language skills to interpret and analyze survey open comments.
  • Only individuals possessing outstanding character, a high degree of motivation, and the willingness to learn will be selected.
  • To be considered, students must meet the following qualifications:
  • Candidate should be taking upper division courses (junior or senior year)
  • Candidate should express interest in working in a related field that supports financial services, after graduation
  • Candidate should be in good academic standing with a GPA of 3.0 or higher
  • Candidate must be returning to their campus following the program
  • Have a reliable means of transportation to and from the workplace
  • Have excellent customer services/client focus, teamwork, and collaboration
  • Ability to write and communicate effectively and have solid attention to details
  • Experience in administrative/office support and phone skills
  • Knowledgeable in using Microsoft Offices including Word, Excel (pivot tables, charts); PowerPoint, Visio and Outlook
  • Experience in research, analysis and statistical data are a plus

Responsibilities

  • Primary research, data collection and data scrubbing
  • Deep analysis of existing data (qualitative and quantitative)
  • Categorize and quantify the qualitative data for additional analysis and insights
  • Build new data sets and pivot tables, charts and integrations with PowerPoint
  • Conduct primary research as needed
  • Edit and update Executive Reports (Excel & PowerPoint)
  • Support the team with administrative tasks as assigned

FAQs

What is the hourly wage for this internship?

The hiring salary for this internship is $20.00 per hour.

Where is the internship located?

The internship is located in Livermore, CA, and is offered in a hybrid format.

What is the duration of the internship?

The internship is part of the Summer Internship program, though the specific duration is not mentioned in the job description.

What qualifications are required to apply for this internship?

Candidates should be taking upper division courses (junior or senior year), have a GPA of 3.0 or higher, and express interest in working in a related field that supports financial services after graduation.

What skills are necessary for this internship?

Necessary skills include proficiency in Excel (pivot tables and charts), PowerPoint, good organizational skills, strong English language skills, and a basic knowledge of Microsoft Office tools.

Will interns have the opportunity to present their work?

Yes, interns will have an opportunity to present their work to leaders across the Bank and learn how to solicit and apply feedback.

What kind of responsibilities will the intern have?

Responsibilities include data collection, analysis of qualitative and quantitative data, building new data sets, updating executive reports, and supporting the team with administrative tasks as assigned.

Is prior experience in research or analysis required?

While not required, experience in research, analysis, and statistical data is considered a plus.

Are there any requirements regarding transportation?

Yes, candidates must have a reliable means of transportation to and from the workplace.

What can interns expect to learn during this internship?

Interns can expect to learn about data analytics, business reporting, attention to detail, communication skills, business process improvement, and gain direct feedback from team interactions.

Fremont Bank was founded 60 years ago to be a driver of long-term prosperity in our community.

Finance
Industry
501-1000
Employees
1964
Founded Year

Mission & Purpose

Fremont Bank is one of the oldest locally owned banks in the San Francisco Bay Area. It was founded in 1964 and is based in Fremont, California. We know that community banking makes a difference to our customers, our business partners, and our employees. We believe that each success in our community improves the quality of life for us all. That is why we’ve held to an unwavering commitment to providing the communities we serve with financial resources and building professional relationships second-to-none. Fremont Bank was selected as the seventh “Best Workplace in the Bay Area” in the large company category in 2018. We were also honored by the San Francisco Business Times as one of the “Top 65 Corporate Philanthropists in the Greater Bay Area"​. The Bank has made it on the coveted list, which is based on total cash contributions paid by companies to Bay Area nonprofits, every year since it entered the survey in 2003.