Data Analyst W2

Job Title: Operations Data Analyst, Expert Location: Oakland, CA – Hybrid (2-3 days onsite per week) Duration: 6 Months Description Local candidates only. The role is hybrid, requiring 2-3 days onsite each week. The selected hire will receive a company laptop and access to the Oakland General Office campus. Responsibilities • Manage complex data analysis projects from initiation to presentation, ensuring completion within budget and timeline. • Design data analysis processes to meet business objectives; process, analyze, and present findings tailored to specific audiences. • Create automated data routines and processes for accurate reporting and data delivery. • Extract and transfer data from databases to support operational analysis. • Apply broad expertise in data processing and analysis to solve diverse business issues. • Recommend innovative solutions to enhance databases with new sources and improved processes. • Develop comprehensive reports with clear, actionable insights. • Collaborate with directors and managers across functions to influence business decisions. • Analyze business data to identify trends, patterns, and improvement opportunities. • Collect, clean, and integrate data from systems such as SAP, Foundry, GIS, and Copperleaf. • Develop and maintain dashboards and reports using Power BI or Tableau. • Work with cross-functional teams to define challenges and design data-driven solutions. • Monitor KPIs and provide recommendations for operational improvement. • Conduct ad hoc analyses and respond to data requests. • Ensure data quality, integrity, and governance across systems and platforms. Required Education • BA/BS degree in Marketing, Business, Computer Science, Engineering, or related field, or equivalent work experience. Preferred Education • Master’s degree. Minimum Experience • 6+ years of related work experience. Desired Knowledge, Skills, and Abilities • Familiarity with utility operations. • Advanced Microsoft Excel/Access skills (complex formulas, graphing, VBA). • Advanced visualization skills (Power BI, Tableau, etc.). • Advanced SQL query writing using Oracle or Business Objects. • Strong knowledge of Base SAS and programming languages such as Visual Basic, Perl, or C. • Strong organizational, prioritization, and multi-tasking skills. • Strong problem-solving abilities and influence skills. • Advanced project management skills to lead cross-functional teams.