Business Analyst

Business Analyst

The role is hybrid, at least 2 days per week onsite in Oakland. Duration: 1 year contract. Pay Range: $60.00/hour - $63.00/hour W2

Top three qualifications or attributes:

• Strong business analysis and problem-solving skills: Experience analyzing data, identifying trends, developing recommendations, and supporting business decisions through reporting and analysis.
• Organization, data management, and attention to detail: Experience maintaining documentation, tracking changes, managing records, reconciling data, and ensuring accuracy, consistency, and auditability.
• Financial and planning acumen: Understanding of budgeting, cost analysis, capital planning, investment planning, portfolio management concepts, or similar business processes.

Technical Skillsets:

• Experience with SAP and/or other enterprise systems (Copperleaf, Foundry, GIS, or similar planning and portfolio management tools)
• Strong Excel and Power BI skills for reporting, dashboards, data analysis, and KPI tracking
• Experience extracting, validating, reconciling, and analyzing data from multiple sources and systems
• Experience creating and maintaining reports, documentation, process flows, metrics, and business process deliverables

Soft Skills:

• Exceptional organizational skills and ability to manage multiple priorities, initiatives, and requests simultaneously
• Strong cross-functional collaboration and communication skills (preferably with experience working across Finance, Engineering, Planning, Asset Management, and Operations teams)
• Learning agility and willingness to learn new systems, tools, and processes (e.g., Copperleaf, Foundry, IGP business processes)
• Attention to detail with a focus on data quality, documentation, change tracking, and process discipline

Assignment Overview:

The Integrated Grid Planning (IGP) organization is seeking a Business Analyst to support the development and execution of multi-year electric investment plans. This role focuses on business analysis, portfolio planning support, reporting, process improvement, and data-driven decision support. The analyst will work with cross-functional teams to analyze data, support investment planning activities, maintain portfolio records, and translate complex information into actionable insights for stakeholders. The ideal candidate is highly organized, detail-oriented, and comfortable working across multiple systems, datasets, and planning processes. Successful candidates will demonstrate strong analytical skills, a willingness to learn new tools and processes, and the ability to manage and maintain accurate planning documentation.

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.

Desired Qualifications:

• 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.
• 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.

Key Skills & Capabilities:

• Strong analytical and problem-solving skills.
• Exceptional organizational skills and attention to detail.
• Ability to maintain accurate documentation, records, and audit trails.
• Ability to work with large datasets and multiple enterprise systems.
• Effective written and verbal communication skills.
• Ability to translate business needs into data-driven analyses and recommendations.
• Strong collaboration skills and ability to work across cross-functional teams.
• Adaptability and willingness to learn new tools and technologies, including Copperleaf, Foundry, and other planning platforms.
• Ability to manage multiple priorities in a fast-paced environment.

Success Criteria (What Good Looks Like):

• Delivers accurate, timely, and actionable analysis, reporting, and planning support.
• Maintains high standards for data quality, documentation, change tracking, and auditability.
• Effectively supports cross-functional stakeholders through responsive analysis, reporting, and communication.
• Identifies opportunities to improve processes, reporting, automation, and data management.
• Demonstrates strong organizational skills and successfully manages multiple priorities and initiatives.
• Quickly learns and effectively utilizes new tools, systems, and business processes.

Benefits:

Health insurance, Health savings account, Dental insurance, Vision insurance, Flexible spending accounts, Life insurance, Retirement plan

We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.