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 analysisAdvanced MS Excel (data analytics, Power Query, pivot tables, charts)Expert in Microsoft Power BIExpert in MS Access SQL, MY SQLExpert in Python and / or VBA coding languagesProficient with Office 365 products including Word, Excel, PowerPoint, Sharepoint Online, and TeamsDesired :
Strong analytical skills with ability to succinctly interpret data for executives and frame business issues in a straightforward mannerExperience solving complex problems through quantitative data driven analysis, modeling, and experience using spreadsheet and presentation tools for data visualizationExperience working with VFA Asset Management, MS Power Platform, MS Access and Smartsheet software applicationsCorporate Real Estate experience within corporate services, transaction management, construction, workplace design, or other related strategic real estate planning experience