Business Analyst

Job Description:
Day-to-Day Responsibilities/Workload:
Responsible for supporting scoping and planning for internal and external inspection teams supporting multiple Distribution and Transmission programs, including detailed inspections in high-fire and non-high-fire areas, annual grid patrols, streetlight patrol surveys, infrared scanning, and intrusive pole evaluations.
Key program management, planning, and scheduling responsibilities include:
• Managing schedules for data collection and processing, contractor deliverables, quality assurance, risk assessment, and final delivery of inspection results.
• Leading meetings across all phases of the inspection process, from data collection through risk review and distribution.
• Developing, maintaining, and distributing progress reports covering inspection collection, processing, delivery, quality control, and risk evaluation.
• Coordinating communications and managing impacts among contractors and internal SCE stakeholders involved in inspections, data processing, and overall program support.
• Managing the inspection program's financial planning and execution.

Key Data Analysis responsibilities include:
• Performance monitoring and tracking to ensure completion of various scopes on a regular basis.
• Responsible for running regular weekly/daily reports, ad hoc reports internally and externally as well as any special analysis needed to resolve issues/process improvements, reports related to finance/cost analysis, supporting any issues that arise from contractors or internally such as data discrepancies.
• Identify data discrepancies through SAP, InspectApp, EZYViewer research using systems like SAS Enterprise, SAS VA, SAP, PowerBi, Python, WiSDM, Snowflake to:
o Report on historical performance (by structure, region, resource, etc.)
o Find sync issues
o Understand trends in survey results (by inspector, resource, type of inspection)
• Validate that inspections are populating in dashboards (SAS, Power BI) and follow through to resolution.
• Communicate with InspectApp/InspectForce team both internal to Inspections and IT regarding sync issues and tracking resolution.
Required Skills/Attributes:
Knowledge & Skills
• data management (data structure and controls design, data querying, and report development)
• time management (manage resolution of work to align with workflow due dates and inspection due dates)
• comfortable engaging multiple SMEs across multiple organizations, presenting issues and potential solutions, and securing support and/or buy-in from stakeholders and support partners
• project tracking from issue ID, causal analysis, solutioning, through resolution of issue
• data visualization reporting and dashboard development
Software Proficiency:
• MS Office Suite, SAS, SAP, PowerBI, SQL, Python, Snowflake
• SAP experience navigating work orders, maintenance plans, mdocs, FLOC/Equipment data)
• ArcGIS – experience Joining different visual layers/maps (districts, FLOCs, circuits, hexbins, constrained areas) to create tables of data to work with more effectively.