
Senior Operations Data Analyst
Pacific Gas and Electric Company
full-time
Posted on:
Location Type: Hybrid
Location: Oakland • California • United States
Visit company websiteExplore more
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