Troops to Energy Jobs

Job Information

Southern California Edison Excel Data Analytics Specialist in Pomona, California

Job Description

Join the Clean Energy Revolution

Become a Data Analytics Specialist at Southern California Edison (SCE) and build a better tomorrow. In this job, you’ll work in the Technical Planning Design Contractor Hub within SCE’s Transmission and Distribution (T&D) Business Unit. This person will support process improvement projects and oversee the design and maintenance of organization reporting tools, scorecards, and metrics. As a Data Analytics Specialist , your work will help power our planet, reduce carbon emissions and create cleaner air for everyone. Are you ready to take on the challenge to help us build the future?

A day in the life - Get ready to think big, work smart and shine bright!

  • 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.

  • Use of SAS/Power BI Visual Analytics for data extraction and reporting.

Qualifications

The Essentials

  • Three years or more of experience performing Data Analytics functions such as extracting data and analyzing large datasets.

  • Two or more years of experience utilizing the advanced functions of Microsoft Excel such as Sum-Ifs, V-Lookups, Index/Match, Pivot Tables, and Macros.

  • One or more years of experience using SAS or Power BI Visual Analytics software.

The Preferred

  • Bachelor's Degree in Business, Information Technology, Business Analytics, or related field.

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

  • Must be highly proficient in Microsoft Word, Access, and PowerPoint.

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

  • Experience working with construction design work orders.

  • Experience giving presentations and using reporting metrics to provide recommendations to leadership.

  • Experience with SAP’s Ariba functionality and invoice/billing processes.

You should know …

  • Visit our Candidate Resource page (https://www.edisoncareers.com/page/show/Candidate-Resources) to get meaningful information related to benefits, perks, resources, testing information, and hiring process, and more!

  • Relocation does not apply to this position.

Testing

  • This position requires testing and applicants who are identified to continue through the selection process will be invited to test via email. Please access our Information Guides (https://www.edison.com/home/careers/guides-for-pre-employment-tests.html) to reference test(s): Edison Individual Contributor Workstyles (Test 8203). Candidates who have previously passed these assessment(s), in some cases, may not need to retest again for this position.

About SCE

The people at SCE don't just keep the lights on. Our mission is so much bigger. We’re fueling the kind of innovation that’s changing an entire industry, and quite possibly the planet. Join us and create a future with cleaner energy, while providing our customers with the safety and reliability they demand. At SCE, you’ll have a chance to grow personally and professionally, making a real impact in Southern California and around the world.

At SCE, we celebrate our differences. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected status.

We are committed to ensuring that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodations at (833) 343-0727.

DirectEmployers