Operations Data Analyst

Summary:

• Location: Oakland, CA
• Duration: 4 Months
• Work Mode: Hybrid (Up to 3 days per week in office)

Responsibilities:

• Manage standard, routine data analysis projects with limited supervision from initial request to presenting data results ensuring that the project is completed within budget and on-time.
• Work with other Data Management Analysts to process data, analyze data, and report findings.
• Create automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
• Manage standard data extracts and list pulls ensuring accurate data.
• Transfer data from databases to various analysts to support operational analysis efforts.
• Analyze data using various statistical tools to develop ad hoc reports, statistics, trends, and profiles.
• Develop and communicate clear, concise, and actionable data analyses for clients.

Requirements:

• BA/BS Degree in Marketing, Business, Computer Science, Engineering, or other related field or equivalent work experience.
• Minimum 2 years of related work experience.

Preferred Skills:

• Power platform skills (Power BI, Power Apps, Power Automate, Dataverse, etc.).
• Experience with dashboards and reporting, data governance, records management, audit, tracker accuracy, trend analysis, root cause analysis, folder structures, data logging taxonomy, audit-ready documentation, and logging automation.
• Problem solving, critical thinking, nimble, tenacious, curious, and ability to navigate through ambiguity.
• Familiarity with utility operations.
• Skilled in Microsoft Excel/Access (complex formulas, graphing, VBA).
• Skilled writing SQL queries using Oracle or Business Objects.
• Skilled developing dashboards (Power BI).
• Skilled developing and reporting metrics and KPIs.
• Experience in UNIX shell programming (csh, awk, sed, vi).
• Knowledge of base-SAS and programming languages such as Visual Basic, Perl, C.
• Able to analyze and interpret data and effectively communicate findings.