Business Analyst

POSITION # 1

Job title : Business Analyst

Location - Oakland, CA

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#2

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

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.

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.