Operational Data Analyst
Sacramento/ Oakland, CA (Hybrid - 2-3 days onsite per week)
3 Months(HOPEFUL they can extend to next year pending budget approvals)
**Local Candidates only**
Equipment: Client laptop will be provided. If there is a backlog, vendor to provide a laptop or utilize a personal device with Citrix until the laptop is available.
Top Things:
- Technical analytics / BI capability - especially Power BI, Power Apps/Power Platform, SQL, data modeling, and related analytical tools.
- Strong analytical judgment and problem-solving - ability to work through complex data, validate analysis, identify risks/issues, and turn findings into actionable insights.
- Communication and business/utility context - ability to translate technical findings for business and leadership audiences; utility, operations, compliance, or risk experience was repeatedly preferred.
Top Things Looking For:
- Dashboards and Reporting
- Data governance
- Records management
- Audit
- Tracker accuracy
- Trend analysis
- Root cause analysis
- Folder structures
- Data logging taxonomy
- Audit-ready documentation
- Logging automation
Top skill sets looking for in a candidate:
- Problem solving, Critical thinking, Nimble, Tenacious, Curious, Ability to Navigate thru Ambiguity
- 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.
- Creates automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
- Manages standard data extracts and list pulls ensuring accurate data. Transfers the data from databases to various analysts to support operational analysis efforts.
- Demonstrates full understanding of data processing and analysis techniques.
- Analyzes data using various statistical tools to develop ad hoc reports, statistics, trends and profiles.
- Develops and communicates clear, concise and actionable data analyses for clients.
Education Minimum:
- BA/BS Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience
Minimum Experience:
- 2 years of related work experience
Knowledge, Skills, and Abilities (Desired)
- 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 (PowerBi)
- Skilled developing and reporting metrics and KPIs
- Experience in UNIX shell programming (csh, awk, sed, vi).
- Knowledge of base-SAS and programming language such as Visual Basic, Perl, C
- Able to analyze and interpret data and effectively communicate findings.
|