Operations Data Analyst
About The Position
The Operations Data Analyst extracts and analyzes operations data to support leadership and respond to ad hoc data requests. The role maintains operations tools and databases using information from various PG&E systems, and develops, maintains, and enhances operational metric database tools for analytics teams. The analyst identifies and resolves gaps in data requirements and accessibility to support fast, consistent responses to leadership inquiries. The position manages data management projects from initial request through presentation of results, creates automated data routines for reporting and data delivery, manages data extracts and transfers, analyzes data with statistical tools, and communicates clear, concise, actionable analyses. The position is hybrid, working from a remote office and an assigned location based on business need.
Requirements
- Bachelor of Arts or Bachelor of Science degree in Marketing, Business, Computer Science, Engineering, or a related field, or equivalent work experience.
- 2 years of related work experience.
- Ability to analyze and interpret data and effectively communicate findings.
Nice To Haves
- Familiarity with utility operations.
- Skilled in Microsoft Excel and Access, including complex formulas, graphing, and VBA.
- Skilled at writing SQL queries using Oracle or Business Objects.
- Experience with UNIX shell programming, including csh, awk, sed, and vi.
- Knowledge of base-SAS and a programming language such as Visual Basic, Perl, or C.
Responsibilities
- Manage standard data analysis projects from initial request through presentation of results, completing them within budget and on time, with limited supervision.
- Work with other Data Management Analysts to process and analyze data and report findings.
- Create automated routines and processes for reporting and data delivery, ensuring accurate data manipulation and cleansing.
- Manage standard data extracts and list pulls, ensuring data accuracy, and transfer data from databases to analysts supporting operational analysis.
- Analyze data using statistical tools to develop ad hoc reports, statistics, trends, and profiles.
- Develop and communicate clear, concise, and actionable data analyses for clients.
- Maintain operations tools and databases using data from various PG&E systems.
- Develop, maintain, and enhance operational metric database tools for analytics teams.
- Identify and resolve gaps in data requirements and data accessibility.
Benefits
- Eligible to participate in PG&E’s discretionary incentive compensation programs.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
