Data Analyst III

Progressive / SThree Group; San Diego (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Progressive / SThree Group seeks a senior data analytics professional to lead complex electric distribution and outage data requests, building and refining SQL queries and validating results to translate findings into actionable recommendations.

You will own outage data audits, design dashboards, and support outage trackers with cloud-hosted or AWS-based environments, driving leadership decisions and operational performance monitoring to improve customer experience.

Qualifications

• 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.
• Experience with PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, cloud data warehousing, or AWS-based data environments preferred.

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.

Skills

Data analytics

Business systems analysis

Database development

BI/reporting

Software development

Data support

Tools

SQL

Oracle

Power BI

PL/SQL

XML

Power Query

DAX

Microsoft Fabric

AWS data services

Job description

Key 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.

Minimum Qualifications:

• 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.
• Experience with PL/SQL, XML, Power Query, Power BI data modeling, DAX, Microsoft Fabric, cloud data warehousing, or AWS-based data environments preferred.

EOE Statement: Specialist Staffing Group is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.