Principal Data Analyst

Requisition ID # 164183 

Job Category: Business Operations / Strategy 

Job Level: Manager/Principal

Business Unit: Finance

Work Type: Hybrid

Job Location: Oakland

Department Overview
The Business Finance teams provide financial planning and reporting services to PG&E and is responsible for providing strategic direction and coordination in respect to strategic functional area planning processes, financial planning, forecasting, analytics and reporting.

The Value Delivery program, part of the Business Finance team, is a transformative effort to optimize PG&E’s strategy to realize value to support the company's long-term growth while maintaining affordability for our customers. With the goal of improving our Cap/Expense ratio over a six-year period - representing $1-$2B in savings, the program will lead the enterprise plan to deliver operational efficiency and financial performance.

Position Summary
We are seeking a highly skilled and accomplished Principal Strategic Analyst to create ELT/ETL workflows, scripts, visualizations, statistical models while taking responsibility for the design, build, test, execution, and support of data-related activities including but not limited to integration, profiling, cleansing, and visualizing. The ideal candidate will have a detailed understanding of the underlying data and data structures of multiple systems to allow in-depth analysis of existing and potential data insights.

The role is hybrid working from your remote office and in-person at the Oakland General Office 2-3x weekly or based on business needs. 

PG&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 between the entry point and the middle of the range, the decision will be made on a case-by-case basis related to these factors.​ This job is also eligible to participate in PG&E’s discretionary incentive compensation programs.   

A reasonable salary range is:​  

Bay Area Minimum:      $136,000.00

Bay Area Maximum:     $232,000.00

Job Responsibilities 

• Evaluate enterprise performance and provide data-driven insights that lead to actionable recommendations
• Frame analytic approaches and lead quantitative analyses that will yield critical answers to key questions
• Collect data from a wide variety of enterprise databases, including SAP, Oracle CC&B, ECC, Alteryx, Foundry, Redshift, MSSQL, Synapse, Excel, plain or formatted text files, etc.
• Implement automated data ingestion and transformation processes
• Enrich company data through external and public sources
• Design database models, efficient table structures, and advanced schemas that carry out data quality and consistency standards
• Apply modern modeling approaches, business intelligence patterns, and data management techniques
• Rock-solid SQL skills to work with extensive volumes –millions of rows- of data at various aggregation levels
• Develop code/scripts to apply data processing logic and business rules
• Apply statistical learning toolsets to build predictive models that enrich, expand, and allow a deeper understanding of data analyses and solutions
• Well versed with Python/SAS to build descriptive predictive models that enrich, expand, and allow a deeper understanding of data analyses and solutions
• Use of interactive data visualization tools, such as Tableau and Power BI, to present results in a compelling manner, for the benefit of internal or client teams
• Ability to tell a convincing story to C-level executives using visual charts and dashboards
• Present complicated technical findings to a non-technical audience
• Prepare polished documents and compelling presentation materials
• Work with all levels of leadership (up to and including SVP/EVP) across functions to drive and influence strategic planning and decision making
• Identify opportunities for targeted, cost-effective resource (savings) acquisition
• Conduct trend and sensitivity analyses
• Coach, mentor, and train others as needed

Qualifications

Minimum:

• Bachelor’s degree in Economics, Statistics, Mathematics, Business, Finance, Sociology, Policy, Engineering, Physics or other related fields
• 8 years of job-related experience

Highly Desired: 

• Experience working with Big Data, information retrieval, data mining or machine learning, as well as experience in building multi-tier high availability applications with modern web technologies (such as NoSQL, MongoDB, SparkML, TensorFlow).
• Develop emerging risk frameworks and dashboards to highlight the details behind any abnormal trends at granular level
• Excellent understanding of machine learning techniques and algorithms, such as k-NN, Naive Bayes, SVM, Decision Forests, etc.
• Data-oriented personality
• Ability to synthesize the requests from management at all levels  
• Capability to be a creative, innovative problem solver - but using simple ideas
• Knowledge of any of the following languages: Python, JavaScript, C#, or similar plus familiarity with at least one ETL tool (such as Alteryx, KNIME, SSIS, Pentaho, or DataStage)
• Develop KPIs/KRIs wherever needed to provide an initial view of performance/risks.
• Motivated to discover and learn new analytical techniques and software tools to improve the quality of our work
• Strong verbal and written communication skills in English. Proficiency in other languages is a plus
• Ability and willingness to work long hours if necessary, to meet urgent needs
• Ability to work full-time in an office and remote environment; physically able to sit/stand at a computer and work in front of a computer screen for significant portions of the workday

#featuredjob