Talent.com
Senior Asset Management Data Analyst

Senior Asset Management Data Analyst

AT-PD | Advanced Technology Project DeliverySacramento, CA, United States
3 days ago
Job type
  • Full-time
Job description

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
  • Create a job alert for this search

    Asset Management Analyst • Sacramento, CA, United States