Location: Santa Rosa, CA
POSITION INFORMATION Persons working in this job class will receive direct supervision from the Director of Planning and Analytics and work across the organization with Sonoma Clean Power (SCP) staff in some or all functions related to power supply planning, data requests, data analysis, economic modeling, and various research projects. This individual will collect, assemble, analyze, and interpret data from manual and automated information systems and related programs. This position will be required to work independently and prepare data and reports for review by the Planning and Analytics team. The Intern may be assigned to assist any SCP manager, as needed.
Responsibilities may include:
• Importing data into SQL database from various sources
• Data queries from SQL database for various analytical and tracking purposes
• Statistical analysis of large data set on customer demographics and energy use
• Checking, validating, and scrubbing data from external sources
• Creating data visualizations in PowerBI
• Coding, debugging, and quality assurance (QA) of SQL, Python, and R scripts
• Hard coding data entry
• Provide support for load forecasting functions and budget preparation.
• Research and tool/platform testing
• Assistance with public outreach and event/meeting organization and notetaking
• Administrative tasks