Southern California Edison

Excel Data Analytics Specialist

Southern California Edison
2 Innovation Way, Pomona, CA 91768, USA
Full-TimeDepends on ExperienceMid-LevelBachelors
Job Description

Import and export Planning Progress Reports (PPR) using customized Access database (PoleTracker). Award poles in PoleTracker for design to internal/external design resources. Process deteriorated pole work-orders to the Pole Project Management Group (PPM). Validate data in Poletracker from Planning Progress Report (PPR) to ensure it matches the work order packages received from planning resources. Verify work-order information using Design Manager, SAP, SharePoint, and other database resources. Utilize primary and secondary data sources for tracking, reporting, and performance measurement. Develop and generate reports for performance and scorecard data and develop ad-hoc reporting. Work with internal clients and design contractors to address scope, process, and billing issues.

Where is this job?
This job is located at 2 Innovation Way, Pomona, CA 91768, USA
Job Qualifications

  • 3+ of experience performing Data Analytics functions such as extracting data and analyzing large datasets.

  • Experience with Pole Tracker, Project Tracker, Design Manager (DM) and SAP.

  • Experience providing high level analytics, including statistical analysis and visual analytics to understand areas of improvement.

  • Experience working with construction design work orders.

Required Skills

  • SAS

  • v-lookups

  • Power BI

  • Time Management Skills

  • Pivot tables (formulas)

  • Excel Macros

  • Visual Analytics

  • Sum-Ifs

Soft Skills

  • Verbal communication

  • Driven and self-motivated

  • written communication

  • Adaptability

  • Multi-tasking

  • Detail oriented and highly organized

Compensation

According to JobzMall, the average salary range for a Excel Data Analytics Specialist in 2 Innovation Way, Pomona, CA 91768, USA is $48,000 - $80,000.

Additional Information
Southern California Edison is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based upon race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
Required LanguagesEnglish
Job PostedFebruary 25th, 2021
Apply BeforeJuly 20th, 2025
This job posting is from a verified source. 
Reposted
See an issue with this job? Report it to us

Apply with Video Cover Letter Add a warm greeting to your application and stand out!

Upload
About Southern California Edison

Southern California Edison, the largest subsidiary of Edison International, is the primary electricity supply company for much of Southern California. It provides 15 million people with electricity across a service territory of approximately 50,000 square miles.

Frequently asked questions
More Jobs From Southern California Edison

View All Southern California Edison jobs

Get interviewed today!

JobzMall is the world‘ s largest video talent marketplace.It‘s ultrafast, fun, and human.

Get Started