Business Data Analyst - Utility Operations

Job Description

Business Data Analyst - Utility Operations

\n

Location: Pomona, California

\n

Work Model: Hybrid - Onsite Monday & Tuesday

\n

Schedule: Monday-Friday, 8:00 AM-5:00 PM

\n

Contract: 12 months

\n

Pay Rate: $38.60/hour

\n

\n

We are seeking an experienced Business Data Analyst to support the planning, execution, reporting and analysis of electric utility inspection programs.

\n

\n

This position supports multiple Distribution and Transmission programs, including detailed asset inspections, annual grid patrols, streetlight patrol surveys, infrared scanning and intrusive pole evaluations.

\n

\n

The Business Data Analyst will work across program management, inspection planning, data analysis and exception processing, partnering with contractors and internal stakeholders to ensure inspection scopes are accurately planned, tracked and completed.

\n

\n

Key Responsibilities

\n

\n
• Support planning and scheduling for internal and external inspection teams across multiple electric utility programs.
\n
• Manage schedules covering data collection, processing, contractor deliverables, quality assurance, risk assessment and delivery of inspection results.
\n
• Develop, maintain and distribute progress and performance reports.
\n
• Lead and participate in meetings throughout the inspection lifecycle, from initial data collection through risk review and final distribution.
\n
• Coordinate activities and communications between contractors and internal stakeholders.
\n
• Support financial planning, cost analysis and execution for inspection programs.
\n
• Create accurate scope packages and work orders in accordance with applicable requirements and guidelines.
\n
• Work with inspection and planning teams to improve scoping strategies and operational efficiency.
\n
• Maintain lessons learned, change control logs and planning documentation.
\n
• Track constrained inspections and access issues to mitigate compliance and scheduling risks.
\n
• Identify required follow-up actions and coordinate resolution across stakeholders.
\n

\n

\n

Data Analysis & Reporting

\n

\n
• Produce regular daily and weekly performance reports, dashboards and ad hoc analyses.
\n
• Monitor inspection performance and completion against established scopes and deadlines.
\n
• Analyze financial and cost data and investigate discrepancies identified internally or by contractors.
\n
• Research data discrepancies across SAP, inspection applications and reporting platforms.
\n
• Analyze historical performance by structure, region, resource and inspection type.
\n
• Identify synchronization and data-quality issues and coordinate resolution with business and IT teams.
\n
• Analyze trends in inspection and survey results.
\n
• Validate that inspection data is accurately populating reporting dashboards.
\n
• Develop and improve data-management tools that provide timely and accurate status reporting.
\n
• Use mapping and spatial data to identify potential access constraints and support inspection planning.
\n
• Create and analyze KMZ files and spatial joins for locations including government lands and other constrained areas.
\n

\n

\n

Required Qualifications

\n

\n
• Bachelor's degree in Business, Finance, Accounting, Statistics or a related field, or an equivalent combination of education, training and experience.
\n
• Approximately 5-7 years of analytical experience.
\n
• Demonstrated ability to perform moderately complex quantitative and data analysis.
\n
• Experience gathering, documenting and analyzing information and translating findings into actionable conclusions.
\n
• Strong data-management skills, including data querying, reporting and data controls.
\n
• Experience developing dashboards and data visualizations.
\n
• Strong project and issue-tracking capabilities, from identification and root-cause analysis through resolution.
\n
• Ability to manage multiple priorities and deadlines.
\n
• Strong communication skills with the ability to work across multiple teams, subject matter experts, contractors and stakeholders.
\n

\n

\n

Technical Skills

\n

Experience with several of the following is preferred:

\n

\n
• SAP
\n
• Power BI
\n
• SQL
\n
• SAS / SAS Visual Analytics
\n
• Microsoft Excel and MS Office
\n
• Python
\n
• Snowflake
\n
• ArcGIS
\n
• Data visualization and dashboard development
\n

\n

\n

Experience navigating SAP work orders, maintenance plans, measurement documents, functional locations (FLOCs) and equipment data is particularly relevant.

\n

\n

ArcGIS experience involving the joining and analysis of mapping layers such as districts, functional locations, circuits and constrained areas is also highly desirable.

\n

Work Environment

\n

\n

This is a hybrid position based in Pomona, California, with onsite attendance required Monday and Tuesday. Candidates should be comfortable working across technical, operational and business teams in a data-intensive utility environment.

\n

\n

Desired Skills and Experience

\n

Data Analysis, Power BI, SAP, SQL, SAS, Microsoft Excel, Data Visualization, Reporting, ArcGIS, Python, Snowflake, Project Management, Data Management, Utility Operations, Work Orders.