Business Analyst III (Utility Industry)

Trident Consulting is currently seeking a Business Analyst III for one of our industry leading clients.Job Title: Business Analyst III Location: Pomona, CA – Hybrid (2 Days Onsite: Monday & Tuesday) Duration: 12 Months Contract (03/11/2026 – 03/10/2027) Schedule: Monday – Friday, 8:00 AM – 5:00 PM Hours: 40 hours per weekPay: $35-38/hr on W2Position OverviewClient is seeking a Business Analyst III to support the Operations Scoping team within Power Delivery Services. The role focuses on data analysis, stakeholder coordination, inspection workflow management, and operational reporting.The analyst will work closely with internal teams, contractors, and customers to ensure efficient inspection scheduling, access coordination, and accurate operational data reporting. The position also involves data validation, dashboard monitoring, and process improvements to support operational compliance and risk mitigation efforts.This role requires strong analytical, communication, and data management skills, along with experience using SAP, Power BI, SAS, SQL, and GIS tools.Key Responsibilities1. Stakeholder Engagement & Customer CoordinationAct as the primary point of contact between contractors and customers to facilitate communication and resolve access issues.Coordinate inspection appointments and ensure necessary approvals and permissions are obtained.Manage and document customer access challenges, notifications, and communication records.Utilize SCE’s Customer Contact Information (CCI) system to proactively schedule inspections and minimize unnecessary field visits.Maintain organized records related to inspection access constraints and resolution activities.2. Inspection Constraint Tracking & Exception ManagementMonitor and track inspection constraints that may prevent scheduled field inspections.Identify issues related to:Government land accessCROPS restrictionsProperty access limitationsOperational constraintsCreate and manage work orders for access-related issues, including:Vendor instructionsAppointment informationGate codesContact detailsSpecial access instructionsWork with vendors and internal teams to resolve access issues quickly to avoid inspection delays.Track constrained inspections to ensure risk mitigation compliance requirements are met.Support development and enhancement of data management tools that improve operational tracking and reporting.3. Data Analysis & Data Quality ManagementAnalyze operational data and identify data discrepancies or synchronization issues.Validate that inspection data is properly populated and reflected in reporting dashboards such as:SAS dashboardsPower BI dashboardsInvestigate data inconsistencies using:SAPInspectAppEZYViewerWork with internal teams and IT to resolve system synchronization issues.Ensure operational data accuracy to support inspection compliance reporting and management decision-making.4. Reporting, Dashboard Monitoring & Data ManagementMaintain and enhance operational reporting dashboards.Assist in developing data visualization tools for management reporting.Use Excel, SAS, Power BI, SQL, and Python to analyze large datasets and generate insights.Track performance metrics related to:inspection schedulinginspection completionoperational constraintsrisk mitigation compliance5. Mapping & GIS Data AnalysisUse ArcGIS tools to create mapping datasets and spatial analysis reports.Create KMZ files and spatial joins in Excel to identify potential inspection access issues.Combine different GIS layers such as:District boundariesFLOC locationsCircuit mapsConstrained access areasGenerate tables and datasets to improve inspection planning and resource allocation.6. Project Support & Process ImprovementSupport initiatives focused on improving operational processes and inspection workflows.Identify opportunities for process optimization and automation.Track project activities from:Issue identificationRoot cause analysisSolution developmentImplementation and resolutionCollaborate with stakeholders to implement best practices for operational efficiency.Required QualificationsEducationBachelor’s Degree in:BusinessFinanceAccountingStatisticsData AnalyticsInformation Systemsor related fieldEquivalent combination of education and experience may be considered.Experience5–7 years of experience in business analysis, data analysis, or operations analysisExperience working with large datasets and reporting toolsExperience coordinating cross-functional projects or operational initiativesRequired SkillsData & AnalyticsData management and data governanceData structure design and controlsData querying and reportingDashboard development and reporting analysisTechnical ToolsProficiency in:Microsoft Excel (advanced)SAPPower BISASSQLPythonSAP ExperienceExperience navigating SAP systemsAbility to work with:Work OrdersMaintenance PlansMaterial documentsFunctional Locations (FLOC)Equipment dataExperience with SAP data validation and data cleansingExposure to SAP S/4HANA transformation projects is a plusGIS / Mapping ToolsExperience using ArcGISAbility to perform spatial joins and mapping analysis