Senior Business Analyst/ Business Analyst - SEDAA

***************DO NOT APPLY IF ARE NOT LOCAL TO THE JOB LOCATION OR C2C CANDIDATES*********************

***POSITION#1***

JOB ID 3067

Pay range - $48- 56/HR 

Location: Oakland, CA (Hybrid)

Description:

LOOKING FOR CANDIDATES CURRENTLY RESIDING LOCAL TO OAKLAND GO/BAY AREA. WILL BE REQUIRED ON-SITE AT OAKLAND GENERAL OFFICE 2-3 DAYS A WEEK.

TOP THINGS LOOKING FOR:

1. PowerBI developer (expert level) with background in Finance/Accounting.
2. Candidates who have the technical skills but also can be client facing. Should have the presentation ability (i.e. analyzing and presenting the data to senior leadership).
3. Professional resumes - ensure no errors i.e. grammar, spelling, and/or typos in resumes before submitting.

Department Overview

The Office of the CIO (OCIO) represents the cross-functional IT Management capabilities that enable running the business of IT. The OCIO focuses on supporting IT's operation model by ensuring a consistent, transparent, and efficient approach to the way the IT organization delivers value to its partners. The core of the OCIO consists of four areas essential to the long-term success of IT: Contract Management, Business Operations, Program Management Office, and Investment Management.

Position Summary

Seeking a highly motivated Senior Business Analyst to compile and analyze key metrics data to help leaders make informed business decisions. The analyst must have the ability to drive discussions with teams to assist with solving complex business problems. The successful candidate will work with multiple teams within the Information Technology Organization to develop and utilize financial and contracts metrics data for strategic business initiatives and operations. They will lead meetings, form teams, assign tasks, solve data driven problems and manage issues. The person will research best practices; develop internal and external benchmarks in support of helping leaders with business decisions. Additionally, they will have the ability to communicate and influence organizational change and gain organizational support. This role may require the analyst to perform quality assurance and business process improvement activities such as developing, managing, or coordinating performance or quality assessment, change management communications and training.

Specific types of analytics and reporting may include performance dashboards, business analytics, modeling, budgeting, and forecasting.

Job Responsibilities

• Budget Management: Develop, manage, and monitor the annual budget process, ensuring alignment with organizational goals and objectives. Collaborate with department lead planners to gather budget inputs and provide guidance.
• Forecasting: Lead the forecasting process, including monthly, quarterly, and annual forecasts. Analyze variances between actuals and forecasts and provide actionable insights to management.
• Financial Analysis: Conduct detailed financial analysis to support business decisions, including profitability analysis, cost-benefit analysis, and scenario planning.
• Cost Allocation: Design and maintain cost allocation models to accurately distribute costs across departments and projects. Ensure compliance with internal policies and external regulations.
• Reporting: Prepare and present financial reports and dashboards to senior management, highlighting key financial metrics, trends, and variances.
• Strategic Planning: Support long-term strategic planning initiatives by providing financial projections, risk assessments, and recommendations for improvement.
• Data Management: Maintain and improve financial databases and systems to ensure data accuracy and integrity. Implement process improvements to enhance efficiency and reporting capabilities.
• Collaboration: Work closely with cross-functional teams, including business finance, operations, and executive leadership, to provide financial insights and support business initiatives.
• Experience with downloading and extracting data from SAP and creating meaningful business intelligence reports and dashboards
• Create metrics and compile dashboards and reports; develop summary variance explanations and recommends remedial actions
• Assist with the daily operations and provide general IT business & planning support.
• Assist in the initiation and coordinating of studies and analysis on IT operations, resource allocation, financial reviews; and analyzing programs to ensure that program goals and work plans are on target.
• Analyzes actual spend and forecasting to determine if/when appropriate Change Controls must be implemented.
• Provides financial analysis on portfolio cost variances for plan vs. actual and can identify inappropriate charges by resources or vendors and makes appropriate corrections in SAP.
• Proficient in mapping data to original source systems to ensure data accuracy and consistency
• Perform data verification and validation (i.e. tracing, spot checks, building controls) to identify discrepancies and maintain data integrity
• May work as a liaison among stakeholders to coordinate, document, and schedule changes to IT infrastructure and information systems.
• Capture, analyze and present data to managers and directors to aid in making business decisions.
• Effectively plans and control work on a small project; integrates all aspects, tracks and ensures that work progresses on schedule and that work meets specification or required standard.
• Develops communications needed to summarize analysis and to discuss recommendations for peers and executives. This may take the form of dashboards or power point decks.
• Facilitates problems solving sessions and workshops with diverse set of business and technology team members.
• Proactively follows-up on issues and initiatives for senior leaders to ensure successful resolution and implementation.
• Works closely with leaders and other key stakeholders to ensure that key initiatives and activities are delivered in a timely and coordinated manner and aligned with the goals of the organization.
• Works with IT and functional leadership to establish a variety of key business, financial and performance metrics.

