Business Intelligence Analyst

Job Title: (Agile1)Operations Data Analyst, Expert Location: Oakland, CA 94612 Experience: 12 Months on W2 contract Note: The role is hybrid, up to 4 days as needed per month onsite at Oakland General Office. • Client laptop will be provided once available. A vendor-issued laptop would be acceptable to access the PG&E network via VPN/Citrix until PG&E issues one.. No other equipment will be provided and additional equipment needed is the responsibility of supplier. Calls to be made via MS Teams. • Position Summary The Data Analyst is responsible for transforming complex data into clear, actionable insights that drive operational and strategic decision-making. This role requires an exceptional communicator who can clearly explain data, assumptions, and insights to technical and non-technical stakeholders alike. The ideal candidate is highly proficient in Power BI for reporting and visualization and Foundry for advanced analytics and data modeling, and is comfortable working across multiple enterprise systems and teams. Responsibilities: Data Analysis & Insights • Analyze business data to identify trends, patterns, risks, and opportunities for operational and strategic improvements • Demonstrate broad expertise in data processing and analysis, applying analytical techniques to a wide range of business questions • Respond to ad hoc and recurring data requests with accuracy, clarity, and timeliness Data Management & Integration • Collect, clean, validate, and integrate data from multiple sources to ensure accuracy and consistency • Extract and analyze data from SAP to support planning, forecasting, and decision-making • Manage data extraction and transfer from databases to support operational analysis across teams • Create automated data routines and processes to ensure efficient, repeatable reporting and data delivery Reporting, Visualization & Tools • Develop and maintain dashboards, reports, and visualizations using Power BI to clearly communicate insights and performance metrics • Utilize Foundry for advanced analytics, data modeling, and analytical workflows ( knowledge of Foundry is preferred, not a requirement) • Apply GIS tools for spatial data analysis and mapping to support location-based decision-making • Leverage Copperleaf for asset investment planning, lifecycle cost analysis, and value-based decision support ( knowledge of Copperleaf is preferred, not a requirement) Communication & Collaboration (Core Requirement) • Clearly communicate analytical findings, assumptions, and recommendations to diverse audiences • Translate complex data into concise, compelling narratives that support informed decision-making • Collaborate with cross-functional teams to understand business needs, identify challenges, and deliver data-driven solutions • Act as a trusted partner to stakeholders by helping shape analytical questions and clarify insights Minimum Qualifications: • Bachelor’s degree in Data Analytics, Statistics, Computer Science, Business, Engineering, or a related field (or equivalent experience) • Demonstrated experience building and maintaining dashboards in Power BI • Strong SQL skills and experience working with structured datasets • Excellent written and verbal communication skills, with a proven ability to explain complex data clearly • Strong ability to interpret data, identify trends, and generate actionable insights • Ability to clearly communicate complex data findings to both technical and non-technical stakeholders. • Experience working in cross-functional teams and translating business needs into data-driven solutions. Desired Qualifications: - Hands-on experience using Foundry for data analysis, data modeling, or workflows - Experience with Copperleaf