NCPA · 13 hours ago
Data Analytics Student Assistant I-III, Redding Electric Utility
City of Redding
Full-time
Onsite
New Grad
$17.82/hr - $31.42/hrNCPA is seeking a Data Analytics Student Assistant to support electric planning, reliability, and performance reporting. The role involves cleaning and validating data, writing SQL queries, developing Python-based analysis workflows, and creating publication-ready reports for internal decision-making.
EnergyNon ProfitIndustrialGovernmentElectrical DistributionEnergy Management
Responsibilities
Query, extract, and prepare data from internal sources using SQL and/or structured data exports (CSV, Excel, system reports)
Clean, validate, and standardize datasets using Python (e.g., pandas) and Excel to improve consistency and reliability of metrics
Build repeatable analysis workflows (scripts/notebooks) to support recurring reporting and ad hoc investigations
Develop performance metrics and reporting tables (e.g., reliability trends, work volumes, inspection/program progress, operational indicators) in collaboration with staff
Create clear visualizations (charts/graphs) and concise written summaries for internal reporting and presentations
Support basic forecasting and trend analysis using explainable methods (e.g., time-series trends, regression, scenario comparisons), as appropriate
Document data sources, assumptions, and methodology so results are traceable and reusable by the team
Participate in team check-ins and present work products to stakeholders with a focus on clarity and accuracy
Qualification
Required
Academic status at an accredited college or university taking courses as a full-time student leading to a Data Science, Computer Science, Applied Mathematics, Industrial Engineering, Information Systems / Business Analytics, Economics (quantitative) degree or a degree in a field related to the work which is performed
Strong Excel skills (filters, pivot tables, formulas; ability to work with large spreadsheets)
Working knowledge of SQL (select statements, joins, aggregations; ability to produce clean reporting outputs)
Working knowledge of Python for data analysis (pandas; Jupyter notebooks or equivalent workflow)
Familiarity with data quality concepts (validation checks, handling missing values, consistent definitions/metrics)
Ability to produce clear charts and summaries using common tools (Excel charts, Python plotting libraries, or similar)
Strong analytical reasoning and attention to detail; able to spot inconsistencies and resolve data issues
Ability to translate a business/operational question into a measurable metric and a repeatable analysis approach
Clear communicator who can summarize results for non-technical audiences (written and verbal)
Self-directed and organized; able to manage multiple tasks, meet deadlines, and ask good questions when requirements are unclear
Professional judgment with sensitive or operationally relevant information, follows data-handling expectations
Collaborative mindset; able to work effectively with engineers, planners, operations staff, and supervisors
Preferred
Knowledge of energy or utility industry concepts (preferred but not required)
Company
NCPA
The Northern California Power Agency (NCPA), a California Joint Action Agency, was established in 1968 by a consortium of locally owned electric utilities to make joint investments in energy resources that would ensure an affordable, reliable, and clean supply of electricity for customers in its member communities.
Founded in 1968
51-200 employees
Funding
Current Stage
Growth StageRecent News
Energy-Storage.News
2025-09-26
Company data provided by crunchbase