Data & Analytics Intern: Year-Round

Job description

Apply by Date: 10/15/2026 Hourly Minimum Pay Rate: $24.58 / hour Hourly Maximum Pay Rate: $29.95 / hour This team is responsible for producing and curating enterprise-supported analytical models, along with various reports and dashboards. Additionally, we support data integration with various enterprise systems like Databricks and SAP and support 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 About SMUD's College Internship Program 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. Purpose 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. Nature and Scope 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. Duties and Responsibilities Work may include, but is not limited to, the following: (NOTE: While in general all the functions and requirements listed are essential, individual positions and/or locations may not require all duties be performed.) 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. Required Education 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. Desirable Qualifications 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 Physical Requirements Applicants must be able to perform the essential job functions with or without a reasonable accommodation. Application Deadline: It is guaranteed that the online system will accept applications until 5 PM on the apply by date. It is highly encouraged that applications are submitted well before the due date and time mentioned to make sure that it is submitted successfully. Official SMUD Title: STEM Student Assistant Internship Program Requirements: 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. SMUD does not look at cumulative GPAs. 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. Diversity, equity and inclusion (DE&I) are a part of who we are and how we do things. Supporting efforts that promote pay equality is part of that. Salary placement for the selected candidate will be determined in alignment with the California Equal Pay Act or the applicable MOU. Determination for salary placement of internal candidates will be made without respect to current classification or compensation and will be based upon the candidate's qualifications as compared to those performing substantially similar work. In the event there is a guaranteed pay progression outlined in an applicable MOU, the MOU takes precedence.