Data Analyst

Duration: 8 months

Location: Hybrid (Oakland, CA 94612 )

**ONLY W2**

This company is a major energy provider in the United States, delivering natural gas and electricity to millions of customers. It operates an extensive infrastructure network, including power generation facilities, pipelines, and transmission systems.

Top Skills

• PowerBI
• Tableau
• Advanced Excel
• Data Modeling (Desired)

Core Scope

• Support multiple teams in the process for benchmarking, creating, capturing, monitoring, reporting and optimizing of OKRs and KPIs
• Analyze, integrate and interpret data from brand, marketing, and comms campaigns for actionable insights in a dynamic environment.
• Create dashboards and reports for data-driven decision making.
• Create statistical probability models that quantify relationships between KPIs, their drivers, and generate forecasted quantitative impacts for campaigns (e.g., NPS, AVE, marketing mix with dynamic advertising pricing, social sentiment and engagement, reputation management, etc.), particularly for brand equity, brand trust and brand ROI.
• Lead or support the presentation of results to department team members and leadership

Experience Desired

• Expertise in programming and visualization tools such as Python, SQL, R, Tableau, PowerBI, Adobe Analytics, etc.
• Proficiency in advanced data analysis, machine learning, predictive analytics to create forecasts and content for Lean reporting.
• Lean literacy.
• Value mapping and journey mapping experience.
• Prior work with cross-functional teams and external vendors/agencies and their datasets.
• Familiarity with utility electric and gas business, and familiarity with California’s net zero, electrification, decarbonization goals.

SKILLS:

• Experience with data modelling
• working with data/metrics repositories
• experience building data-driven charts & dashboards.