Data & Analytics Intern: Year-Round

SMUD • Sacramento, CA

10d • $25 - $30 • Hybrid

About The Position

This team is responsible for producing and curating enterprise-supported analytical models, along with various reports and dashboards. Additionally, the team supports data integration with various enterprise systems like Databricks and SAP and supports business units in establishing, organizing, and sharing data. The intern for this position will be required to come work onsite, in person once a week onsite; could be more days onsite from January 1st to the SMUD Offices in Sacramento, CA. SMUD's College Internship Program provides college interns with an opportunity to contribute their skills and knowledge to SMUD while gaining valuable work experience. Workshops and activities will also be part of the program where interns will have the opportunity to be immersed in SMUD's culture and learn leadership skills as well as develop their professional skills. SMUD was also recognized by Interns 2 Pros for the 2020 Internship Program of The Year Award in recognition of excellence in internship strategy, implementation, and impact and was one of five finalists for the 2023 Internship Program of the Year from Interns 2 Pros along with Paramount, Fox Corporation, Intuit, and Toyota. Under staff direction, incumbents in this classification are full-time students in a Science, Technology, Engineering or Math program who perform research and analytical tasks for projects and assignments that utilize specific and acquired academic skills and knowledge in alignment with their educational disciplines. The work performed in this classification calls for regular application of analytical and independent research skills. Work is closely related to the employee’s academic major in Science, Technology, Engineering or Mathematics.

Requirements

• Registration as a full-time student (minimum of 12 units) at an accredited college or university in a declared curriculum with a Science, Technology, Engineering or Mathematics (STEM) emphasis that will provide the specific skills and knowledge that will contribute to available work assignments.
• Students must be able to commute to the SMUD Offices in Sacramento, CA when requested to come in.
• To have a student position at SMUD, you must not have any relatives working at SMUD.
• Students must be enrolled and maintain enrollment as a full-time student, complete and pass at least 12 undergraduate units OR 8 graduate units, and receive at least a 2.0 GPA the semester/quarter prior to employment and for the duration of the internship.
• Currently, SMUD is not hiring candidates for its student internship positions who require sponsorship from an employer either now or in the future. Such sponsorship is not needed for citizens, a U.S. National, a permanent resident, or one granted refuge or asylum status by the U.S. government. Visa holders typically require sponsorship in one form or another at some point in time.

Nice To Haves

• College status: Junior+
• College Major: Information Systems, Computer Science, Data Science, Business Analystics, or related field
• Proficiency in Python programming and working knowledge of SQL
• Basic knowledge in Data Modeling, Data Structure and Reporting Design
• Familiarity with Power BI or similar reporting tools
• Exposure to ETL/ELT processes, data automatic, and data pipeline development
• Familiarity with SAP BW concepts such as InfoProviders, DTPs, transformations, ADSOs, BW quaries or process chains is a plus
• Basic understanding of Agile team environments; familiarity with JIRA and Confluence is a plus
• Exposure to Databricks, SAP analytics environments, data warehousing concepts, or performance tuning is a plus

Responsibilities

• Performs tasks of an analytical or research nature for suitable projects or ongoing assignments which call for specific acquired academic skills and knowledge in Science, Technology, Engineering or Math.
• May locate sources of information; collect and organize data.
• Makes computations and analyzes data for degree of confidence and for alternative courses of action.
• May develop computer programs relating to assignments and may code material for established programs.
• May develop written, graphical and/or oral reports.
• May assist staff analysts and technical personnel by performing elements of their work under close supervision.

Benefits

• Workshops and activities will also be part of the program where interns will have the opportunity to be immersed in SMUD's culture and learn leadership skills as well as develop their professional skills.

What This Job Offers

• Job Type: Full-time
• Career Level: Intern
• Education Level: No Education Listed