Pay Range: $62.44/hr. on w2
Senior Business Analyst – Data Analytics, AI & Business Intelligence
Requisition ID: PCGJP00005310
Location: Oakland, CA
Work Arrangement: Hybrid – 1–2 days onsite per week
Employment Type: Contract
Job Summary
We are seeking an experienced Senior Business Analyst with strong expertise in Data Analytics, Predictive Modeling, Artificial Intelligence, and Business Intelligence. The ideal candidate will independently manage complex datasets, develop predictive and statistical models, build executive-level dashboards, and translate data into actionable business insights.
This role requires a hands-on professional with strong programming and analytical capabilities, experience managing vendor data, and the ability to communicate findings and recommendations directly to C-suite executives and cross-functional stakeholders.
The successful candidate should be comfortable taking ownership of projects from data collection and integration through analysis, visualization, reporting, and executive presentations without requiring constant supervision.
Key Responsibilities
1. Predictive Modeling & Advanced Analytics
- Independently develop and execute predictive, statistical, and probability models to evaluate business performance, reputation drivers, risks, and opportunities.
- Build forecasting models to predict KPI trends and measure the potential impact of business headwinds and tailwinds.
- Develop scenarios and recommendations to support strategic business decisions.
- Establish performance targets and forecasts across weekly, monthly, quarterly, and annual reporting cycles.
2. Data Management & Repository Administration
- Ingest, integrate, organize, and analyze complex datasets from multiple internal and external vendors.
- Maintain centralized data repositories and dedicated servers to support continuous data tracking and reporting.
- Establish automated data validation, quality checks, and documentation processes.
- Manage structured and unstructured data from multiple sources, including Excel files, APIs, AI feeds, and other data platforms.
3. Business Intelligence & Dashboard Development
- Design, develop, and maintain interactive, user-friendly, and executive-ready BI dashboards.
- Build automated visualizations using Power BI, Tableau, and Microsoft Copilot.
- Present real-time business trends, forecasts, KPI performance, and actionable insights.
- Leverage AI and Large Language Models (LLMs) to generate analytical summaries, insights, and natural-language search capabilities.
- Ensure dashboards and reports are accurate, reliable, and easy for business leaders to interpret.
4. Executive Reporting & Business Insights
- Prepare and maintain weekly, monthly, quarterly, and annual business performance reports.
- Monitor KPIs, identify performance trends, and highlight potential risks to business objectives.
- Analyze data related to brand reputation, customer experience, and communication campaigns.
- Present findings, forecasts, and strategic recommendations directly to senior leadership and C-suite executives.
- Respond to real-time analytical questions with accuracy, critical thinking, and attention to detail.
5. Vendor & Cross-Functional Collaboration
- Manage relationships with external data vendors and agency partners.
- Coordinate with vendors to obtain, validate, integrate, and maintain data feeds.
- Collaborate with IT, cybersecurity, customer experience, and other business teams.
- Manage data connections, analytical workflows, and reporting processes in accordance with enterprise governance and security standards.
- Support business process improvements, problem-solving initiatives, and customer journey analytics.
Required Technical Skills
- Strong hands-on experience with Power BI and/or Tableau for dashboard development and data visualization.
- Advanced proficiency in SQL, Python, and/or R.
- Experience with predictive modeling, statistical analysis, probability modeling, and forecasting.
- Experience working with Snowflake, Microsoft Azure, or similar cloud data platforms.
- Knowledge of AI/ML, Generative AI, Large Language Models (LLMs), Microsoft Copilot, RAG, and MCP integrations.
- Experience integrating data through vendor APIs, automated pipelines, and other data feeds.
- Strong understanding of data repositories, data ingestion, data quality, and validation processes.
- Ability to process and analyze structured and unstructured data, including text, audio, and video.
Required Qualifications
- Proven experience in Senior Business Analyst, Data Analytics, Business Intelligence, or a related analytical role.
- Demonstrated ability to independently develop predictive and statistical models.
- Strong experience designing and maintaining executive-level BI dashboards and reports.
- Experience managing complex datasets and coordinating with external data vendors.
- Excellent communication and presentation skills, with experience presenting insights to senior executives.
- Strong analytical thinking, problem-solving, organizational skills, and attention to detail.
- Ability to manage multiple priorities and deliver accurate results independently.
Work Location & Schedule
- Location: Oakland, California.
- Hybrid work arrangement.
- Must be currently local to the Oakland area, preferably within 25 miles of the office.
- Required onsite presence: 1–2 days per week.
Additional Information
- A company laptop will be provided.
- Any additional equipment required must be arranged by the supplier.
- Monthly internet expenses may be reimbursed with prior management approval.
