Business Analyst - Data Management

JobDiva, Inc.; Pomona (CA); Hybrid; USD 22,000 - 53,000; Full time

Benefits offered by this job

Medical, Vision, and Dental Insurance

401k Retirement Fund

Job summary

JobDiva, Inc. is seeking a Business Analyst for Data Management in Pomona, CA. The role supports scoping and planning for inspection teams across multiple programs, including high-fire and non-high-fire areas, grid patrols, and pole evaluations.

The analyst will manage data collection, reporting, and stakeholder coordination to ensure timely inspections. The position requires strong data analysis skills with SAP, Power BI, Snowflake, and ArcGIS experience, plus a minimum of 5 years in relevant

Qualifications

• Data management, data structure and controls design, data querying and report development.
• Time management to meet due dates and inspection deadlines.
• Ability to engage multiple SMEs and present issues and potential solutions to stakeholders.
• Experience with data visualization reporting and dashboards.
• Data analytics using MS Excel, Power BI or SAS, and Snowflake.

Responsibilities

• Managing schedules for data collection, processing, deliverables, QA, risk assessment, and final inspection results.
• Leading meetings across all phases of the inspection process.
• Developing and distributing progress reports on collection, processing, delivery, QA and risk evaluation.
• Coordinating communications among contractors and internal stakeholders involved in inspections and data processing.
• Managing the inspection program's financial planning and execution.

Skills

Data management

Time management

Stakeholder engagement

Issue tracking

Data analytics

Project management

Communication skills

Education

High School Diploma or Equivalent

Tools

MS Office Suite

SAS

SAP

Power BI

SQL

Python

Snowflake

ArcGIS

Job description

Business Analyst - Data Management

Alternate/Related Job Titles

• GIS Analyst
• Project Planner/Analyst
• Project Scheduler/Analyst

Location

Pomona, CA

Onsite Flexibility

Hybrid — Onsite Mondays and Tuesdays

Contract Details

• Position Type: Contract
• Contract Duration: 12 months
• Pay Rate: $16.00–$38.60 / Hour (USD)
• Shift / Schedule: Days (First Shift)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

This role is 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 Responsibilities

Program Management, Planning & Scheduling

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

Scoping & Planning

• Scope Refreshes — Create scope packages/work orders, taking all the necessary steps to ensure accuracy of scope and 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 is obtained and reviewed against existing/future planning efforts (i.e., pain point tracker).

Exception Processing

• 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.
• Track and oversee constrained inspections to actively mitigate the potential for non-compliant inspections and not meeting risk mitigation commitments.
• Drive down 'double dip' inspection charges for access issues.
• 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

• Performance monitoring and tracking to ensure completion of various scopes regularly.
• 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, Power BI, Python, WiSDM, Snowflake to:

- Report on historical performance (by structure, region, resource, etc.) - Find sync issues - 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

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 issueData visualization reporting and dashboard development
• Data analytics: MS Excel, Power BI or SAS, and Snowflake
• Project management
• Strong communication skills (verbal and written)

Software Proficiency

• MS Office Suite, SAS, SAP, Power BI, 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

Required Experience

• Minimum 5 years of relevant experience
• Intermediate-level experience in Snowflake and ArcGIS
• Utility industry experience is required

Nice-to-Have Experience

• SAP experience is a huge plus

Education Requirements

• High School Diploma or Equivalent

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About the Client

This client is a leading investor-owned electric utility in the United States, delivering power across a 50,000 square-mile service territory in Central, Coastal, and Southern California and serving approximately 15 million people — making it one of the largest utilities in the country. For nearly 140 years, the organization has powered one of the world's most dynamic regions and is now actively leading California's transformation to a net-zero economy through major investments in grid modernization, energy storage, transportation electrification, and distributed energy resources. The organization employs engineers, project managers, data scientists, and operations professionals who are building the infrastructure that will define how energy is generated, distributed, and consumed for decades to come, supported by a culture of safety, mentorship, and professional development where the average employee tenure is approximately 20 years.

Job Number:

26-15074 Industry: Data & Analytics

#LI-Hybrid #gttic