Operations Data Analyst

$87,000 - $131,000/Yr

PG&E - Oakland, CA

posted 4 months ago

Full-time - Entry Level
Oakland, CA
Utilities

About the position

The Operations Data Analyst plays a crucial role in extracting and analyzing operations data to support leadership and respond to ad hoc data requests. This position is responsible for maintaining operations tools and databases, ensuring they are up to date and functional. The analyst will develop, maintain, and enhance operational metric database tools that serve the broader analytics teams. A key aspect of this role is identifying and addressing gaps in data requirements and accessibility, which is essential for providing fast and consistent responses to leadership inquiries. In this role, the analyst will demonstrate a comprehensive understanding of data processing and analysis techniques. They will utilize various statistical tools to analyze data and develop ad hoc reports, statistics, trends, and profiles. Clear and actionable data analyses will be communicated to clients, ensuring that insights are easily understood and applicable to their needs. The Operations Data Analyst will manage standard, routine data analysis projects with limited supervision, overseeing the process from the initial request to the presentation of data results. This includes ensuring that projects are completed within budget and on time. The analyst will also manage standard data extracts and list pulls, ensuring the accuracy of the data being transferred to various analysts to support operational analysis efforts. Collaboration with other Data Management Analysts will be essential for processing and analyzing data, as well as reporting findings. Additionally, the analyst will create automated data routines and processes for reporting and data delivery, ensuring accurate data manipulation and cleansing.

Responsibilities

  • Extract operations data for analysis and leadership support.
  • Maintain operations tools and databases to ensure they are up to date.
  • Develop, maintain, and enhance operational metric database tools for analytics teams.
  • Identify and solve gaps in data requirements and ease of access.
  • Analyze data using statistical tools to develop reports, statistics, trends, and profiles.
  • Develop and communicate clear, concise, and actionable data analyses for clients.
  • Manage standard data analysis projects from request to presentation, ensuring timely completion.
  • Manage standard data extracts and list pulls, ensuring data accuracy.
  • Transfer data from databases to analysts to support operational analysis efforts.
  • Collaborate with other Data Management Analysts to process and analyze data.
  • Create automated data routines and processes for reporting and data delivery.

Requirements

  • BA/BS Degree in Marketing, Business, Computer Science, Engineering or related field or equivalent work experience.
  • Two (2) years of related work experience.
  • Familiarity with utility operations.
  • Skilled in Microsoft Excel/Access (complex formulas, graphing, VBA).
  • Skilled in writing SQL queries using Oracle or Business Objects.
  • Experience in UNIX shell programming (csh, awk, sed, vi).
  • Knowledge of base-SAS and programming languages such as Visual Basic, Perl, C.
  • Ability to analyze and interpret data and effectively communicate findings.

Nice-to-haves

  • Familiarity with utility operations.
  • Experience with advanced data analysis techniques.
  • Knowledge of additional programming languages.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service