Pacific Gas and Electric Company

Senior Operations Data Analyst

Pacific Gas and Electric Company

full-time

Posted on:

Location Type: Hybrid

Location: OaklandCaliforniaUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $100,000 - $169,000 per year

Job Level

About the role

  • Extracts operations data for analysis, leadership support and responses to ad hoc data requests.
  • Maintains operations tools & databases to ensure that it is kept up-to-date.
  • Develops, maintains and enhances operational metric database tools for the broader analytics teams.
  • Identifies and solves current gaps in data requirements and ease of access to ensure fast and consistent responses to leadership inquiries.
  • Creates complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
  • Demonstrates and uses advanced knowledge of data processing and data analysis techniques.
  • Designs data analysis to achieve business objectives, process data, analyze data, write clear and concise data findings and tailor communications to specific audiences.
  • Analyzes data using various statistical tools to develop ad hoc reports, statistics, trends and profiles.
  • Develops and communicates clear, concise and actionable data analyses for clients.
  • Manages complex data analysis projects with limited supervision from initial request to presenting data results ensuring that the project is completed within budget and on-time.
  • Manages complex data extracts and list pulls ensuring data accuracy.
  • Provides recommendations to enhance database(s) with new data sources and improved data processes.
  • Lead and Coordinate Projects: Manage end-to-end data-related projects, ensuring alignment with organizational goals and timelines.
  • Performance Tracking: Monitor progress against milestones, adjust plans as needed, and report outcomes to senior leadership.

Requirements

  • BA/BS Degree in Marketing, Business, Computer Science, Engineering or related field or equivalent work experience
  • 4 years of job-related experience
  • Familiarity with utility operations
  • Advanced skill in Microsoft Excel/Access (complex formulas, graphing, VBA)
  • Advanced skill in writing SQL queries using Oracle or Business Objects
  • Proficient in UNIX shell programming (csh, awk, sed, vi)
  • Solid knowledge of base-SAS and programming languages such as Visual Basic, Perl, C
  • Strong organizational skills, ability to effectively prioritize work, meet deadlines and work on multiple tasks independently
  • Good communications and presentation skills to deliver findings and make recommendations to stakeholders
  • Project management skills
Benefits
  • Health insurance
  • 401(k) matching
  • Paid time off
  • Flexible work arrangements

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data analysisdata processingdata manipulationdata cleansingSQLMicrosoft ExcelMicrosoft AccessUNIX shell programmingbase-SASVisual Basic
Soft skills
organizational skillscommunication skillspresentation skillsproject managementability to prioritize workindependent workleadership supportproblem-solvingattention to detailtime management