Senior Asset Management Data Analyst

Senior Asset Management Data Analyst, Flexible Location: Sacramento Area or East Bay, CA

Position Summary

Conducts data analysis, research, forecasting, and reporting in support of business decision making, strategy and operations, primarily focused on PG&E’s corporate real Estate Asset Management Program. Supports and administers key IT systems. Participates in business process improvement, quality control and other initiatives.

Responsibilities:

Responsibilities typically include many or all the following:

• Data Analysis: Compiles and analyzes data. May develop and/or maintain data models for what-if analysis and for other business purposes
• Metrics and Reporting: Develops and tracks business metrics. Develops business intelligence dashboards and maintains standard, custom, and ad-hoc reports
• Budgeting & Forecasting: Develops or works with budgets and forecasts.
• System Administration: Supports & administers key CRESS IT systems, including:
• Development/configuration of system enhancements
• Enrolling users with appropriate access permissions and maintaining system security
• Monitoring and optimizing system/database performance to enhance user experience
• Planning for and ensuring database backup and recovery as needed
• Maintaining archived data
• Running imports/exports of data to/from interfacing systems/tools
• Providing data quality assurance and control
• Trouble shooting and resolving system issues
• Quality Assurance & Business Process Improvement: May perform quality assurance and business process improvement activities in support of the business. Activities may include developing, managing, or coordinating performance or quality assessment, business process re-engineering, change management, communication, and training
• Performs analysis on highly complex data models that have cross- functional impact
• Supports IT related enhancements and system development. Collaborates with team members on most effective field rollout of process, tool and/or reporting changes
• Creates and delivers user training, including development and management of user guides/manuals as needed
• Develops innovative data solutions to address complex business issues
• Presents findings and proposed recommendations to leaders
• Works with and leverages relationships with Directors and Managers across functions / PG&E.

Qualifications

Minimum:

• 6 years of experience in planning, finance, and/or information or data analysis
• Advanced MS Excel (data analytics, Power Query, pivot tables, charts)
• Expert in Microsoft Power BI
• Expert in MS Access SQL, MY SQL
• Expert in Python and/or VBA coding languages
• Proficient with Office 365 products including Word, Excel, PowerPoint, Sharepoint Online, and Teams

Desired:

• Strong analytical skills with ability to succinctly interpret data for executives and frame business issues in a straightforward manner
• Experience solving complex problems through quantitative data driven analysis, modeling, and experience using spreadsheet and presentation tools for data visualization
• Experience working with VFA Asset Management, MS Power Platform, MS Access and Smartsheet software applications
• Corporate Real Estate experience within corporate services, transaction management, construction, workplace design, or other related strategic real estate planning experience