Expert, Business Analyst (Flexible Location)
Oakland, CA, US, 94612
Pacific Gas and Electric Company
Pacific Gas and Electric Company (PG&E) provides natural gas and electric service to residential and business customers in northern and central California.Requisition ID # 160467
Job Category: Business Operations / Strategy
Job Level: Individual Contributor
Business Unit: Enterprise Health & Safety
Work Type: Hybrid
Job Location: Oakland
Position Summary
Business Analysts are responsible for research, data analysis, budgeting, forecasting and reporting in support of business decision making, business strategy and business operations. May also be involved in business process improvement, quality control and special projects and other initiatives.
Responsibilities typically include many or all of the following:
- Data Analysis: Compiles and analyzes data. May develop and/or maintain data models for what-if analysis and for other business purposes.
- Metrics and Reporting: Develops and tracks business metrics. Develops and maintains standard, custom and ad-hoc reports.
- Budgeting & Forecasting: Develops or works with budgets and forecasts.
- Research: Research best practices; develops internal and external benchmarks in support of business decisions.
- Quality Assurance & Business Process Improvement: May perform quality assurance and business process improvement activities in support of the business. Activities may include developing, managing or coordinating performance or quality assessment, business process re-engineering, change management, communication and training.
- Project Management: Lead projects, determining scope, budget, timeframes, forming teams, assigning tasks, managing resources and issues.
This position is hybrid, working from your remote office, and your assigned location based on business need. Headquarter location is flexible within PG&E service territory.
PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. Although we estimate the successful candidate hired into this role will be placed towards the middle or entry point of the range, the decision will be made on a case-by-case basis related to these factors.
A reasonable salary range is:
Bay Area Minimum: $114,000
Bay Area Maximum: $182,000
OR:
California Minimum: $108,000
California Maximum: $173,000
Job Responsibilities
- Performs analysis on highly complex data models that have cross- functional impact.
- Applies advanced knowledge to wide- ranging issues.
- Develops innovative data solutions to address complex business issues. Presents findings and proposed recommendations to leaders.
- Develop business cases in support of strategy or change initiatives.
- Works with and leverages relationships with Directors and Managers across functions / PG&E.
- Manages cross-functional projects or initiatives.
- May provide direction and coaching to other Business Analysts.
- Manages end-to-end BI development from gathering requirements through deployment
- Develops new data models, reports, and dashboards using Power BI
- Manages multiple data analysis and visualization projects or initiatives
- Effective use of SQL and Power Query for ETL (Extract Transformation & Load)
- Effectively write DAX formulas to create measures and extract meaningful data
Qualifications
Minimum:
- Bachelors Degree in Business Administration or job-related discipline or equivalent experience
- Job-related experience, 6 years
Desired:
- Advanced skills in working with Excel, Access, SQL Server, SAP, and other similar applications
- Experience using Python or R
- Tableau development experience
- MBA or graduate degree
- Project management skills and experience working with cross-functional teams
- Strong oral and written communication skills
- Excellent organizational, prioritization, and multi-tasking skills
- Must be adaptable to ambiguity and changing business conditions
- Familiarity with PG&E Health & Safety systems, programs, and data
- Progressive experience working with data and providing ad-hoc reporting
- Experience developing interactive dashboards and visual reports in Power BI
- Effective use of SQL and Power Query for ETL (Extract Transformation & Load)
- Effectively write DAX formulas to create measures and extract meaningful data
#featuredjob
Tags: Data analysis Engineering ETL Excel Power BI Python R Research SQL Tableau
Perks/benefits: Career development Equity / stock options Flex hours
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.