Qualifications

Minimum:

• Bachelors Degree in Business Administration or job-related discipline or equivalent experience
• 6 - 8 years job-related experience
• Expert with Power BI. Able to create dashboards from data sets

Desired:

• MBA or Graduate Degree
• Proficient in Microsoft Office, Project, Visio, PowerPoint and expert level Excel skills
• Experience with Power Automate and Power Apps is a plus

Other Desired Experience:

• Technical Skills: Proficiency in financial modeling, Excel, and financial software (e.g., SAP, Oracle, Hyperion). Experience with data visualization tools (e.g. Tableau) is a plus.
• Analytical Skills: Strong analytical and problem-solving skills, with the ability to interpret complex financial data and provide strategic insights.
• Communication: Excellent written and verbal communication skills, with the ability to present complex information clearly and concisely to various stakeholders.
• Attention to Detail: High level of accuracy and attention to detail in financial analysis and reporting.
• Interpersonal Skills: Strong interpersonal skills with the ability to collaborate effectively across departments and with senior management.
• Financial Reporting: Excel and PowerPoint skills to provide monthly reporting.

                            POSITION # 2

Job title : Senior Business Analyst

Location - Oakland, CA

Pay range - $40- 45/HR 

JOB ID #3045

 *Hybrid position. May be required on-site at San Ramon, Dublin or Oakland HQ, when needed, but infrequently. Looking for candidates local to work location/Bay Area as will need to pick up laptop at office for set up.*

EQUIPMENT: Successful hire will need their own monitor, cables, mouse, keyboard or supplier provided. Client will provide Docking station and laptop.

TOP FOUR THINGS LOOKING FOR IN CANDIDATE:

1.  PGE experience desirable but not absolutely necessary
2.  Good attitude, nimble
3.  Proficient in PowerBI, PowerPoint, and excel skills (Microsoft office suite, Sharepoint, Excel, Teams, Powerpoint, Word)
4.  Have a general understanding of governance and change control functions

• Supports the monthly governance cycle / process for the Electric & Gas Operations portfolio including data analysis and reporting, facilitation of meetings and exchanges with Finance partners, and presentation of the final assessment data to executive leadership.
• Drives annual budget adherence for portfolio programs by administering the financial change request process and ensuring change requests are submitted, reviewed, and revised in a timely manner. Reviews risks (overspend) and opportunities (underspend) and evaluates probability to advise on overall impacts to the portfolio financial assessment (end of year forecast).
• Works with Business operations Investment Planning, Line of Business Portfolio Managers, and Programs to administer a financial offset / trigger / lever process to deprioritize lowest priority spending and support a dynamic but balanced budget.
• Applies subject matter expertise to wide-ranging change control processes and challenges.  
• Develops recommendations regarding new or better reports or tools based on assessment of stakeholder needs, trends, strategic direction, and organizational priorities.
• May lead special initiatives around portfolio management and change controls. May assist with some IT related enhancement discussions. Collaborates with cross-functional team members on most effective field rollout of process, tool and/or reporting changes.
• Monitors, prepares regular reports, and presents status to senior management. Organizes, schedules, and leads cross functional stakeholder meetings to review analysis financials/budgets. Discusses and recommends solutions.
• Performs tasks or supports activities required for the portfolio change control function

 Qualifications

 Minimum:

