LeadStack Inc. is an award-winning, one of the nation’s fastest-growing, certified minority-owned (MBE) staffing services provider of contingent workforce. As a recognized industry leader in contingent workforce solutions and Certified as a Great Place to Work, we’re proud to partner with some of the most admired Fortune 500 brands in the world.
Title: Data Analyst
Location: Hybrid in Pomona 91768 - Onsite Mon & Tue
Duration: 1 Year Contract with Possible extension
Pay range: $35.00 - $37.90/hr on W2
Education Requirement
High School Diploma or Equivalent
Day-to-Day Responsibilities/Workload
Responsible for supporting scoping and planning for internal and external inspection teams supporting multiple Distribution and Transmission programs, including detailed inspections in high-fire and non-high-fire areas, annual grid patrols, streetlight patrol surveys, infrared scanning, and intrusive pole evaluations.
Key program management, planning, and scheduling responsibilities include:
Managing schedules for data collection and processing, contractor deliverables, quality assurance, risk assessment, and final delivery of inspection results.
Leading meetings across all phases of the inspection process, from data collection through risk review and distribution.
Developing, maintaining, and distributing progress reports covering inspection collection, processing, delivery, quality control, and risk evaluation.
Coordinating communications and managing impacts among contractors and internal SCE stakeholders involved in inspections, data processing, and overall program support.
Managing the inspection program’s financial planning and execution.
Key Scoping & Planning responsibilities include:
Scope Refreshes - Create scope packages/work orders taking all the necessary steps to ensure accuracy of scope ensuring all appropriate guidelines are met.
Collaborate with SP&E and Inspections to improve scoping strategy (e.g., work order bundling, minimizing visits, 1-2-skip a few, etc.)
Maintain and refine lessons learned and change control logs for planning/scoping process.
Communicate and meet with stakeholders periodically to ensure feedback obtained and reviewed against existing/future planning efforts (i.e. pain point tracker).
Preparation of weekly performance report, UTC Tracker, Customer Access Tracker, CROPS & Government Lands Tracker, etc.
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.
o Drive down 'double dip' inspection charges for access issues.
o Assist in development and monitoring of data management tools to provide more timely and accurate status reporting to management.
o 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.
Key Data Analysis responsibilities include:
Performance monitoring and tracking to ensure completion of various scopes on a regular basis.
Responsible for running regular weekly/daily reports, ad hoc reports internally and externally as well as any special analysis needed to resolve issues/process improvements, reports related to finance/cost analysis, supporting any issues that arise from contractors or internally such as data discrepancies.
Identify data discrepancies through SAP, InspectApp, EZYViewer research using systems like SAS Enterprise, SAS VA, SAP, PowerBi, Python, WiSDM, Snowflake to:
o Report on historical performance (by structure, region, resource, etc.)
o Find sync issues
o Understand trends in survey results (by inspector, resource, type of inspection)
Validate that inspections are populating in dashboards (SAS, Power BI) and follow through to resolution.
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, SAS, SAP, PowerBI, SQL, Python, Snowflake
SAP experience navigating work orders, maintenance plans, mdocs, FLOC/Equipment data)
ArcGIS – experience Joining different visual layers/maps (districts, FLOCs, circuits, hexbins, constrained areas) to create tables of data to work with more effectively
Numbers & Facts
Location
Services - See below for details, CA
Salary
$35–$37.90 Per Hour
Skills
Agricultural Cropsunmatched
Analysis Skillsunmatched
ArcGISunmatched
Calendar Managementunmatched
Change Controlunmatched
Cost Analysisunmatched
Data Analysisunmatched
Data Collectionunmatched
Data Managementunmatched
Data Processingunmatched
Data Structuresunmatched
Data Visualizationunmatched
Financial Analysisunmatched
Financial Planningunmatched
Financial Reportingunmatched
Follow Throughunmatched
Fortune 500 Customersunmatched
Governmentunmatched
IR (Infrared)unmatched
Identify Issuesunmatched
Microsoft Access Databaseunmatched
Microsoft Excelunmatched
Microsoft Officeunmatched
Order Processingunmatched
Performance Analysisunmatched
Power BIunmatched
Problem Solving Skillsunmatched
Process Improvementunmatched
Program Planningunmatched
Progress Reportsunmatched
Project Trackingunmatched
Project/Program Managementunmatched
Python Programming/Scripting Languageunmatched
Quality Assuranceunmatched
Quality Controlunmatched
Reporting Dashboardsunmatched
Riskunmatched
Risk Analysisunmatched
Risk Managementunmatched
SAPunmatched
SQL (Structured Query Language)unmatched
Schedule Developmentunmatched
Statistical Analysis System (SAS)unmatched
Time Managementunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.