Business Analyst
Job Location Pomona, CA
Hybrid 2 day(s) onsite
Contract
Day-to-Day Responsibilities
Stakeholder Engagement & Customer Contact
Act as the main point of contact between Contractors and customers, facilitating communication, resolving access issues, and coordinating inspection appointments.
Document and manage customer access challenges, handle notifications and permissions, and ensure all necessary approvals and communications are properly collected and tracked.
Utilize SCE's Customer Contact Information (CCI) to proactively schedule inspections, reducing unnecessary field visits and increasing operational efficiency.
Maintain and prioritize records of inspection constraints, support process improvements for access management, and track performance using relevant reporting tools.
Constraint Tracking and Exception Processing
Mapping - Create .kmz and spatial joins in Excel to determine potential access issues related to CROPS, Government Lands, etc.
Create work orders for released access issues and send them to vendors with notes regarding appointments, gate codes, special instructions, contact info, etc.
Tracking and oversight of constrained inspections to actively mitigate the potential for non-compliant inspections and not meeting risk mitigation commitment.
Assist in development and monitoring of data management tools to provide more timely and accurate status reporting to management.
Identify follow-up actions required by various stakeholders in the inspection workflow.
An additional resource can take advantage of the data management tools and process improvements being developed, to provide more timely and accurate status reporting to management and to identify follow-up actions required by various stakeholders in the inspection workflow.
Data Analysis and Data Discrepancies
Validate that inspections are populating in dashboards (SAS, Power BI) and follow through to resolution.
Identify data discrepancies through SAP, InspectApp, EZYViewer research.
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 (Excel), SAS, SAP, PowerBI, SQL, Python, SAP SME
- Help individuals frequently in navigating work orders, maintenance plans, mdocs, FLOC/Equipment data).
- Has prior experience with SAP transformations, especially as it pertains to data cleansing and validation. With S/4HANA transformation at SCE, this could be valuable.
ArcGIS- Join different visual layers/maps (districts, FLOCs, circuits, constrained areas) to create tables of data to work with more effectively.