What are the responsibilities and job description for the Principal Data Analyst position at PG&E Corporation?
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
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
Salary : $136,000 - $232,000
