Business Data Analyst

Role: Business Analyst, Senior

Location: Oakland, CA (Hybrid – 1-2 Days per week onsite)
Duration: 12+ Months Possible to Extend the role.

Contract Type: W2 Only - No C2C or 1099

Top things looking for:

• Advanced Modeling & Repository Management with AI: Independent execution of predictive, statistical, and probability models to quantify reputation drivers and headwinds, backed by centralized, always-on tracking of complex datasets on a dedicated server, and updated for operating reviews weekly, monthly, quarterly, annually.
• Executive Visualization & BI Builds: Designing, building, and maintaining error-free, user-friendly, real-time BI dashboards to deliver always-on automated visual trends and insights.
• C-Suite Delivery & Vendor Management: Presenting actionable insights directly to the executive suite, answering real-time data questions with sharp attention to detail, critical thinking, and punctual execution; ownership of vendor relations and proactive work with vendors to obtain, QA and manage any data including .xls, APIs, RAGs, AI, MCP feeds.

Description:

• Will need to report in person to office occasionally - Hybrid, expectation is 1-2x week in the office.
• **This person will need to have experience with cross-functional and vendor data management, data modelling, AI and programming, presenting data insights to executives, designing business intelligence visualizations - it cannot be someone needing direction at every step.**

Top requirements:

· Modeling Expertise: Independent building and execution of predictive, statistical, and probability models to quantify complex reputation drivers and headwinds.

· Repository Management: Ingesting, integrating, and interpreting complex datasets and metrics on a dedicated server for centralized, always-on tracking.

· Visualization BI Builds: Designing, building and maintaining error free, executive-ready, user-friendly BI charts with real-time trends and insights.

· Cross-Functional C-Suite Delivery: Developing and presenting actionable insights to executives, answering real time analytics questions, thinking critically, delivering punctually, with sharp attention to detail.

Core scope:

• Develops Predictive Models and Scenarios: Forecasts and sets targets for KPIs, developing and applying statistical forecasting models that connect vendors’ data to reputation drivers, predicting impacts from headwinds and tailwinds on KPI trajectories weekly, monthly, quarterly, yearly, giving leaders scenarios/options for decisions.
• Creates Data Visualizations: Builds always-on, lean, executive level, user-friendly PowerBI and Copilot tools showing trends, forecasts, insights for data-driven business decisions with LLM-generated takeaways and natural language search. Provides daily, weekly, or monthly deep-dive analytics as needed.
• Updates Business Reporting: Owns benchmarking, monitoring and optimization of enterprise reports. Delivers and where needed creates weekly, monthly, quarterly, and annual reports tracking shifts in KPI performance, flagging upcoming risks to business objectives, analyzing complex datasets from brand and communications campaigns.

Technical skills:

• Runs Analytics Tech Stack: Manages daily custom workflows and secure data connections following enterprise governance.
• Deploys advanced expertise in SQL, Python, R, Snowflake, Power BI, Tableau, Azure, and other including vendor APIs, and MCPs to process structured and unstructured data (video, audio, text).
• Automates Data Platforms: Maintains a dedicated server daily to ingest, integrate and interpret vendors’ data feeds to centralize always-on tracking, with automated quality checks and built-in pipeline documentation.
• Audits Dashboards, Reports, AI Workflows for Accuracy: Owns, reviews and validates all data streams, AI code, models, business intelligence tools daily, to ensure error-free executive outputs.

Competencies:

• Owns Cross-Functional Collaborations: Partners proactively across *** IT, Cyber Security, CX, external agency partners, and other teams on data analytics, applications, problem solving, value and customer journey mapping. Applies familiarity with utility frameworks and California’s net-zero/decarbonization goals.
• Thinks Critically and Communicates Strongly: Is a strong, effective communicator with C-suite, able to develop and present actionable insights, answer questions in real time on data trends, headwinds, impacts and more; listens and understands what leaders ask to see, delivering as requested, punctually, and with sharp attention to detail.