Business Analyst (SAP, Excel)

Hybrid in Pomona, CA, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Hybrid
$16 - $38/hr
Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

  • Business Analyst
  • Excel
  • PowerBI
  • SQL
  • Python
  • SAP SME
  • Data visualization
  • reporting
  • dashboard development
  • project tracking
  • Data management
  • data structure
  • controls design
  • data querying
  • report development
  • time management

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90655605
  • Position Id: 8925100
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Glendale, California

Today

Easy Apply

Contract

USD 73.00 - 80.00 per hour

Torrance, California

Today

Easy Apply

Contract

USD 60.00 - 65.00 per hour

Los Angeles, California

Today

Easy Apply

Contract

$25.00 - $35.00 per hour

Remote

3d ago

Easy Apply

Contract

60 - 65

Search all similar jobs