• Bachelor’s Degree in Business, technical field or equivalent related experience
• 5 years of total related experience such as integrated or strategic portfolio/work planning in an utility or related field

 Desired:

• Demonstrated excellent written and verbal communication skills.
• Demonstrated Proficiency in PowerBI, Microsoft SharePoint, Microsoft Teams, Word, PowerPoint and Microsoft Excel and associated analytic tools such as Pivot Tables, charts, slicers, etc.
• Demonstrated experience working with large tabular data sets, diverse data sources, and /or data models.
• Advanced data analysis skills, knowledgeable in collecting data, organizing, synthesizing, reporting, recognizing trending and anomalies, drawing conclusions, and developing recommendations.
• Knowledge in project/work scheduling concepts, methods, and practices.  
• Knowledge of budgeting processes and methods.
• Large team experience and effective collaboration skills among multiple groups.
• Influence and negotiation to gain agreement from various stakeholders.
• Advanced technical skills using systems and applications such as SAP Work Management, SAP Business Warehouse (BW), Excel, and PowerPoint to develop reports, analysis, and deliver presentations

                *****POSITION # 3****

Job title : Business Analyst

Location - Oakland, CA

Pay range- $40- 47/HR 

JOB ID 3003

PRE-DETERMIED AMOUNT FOR CELL AND INTERNET CAN BE EXPENSED MONTHLY WITH MANAGER PRIOR APPROVAL.

TOP THINGS LOOKING FOR:

• Power Query experience
• Power BI experience
• SAP experience

Job Responsibilities

• Performs analysis on moderately complex data models selecting from various reports and data options.
• Determines data needs, collects data, selects from different analytical techniques to achieve desired data outcomes.
• Understands business needs, develops new reports and performs custom/ad-hoc reporting working independently. Presents findings to various audiences.
• Performs basic research internally and externally.
• Communicates with peers inside and outside the department exchanging ideas or gathering information.
• Participates on project teams.

Education Minimum:

• Bachelor of Science in Business, Finance, Economics, Engineering or related discipline or equivalent work experience required.
• Experience Minimum: 2 years of related work experience

Knowledge, Skills, and Abilities (Desired):

• Knowledge of different analytical methods, approaches and tactics
• Full understanding of fundamental analysis and what-if modeling and how different factors affect business outcomes
• Qualitative and quantitative analytical skills
• Organizational, prioritization and multi- tasking skills.
• Adaptable to changing business conditions and ambiguity
• Presentation skills
• Proficiency in Microsoft Office, Project, Visio or similar software

Technical Competencies:

• Advanced in Information Analysis, Metrics and KPI Tracking
• Proficient in Market Research, Consulting Skills, Project Management Skills
• General understanding in Operational Monitoring & Analysis, Advocacy and Persuasion, and Presentation Skills

****POSITION# 4**********

****************ONLY BAY AREA CANDIDATE WILL BE CONSIDERED****************

Job Title: Business Analyst

Location - Hybrid (Oakland, CA)

Pay range - $40- 45/HR 

JOB ID 2900

Description:

LOOKING FOR CANDIDATES CURRENTLY RESIDING IN THE BAY AREA/WORK LOCATION. ASSIGNMENT IS HYBRID AND REQUIRED IN OFFICE AT OAKLAND GO 2-3 DAYS A WEEK. LAPTOP WILL BE ISSUED ANY OTHER EQUIPMENT NEEDED WILL BE PROVIDED BY RESPECTIVE SUPPLIER. CALLS TO BE TAKEN ON LAPTOP VIA MS TEAMS.

TOP THINGS LOOKING FOR:

1. Finance / Accounting background
2. Strong track record of working cross functionally
3. Quick learner

Department Overview:

The Office of the CIO (OCIO) represents the cross-functional IT Management capabilities that enable running the business of IT. The OCIO focuses on supporting IT's operation model by ensuring a consistent, transparent, and efficient approach to the way the IT organization delivers value to its partners. The core of the OCIO consists of four areas essential to the long-term success of IT: Contract Management, Business Operations, Program Management Office, and Investment Management.

Position Summary:

