Data Analyst Intern

Overview

Position: Data Analyst Intern

Location: Remote/ Hybrid two days a week if you reside within 30 miles of Tustin, CA

Pay: $16 - $20/hr.

Duration: 4 months

Responsibilities

Responsibilities:

• Collaborate with the data team to design and develop dashboards that provide visibility into data processes, including monitoring nightly data runs, data movement, and ETL (Extract, Transform, Load) processes.
• Set up metrics and KPIs to track data pipeline performance, such as load times, error rates, and completion statuses, ensuring data accuracy and timely availability.
• Establish alerts and notifications for any issues within data processes to enable proactive resolution and minimize disruptions.
• Assist in creating reports and visualizations using tools like Excel, Reporting Services, and PowerBI.
• Assist in transitioning existing reports from various platforms to Power BI Report Builder, ensuring accurate representation of data.
• Perform data validation and ensure data integrity.
• Identify trends, correlations and patterns in data to provide actionable insights.
• Support in developing forecasting models using Python/SQL.
• Present findings to stakeholders, through clear and concise visualizations and reports.
• Support ad-hoc requests as needed.
  
  

Qualifications

Qualifications:

• Currently enrolled in or recently graduated (within the last 2 years) from a Bachelor’s program in Information Systems, Computer Science, Data Science, or a related field .
• Strong analytical and problem-solving skills with passion of working with data.
• Familiarity with Excel.
• Knowledge of programming languages (Python/R) and SQL for data manipulation and analysis.
• Strong attention to detail, with the ability to work independently and in a team.
• Excellent communication skills, both verbal and written.
• Familiarity with cloud-based solutions.
  
  

Other Duties: This job may require frequent sitting or standing for long periods of time. This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned in order to meet the needs of the organization.

Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S.

[EOE/M/F/D/V. Drug-free workplace.]

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift up to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction.