Work Structure:
Hybrid, mostly remote with occasional in-office days in Oakland (must be local to Northern/Central California)
Location:
Downtown Oakland, CA
Schedule:
Full-time, Monday to Friday
Duration:
6-month W2 contract
Pay Rate:$36.50 - $40.50/hr
Position Summary
Our client, a major electric and gas utility in Northern and Central California, is hiring a Business Analyst for its Business Intelligence & Operations team. The team runs business operations for groups across the client's Data, AI & Security organization, including Data Analytics & Insight, Enterprise Artificial Intelligence, Cybersecurity, Corporate Security, and other departments.
The Business Analyst will own financial reporting, monthly variance analysis, and headcount and contractor governance for two groups in the organization. The role is split between financial planning and analysis (FP&A) and metrics and reporting. You'll build metrics and reporting in Power BI, partner with leaders on forecast accuracy, and look after the headcount process from start to finish, including backfills. The team is growing in the AI space. They want someone curious and self-motivated who will try new tools and approaches, has hands-on experience with automation and reporting, and can get up to speed quickly with little direction. The team mostly works remotely, but you'll need to be local for occasional training, meetings and collaboration.
Essential Functions and Responsibilities
- Own FP&A and reporting for the assigned department, including monthly variance analysis, forecasting, and metrics and reporting
- At the start of each month, work with leaders on forecast accuracy metrics and variance breakdowns, closing out the prior month and locking the forecast for the next
- Report on whether KPIs and forecast accuracy targets were met
- Own the annual operating planning process
- Develop and maintain the organization's Power BI dashboard
- Handle resource planning for project and baseline activities using headcount and contractor management governance, and oversee the full headcount process, including backfills
- Help streamline operational processes and procedures, spotting gaps and fixing them
- Analyze business problems and design practical solutions, iterating based on user and stakeholder feedback
- Lead requirements-gathering efforts of low to medium complexity
- Analyze end-to-end business processes of low to moderate complexity and the information needs of clients in one or more business functional areas
- Evaluate and document alternatives that will provide the most effective solutions to business problems
- Understand the current and future business environment to anticipate, identify and meet business needs, including the metrics and reporting leaders will need
- Track and document time and cost savings achieved through automation and process improvements
- Stay current on new Power Platform and AI capabilities, and proactively propose and pilot new ideas
Education/Experience
- BA/BS in Business Administration, Economics, Data Analytics, Information Systems, or another relevant discipline, or 4+ years of equivalent job-related experience
- 4+ years of experience preferred, ideally in FP&A, with a strong understanding of financials and reporting
- Hands-on experience with Microsoft Power Platform (Power BI, Power Automate, Power Apps) and exposure to Copilot Studio
- Around 2 years of experience using generative AI tools such as Copilot to automate workflows, reporting and transactional tasks, including AI-assisted development ("vibe coding")
- 2+ years of experience in similar or related job functions (Information Technology or Business) desired
- Utility industry experience desired
Knowledge/Skills
- Proficient with Excel and other Microsoft products
- Strong Power BI skills; SAP experience preferred
- Working knowledge of at least one programming or query language (e.g., SQL, Python, M (Power Query), DAX, TMDL, Power Fx, R) desired
- Can think strategically, stepping back from daily tasks to a long-term plan and vision
- Proven ability to apply AI and technical solutions to real business problems
- Examples of automations, reports or tools you built on your own initiative to improve a process
- General understanding of the utility business and at least one functional area of the related line of business
- Detail-oriented, analytical and curious, with good oral and written communication skills
- Able to work independently with minimal direction while collaborating with others in the group to persuade, exchange ideas and foster cooperation
- Able to work with different teams across disciplines and levels
- Self-starter who takes initiative, is happy to try new tools and approaches, and learns from what doesn't work
- Coachable and actively seeks feedback and applies it to keep improving
...