Business Analyst

Job TitleLocation: Oakland, CA Duration: 12 Months Work Mode: Hybrid, at least 2 days per week onsite at Oakland General OfficeResponsibilities: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.