Data Analyst III
Progressive · San Diego, CA · 2 wk ago
AnalystFull-time
Responsibilities
- Lead complex electric distribution, Network Management System (NMS), Oracle Utilities Analytics (OUA), and Customer Success data requests by understanding source data relationships, building, and refining SQL queries, validating results, and translating findings into actionable recommendations.
- Own recurring outage data audits to identify gaps, trends, and opportunities to improve customer outage notifications, internal processes, data quality, and supporting technology.
- Design and build reports, dashboards, and data views using outage, customer, operational, and other relevant data sources to support leadership decisions and operational performance monitoring.
- Support development of internal and external outage trackers, including integration with cloud-hosted components or AWS-based environments where applicable.
- Analyze Customer Success, customer outage notification, and external outage map data to identify opportunities to improve customer experience, including developing options and recommendations related to crew status information and other customer-facing outage map enhancements.
Requirements
- 5 or more years of progressive experience in data analytics, business systems analysis, database development, BI/reporting, software development, or application/data support roles, preferably supporting complex operational systems.
- Senior-level experience developing reports, dashboards, data extracts, or analytics using SQL, Oracle tools, Power BI, or similar platforms, with strong working knowledge of SQL, relational data models, and Oracle Database concepts.
Skills
- Power BI
- Business Systems Analysis
- SQL
- Oracle tools
- PL/SQL
- XML
- Power Query
- DAX
- Microsoft Fabric
- AWS
Experience with PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, cloud data warehousing, or AWS-based data environments preferred.