LI
Analyst-Business 3
Leadstack Inc
🇺🇸 United States
On-site
3 days ago
- Excel
- SAP
- SAS
- Power BI
- Python
- Snowflake
- Data Visualization
- MS Office
- SQL
- ArcGIS
3 days ago
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).
Key Exception Processing responsibilities include:
- 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
Analyst-Business 3 · Leadstack Inc