Operations Data Analyst, Senior (Oakland, CA, US, 94612)

<p>Requisition ID # 172520 </p> <p><p>Job Category: Business Operations / Strategy </p> <p>Job Level: Individual Contributor</p> <p>Business Unit: Energy Delivery</p> <p>Work Type: Hybrid</p> <p>Job Location: Oakland; Alameda; Alta; American Canyon; Angels Camp; Antioch; Auberry; Auburn; Avenal; Avila Beach; Bakersfield; Balch Camp; Bay Point; Bear Valley; Belden; Bellota; Belmont; Benicia; Berkeley; Brentwood; Brisbane; Buellton; Burney; Buttonwillow; Calistoga; Campbell; Canyon Dam; Canyondam; Capitola; Caruthers; Chico; Clearlake; Clovis; Coalinga; Colusa; Concord; Concord; Corcoran; Cottonwood; Cupertino; Daly City; Danville; Davis; Dinuba; Downieville; Dublin; Emeryville; Eureka; Fairfield; Folsom; Fort Bragg; Fortuna; Fremont; French Camp; Fresno; Fresno; Fulton; Garberville; Geyserville; Gilroy; Goodyear; Grass Valley; Guerneville; Half Moon Bay; Hayward; Hinkley; Hollister; Holt; Huron; Jackson; Kerman; King City; Lakeport; Lemoore; Lincoln; Linden; Livermore; Lodi; Loomis; Los Banos; Lower Lake; Madera; Magalia; Manteca; Manton; Mariposa; Martell; Marysville; Maxwell; Menlo Park; Merced; Meridian; Millbrae; Milpitas; Modesto; Monterey; Montgomery Creek; Morgan Hill; Morro Bay; Moss Landing; Mountain View; Napa; Needles; Newark; Newman; Novato; Oakdale; Oakhurst; Oakley; Olema; Orinda; Orland; Oroville; Palo Alto; Palo Cedro; Paradise; Parkwood; Paso Robles; Petaluma; Pioneer; Pismo Beach; Pittsburg; Placerville; Pleasant Hill; Point Arena; Potter Valley; Quincy; Rancho Cordova; Red Bluff; Redding; Richmond; Ridgecrest; Rio Vista; Rocklin; Roseville; Round Mountain; Sacramento; Salida; Salinas; San Bruno; San Carlos; San Francisco; San Francisco; San Jose; San Luis Obispo; San Mateo; San Rafael; San Ramon; San Ramon; Sanger; Santa Cruz; Santa Maria; Santa Nella; Santa Rosa; Selma; Shaver Lake; Sonoma; Sonora; South San Francisco; Springville; Stockton; Storrie; Taft; Tracy; Turlock; Twain; Ukiah; Vacaville; Vallejo; Walnut Creek; Wasco; Watsonville; West Sacramento; Wheatland; Whitmore; Willits; Willow Creek; Willows; Windsor; Winters; Woodland; Yuba City</p> <p> <p> <p> <p><p><span style=""><strong>Department Overview</strong></span></p> <p style="margin:0.0in;line-height:normal;background-color:white"><span style="">Operations Support is dedicated to creating cross-commodity consistency and standards in Operations. The team provides support services guided by best practices and a relentless pursuit for improvement. It has single points of accountability for Work Management &amp; Resource Planning, Execution Support, Business Operations &amp; Process Improvement, PG&amp;E Academy, and Enterprise Public Works. Operations Support is comprised of approximately 1,000 coworkers.</span></p> <p> </p> <p><span style=""><strong>Position Summary</strong></span></p> <p><span style="">Extracts operations data for analysis, leadership support and responses to ad hoc data requests. Maintains operations tools &amp; 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.</span></p> <p style="margin:0.0in 0.0in 8.0pt;line-height:115%"> </p> <p style="margin:0.0in 0.0in 8.0pt;line-height:115%"><span style="">This position is hybrid-50% of the time working from your remote office and 50% from your assigned location. The expectation is to be present in your assigned location three times a week.</span></p> <p style="margin:0.0in 0.0in 8.0pt;line-height:115%"> </p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">PG&amp;E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job.  The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity.  Although we estimate the successful candidate hired into this role will be placed towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.​</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"> </p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">A reasonable salary range is:​</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style=""><span style="">Bay Area Minimum: $​</span><span style="background-color:white">105,000</span></span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="background-color:white">Bay Area Mid:$137,000</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">Bay Area Maximum: $169,000</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">&amp;/OR​</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">California Minimum: $​100,000</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">California Mid:$130,000</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"><span style="">California Maximum: $161,000</span></p> <p style="margin:0.0in;Times New Roman&#39;, serif"> </p> <p><span style=""><strong>Job Responsibilities</strong></span></p> <p> </p> <ul> <li style=""><span style="">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.</span></li> <li style=""><span style="">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.</span></li> <li style=""><span style="">Manages complex data extracts and list pulls ensuring data accuracy. Manages extracting data and transferring the data from databases to various analysts to support operational analysis efforts</span></li> <li style=""><span style="">Creates complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.</span></li> <li style=""><span style="">Demonstrates and utilizes advanced knowledge of data processing and data analysis techniques.</span></li> <li style=""><span style="">Develops and communicates clear, concise and actionable data analyses for clients.</span></li> <li style=""><span style="">Provides recommendations to enhance database(s) with new data sources and improved data processes.</span></li> <li style=""><span style="">Develops and maintains strong relationships with clients to ensure effective communication and collaboration, both verbally and thru written communication.</span></li> <li style=""><span style="">Gathers requirements and business logic through a project intake process, documents requirements and final approved logic and methodology.  Is responsible for the development of up-to-date reference materials for both internal and external clients for all products and datasets.</span></li> </ul> <p style=""> </p> <p><span style=""><strong>Qualifications</strong></span></p> <p><span style="">Minimum:</span></p> <p> </p> <ul> <li style=""><span style="">Bachelors Degree in Marketing, <span style="line-height:107%">Business, Computer Science, Engineering or other related field </span></span></li> <li style=""><span style="">Job-related experience, 4 years</span></li> </ul> <p> </p> <p><span style="">Desired:</span></p> <ul style="margin-top:0.0in;margin-bottom:0.0in" type="disc"> <li style="margin-bottom:0.0in;line-height:normal;background-color:white;margin-top:0.0in;margin-right:0.0in"><span style="">Advanced skill in writing SQL queries using Microsoft SQL Server</span></li> <li style="margin-bottom:0.0in;line-height:normal;background-color:white;margin-top:0.0in;margin-right:0.0in"><span style="">Familiarity with Power BI/Tableau Desktop Applications</span></li> <li style="margin-bottom:0.0in;line-height:normal;margin-top:0.0in;margin-right:0.0in"><span style="background-color:white">Experience in business, electric or gas utility</span></li> </ul> <p> </p>