Business Analyst

Location: Oakland, CA
Duration: 12 Months
Work Mode: Hybrid, at least 2 days per week onsite at Oakland General Office

Responsibilities:

• Perform analysis on moderately complex data models using a variety of reporting and data sources.
• Collect, organize, analyze, and validate data to support business, operational, and investment planning activities.
• Develop reports, dashboards, metrics, and ad-hoc analyses to support portfolio planning and business decisions.
• Support portfolio-level analysis of capital investment plans, including evaluation of cost, risk, benefit, and funding considerations.
• Assist in the development and refinement of investment scenarios, planning assumptions, and portfolio recommendations.
• Support reporting and analysis associated with portfolio optimization outputs and planning tools (e.g., Copperleaf).
• Respond to ad-hoc data requests and support operational analysis activities.
• Partner with Finance, Asset Management, Engineering, Planning, and Operations teams to gather information, align assumptions, and support planning initiatives.
• Build and maintain automated data routines, reporting processes, and dashboards to improve efficiency and data quality.
• Perform data validation, reconciliation, and QA/QC activities to ensure accuracy, consistency, and auditability of portfolio data and reporting.
• Track, document, and maintain records of investment, portfolio, and planning changes across multiple planning cycles.
• Support business process documentation, requirements gathering, and process improvement initiatives.
• Maintain project, portfolio, and planning documentation within SharePoint and other enterprise repositories.
• Assist with cataloging, documentation, and data management activities across multiple IGP initiatives.
• Extract, analyze, and reconcile data from enterprise systems such as SAP, Foundry, GIS, and other planning platforms.
• Identify opportunities for automation, standardization, and process efficiencies.
• Participate on project teams and support governance reviews, stakeholder meetings, and reporting activities.
• Perform other ad-hoc analyses and reporting as needed.

Requirements:

• Experience analyzing datasets and developing insights using Excel, Power BI, or similar tools.
• Strong organizational skills with experience managing documentation, records, and supporting multiple concurrent initiatives.
• Understanding of financial concepts such as cost, risk, budgeting, capital planning, or investment planning.
• Experience supporting portfolio management, business planning, capital planning, or investment planning processes.
• Experience working with enterprise systems such as SAP, Foundry, GIS, Copperleaf, or similar platforms.
• Experience extracting, validating, and analyzing data from multiple enterprise systems.
• Experience developing reports, KPIs, dashboards, and performance metrics.
• Familiarity with business process documentation, requirements gathering, and process improvement activities.

Preferred Skills:

• Experience in utility, energy, infrastructure, engineering, or other regulated industries preferred.
• Demonstrated willingness and ability to learn new tools, technologies, and business processes.
• Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint), SharePoint, and Power BI.