Data Analytics Analyst

Spectraforce Technologies; Oakland (CA); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Spectraforce Technologies, Inc. is seeking a Data Analytics Analyst in Oakland, CA for a 12-month hybrid role. The position requires on-site presence 1–2 days per week and close collaboration with cross-functional teams and external vendors.

The candidate will develop predictive models, data visualizations, and enterprise reports. Strong SQL/Python/R skills plus BI tool experience are essential for delivering executive-ready insights.

Qualifications

• Experience in cross-functional and vendor data management, data modelling, AI and programming, and presenting data insights to executives.
• Ability to design BI visualizations and dashboards for executive audiences.
• Proven track record of independent data analysis and insight delivery.

Responsibilities

• Design, build and maintain real-time BI dashboards for executives.

Skills

Cross-functional collaboration

Executive data insights

Analytical thinking

Critical thinking

Tools

SQL

Python

R

Snowflake

Power BI

Tableau

Azure

APIs

Copilot

Job description

Data Analytics Analyst

Oakland, CA (Hybrid - required on-site 1-2 times a week)

12 Months

Notes:

• Only Submit Local Candidates Currently Near Work Location In Oakland.
• Manager Prefers Candidates Be Within 25 Miles Of Oakland General Office.
• Assignment Is Hybrid And Required On-site 1-2 Times A Week.
• Client Laptop Will Be Provided. (Any Additional Equipment Needed To Be Provided By Supplier)
• With Manager Prior Approval Candidate Can Expense Monthly Expense For Internet.

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.

TOP REQUIREMENTS

• 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.
• 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 PG&E 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.