Seeking a highly motivated Senior Business Analyst to compile and analyze key metrics data to help leaders make informed business decisions. The analyst must have the ability to drive discussions with teams to assist with solving complex business problems. The successful candidate will work with multiple teams within the Information Technology Organization to develop and utilize financial and contracts metrics data for strategic business initiatives and operations. They will lead meetings, form teams, assign tasks, solve data driven problems and manage issues. The person will research best practices; develop internal and external benchmarks in support of helping leaders with business decisions. Additionally, they will have the ability to communicate and influence organizational change and gain organizational support. This role may require the analyst to perform quality assurance and business process improvement activities such as developing, managing, or coordinating performance or quality assessment, change management communications and training.

Specific types of analytics and reporting may include performance dashboards, business analytics, modeling, budgeting, and forecasting.

Job Responsibilities:

• Budget Management: Develop, manage, and monitor the annual budget process, ensuring alignment with organizational goals and objectives. Collaborate with department lead planners to gather budget inputs and provide guidance.
• Forecasting: Lead the forecasting process, including monthly, quarterly, and annual forecasts. Analyze variances between actuals/forecasts and provide actionable insights to management.
• Financial Analysis: Conduct detailed financial analysis to support business decisions, including profitability analysis, cost-benefit analysis, and scenario planning.
• Cost Allocation: Design and maintain cost allocation models to accurately distribute costs across departments and projects. Ensure compliance with internal policies and external regulations.
• Reporting: Prepare and present financial reports and dashboards to senior management, highlighting key financial metrics, trends, and variances.
• Strategic Planning: Support long-term strategic planning initiatives by providing financial projections, risk assessments, and recommendations for improvement.
• Data Management: Maintain and improve financial databases and systems to ensure data accuracy and integrity. Implement process improvements to enhance efficiency and reporting capabilities.
• Collaboration: Work closely with cross-functional teams, including business finance, operations, and executive leadership, to provide financial insights and support business initiatives.
• Assist with the daily operations and provide general IT business & planning support.
• Assist in the initiation and coordinating of studies and analysis on IT operations, resource allocation, financial reviews; and analyzing programs to ensure that program goals and work plans are on target.
• Analyzes actual spend and forecasting to determine if/when appropriate Change Controls must be implemented
• Provides financial analysis on portfolio cost variances for plan vs. actual and can identify inappropriate charges by resources or vendors and makes appropriate corrections in SAP.
• May work as a liaison among stakeholders to coordinate, document, and schedule changes to IT infrastructure and information systems.
• Capture, analyze and present data to managers and directors to aid in making business decisions.
• Effectively plans and control work on a small project; integrates all aspects, tracks and ensures that work progresses on schedule and that work meets specification or required standard.
• Develops communications needed to summarize analysis and to discuss recommendations for peers and executives. This may take the form of dashboards or power point decks.  
• Facilitates problems solving sessions and workshops with diverse set of business and technology team members.
• Proactively follows-up on issues and initiatives for senior leaders to ensure successful resolution and implementation.
• Works closely with leaders and other key stakeholders to ensure that key initiatives and activities are delivered in a timely and coordinated manner and aligned with the goals of the organization.
• Experience with downloading and extracting data from SAP and creating meaningful business intelligence reports and dashboards.
• Works with IT and functional leadership to establish a variety of key business, financial and performance metrics.
• Create metrics and compile dashboards and reports; develop summary variance explanations and recommends remedial actions

Desired:

• MBA or Graduate Degree
• Proficient in Microsoft Office, Project, Visio, PowerPoint and expert level Excel skills
• Experience with Power BI, Power Automate and Power Apps is a plus

Other Desired Experience:

• Technical Skills: Proficiency in financial modeling, Excel, and financial software (e.g., SAP, Oracle, Hyperion). Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
• Analytical Skills: Strong analytical and problem-solving skills, with the ability to interpret complex financial data and provide strategic insights.
• Communication: Excellent written and verbal communication skills, with the ability to present complex information clearly and concisely to various stakeholders.
• Attention to Detail: High level of accuracy and attention to detail in financial analysis and reporting.
• Interpersonal Skills: Strong interpersonal skills with the ability to collaborate effectively across departments and with senior management.
• Financial Reporting: Excel and PowerPoint skills to provide monthly reporting.