Data Management Business Analyst

2 weeks ago

Pomona, United States APR Consulting Full time

An electric utility client is looking for a Data Management Business Analyst who will support the inspection ORG, related to planning and scheduling.


Location: Pomona, CA 91768 (HYBRID)

Position: Data Management Business Analyst

Pay Rate: $38.60+/hr. on W2 (depending on experience)

Duration: 8 months or longer

Schedule: M-F, 8-5

***Hybrid, Mondays and Tuesdays are In-Office days. 1 Innovation Way, Pomona, CA***


RESPONSIBILITIES:

Exception Processing

  • 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.
  • Drive down 'double dip' inspection charges for access issues.
  • Assist in the 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.
  • Contacting customers to arrange appointments for inspections and track to ensure completion.


Requisitions

  • Create requisitions in Ariba for all scopes, including Commissioning, GO165 Compliance Sweep, and yearly scope.
  • Work closely with internal invoicing resources to ensure validation occurs seamlessly
  • Ensure the accuracy of PREQs and will work closely with procurement and vendors for any issues that may arise.


Planning & Scheduling - Scope Releases

  • Create work orders taking all the necessary steps to ensure the accuracy of the scope
  • Analyze to ensure inspections have not been released yet
  • Gather planned scope and organize data (by resource, location, the timing of inspection, etc.) into script
  • Rename work orders based on bucket (Commissioning, GO165 Sweep, 2x Per Year, AOC)
  • Run script through SAP to create draft work orders
  • If errors occur, clean data (remove inactive FLOCs, repair structure data, rearrange structures to build larger WO)
  • Rerun script to recheck errors
  • Run script to create actual work orders
  • Organize work orders by resource and submit IT tickets to move work orders to appropriate inspection groups in ClickSchedule
  • Validate with resources that all work orders have been loaded into their ClickSchedule hierarchies


Scope Packages

  • Organize scope by vendor, type (360 vs ground), bucket (Follow-Up, GO165 Sweep, Commissioning, etc.), and priority (due date) in Excel
  • Assign Block IDs
  • Share scope files with vendors via email and SharePoint
  • Update source sheets and ensure the dashboard has been updated appropriately
  • If not, troubleshoot with Data Science or PADI


Planning & Scheduling - Scope Removals

  • Remove scope from vendors as needed
  • Remove FLOCs from work orders
  • Update source sheets so dashboards reflect changes


AdHoc Reporting / Data Analysis

  • Support Planning & Scheduling Advisor/Analyst to run both regular weekly/daily reports, ad hoc reports internally and externally as well as any special analysis needed to resolve issues/process improvements such as 1, 2, skip a few, reports related to finance/cost analysis, supporting any issues that arise from vendors or internally such as data discrepancies.
  • Identify data discrepancies through SAP, InspectApp, EZYViewer research
  • Using systems like SAS Enterprise, SAS VA, SAP, PowerBi, Python, and WiSDM 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 inspections are populating in dashboards (SAS, Power BI)
  • If not, contact Data Science and PADI and follow through to resolution.
  • Communicate with InspectApp/InspectForce team both internal to Inspections and IT regarding sync issues and tracking resolution


Performance Tracking

  • Track the completion of various scopes on a weekly/daily basis


QUALIFICATIONS:

  • 3-5 years of related experience.
  • Top 5 required skills set: Software proficiency
  • - MS Office Suite, SAS, SAP, PowerBI, SQL, Python
  • 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, and solutions, through the resolution of the issue
  • Data visualization reporting and dashboard development
  • Software proficiency
  • Help individuals frequently in navigating work orders, maintenance plans, mdocs, FLOC/Equipment data)
  • Has prior experience with SAP transformations, especially as it pertains to data cleansing and validation. With S/4HANA transformation, this could be valuable. ArcGIS
  • Join different visual layers/maps (districts, FLOCs, circuits, hexbins, constrained areas) to create tables of data to work with more effectively


About our client:

Our client is one of the largest electric utilities and a longtime leader in renewable energy and energy efficiency in the United States providing electricity for much of Southern California.


About APR:

Since 1980 APR Consulting, Inc. has provided professional recruiting and contingent workforce solutions to a diverse mix of clients, industries, and skill sets nationwide.


Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.


We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.


Don't miss out on this amazing opportunity If you feel your experience is the match for this position please apply today and join our team. We look forward to working with you

  • Business Data Analyst

    2 weeks ago

    Pomona, California, United States LeadStack Inc. Full time

    Job Title: Business Data AnalystLeadStack Inc. is a leading provider of contingent workforce solutions, partnering with top Fortune 500 brands. As a Business Data Analyst, you will play a key role in driving business insights and decision-making.Key Responsibilities:Utilize SAP and SharePoint to gather work order documentation and validate accuracyMonitor...

  • Business Systems Analyst

    2 weeks ago

    Pomona, California, United States AllSTEM Connections Full time

    AllSTEM Connections is seeking a skilled Business Analyst to join our team in Pomona, CA.Job Summary:We are looking for a detail-oriented and organized Business Analyst to support our operations team. The ideal candidate will have experience with SAP and SharePoint, as well as proficiency in Microsoft Suite and Adobe.Key Responsibilities:Validate and enter...

  • Business Systems Analyst

    2 weeks ago

    Pomona, California, United States Cynet Systems Full time

    Job SummaryWe are seeking a highly skilled Business Analyst to join our team at Cynet Systems. As a Business Analyst, you will be responsible for utilizing SAP and SharePoint to gather work order documentation and validate its accuracy.Key Responsibilities:Utilize SAP and SharePoint to gather and validate work order documentation.Monitor shared inboxes and...

  • SAP Business Analyst

    1 week ago

    Pomona, California, United States APR Consulting Full time

    SAP Business Analyst Job DescriptionWe are seeking a highly skilled SAP Business Analyst to join our team at APR Consulting, Inc. The ideal candidate will have a strong background in SAP and experience working with electric utility clients.Key Responsibilities:Perform work order data analysis and update databasesManage email inboxes and update and track...

  • Business Analyst

    2 weeks ago

    Pomona, United States AllSTEM Connections Full time

    AllSTEM Connections is looking for a Business Analyst in Pomona, CA. This is a HYBRID 14-month contract with possible extension.Schedule: M-FOnsite Wednesday's and Thursday'sQualifications: Bachelor's DegreeSAPProficient in Microsoft Suite and AdobeReview, validate and enter dataManipulate documents between applications.Responsibilities:Utilizing SAP and...

  • Business Analyst

    2 weeks ago

    Pomona, United States AllSTEM Connections Full time

    AllSTEM Connections is looking for a Business Analyst in Pomona, CA. This is a HYBRID 14-month contract with possible extension.Schedule: M-FOnsite Wednesday's and Thursday'sQualifications: Bachelor's DegreeSAPProficient in Microsoft Suite and AdobeReview, validate and enter dataManipulate documents between applications.Responsibilities:Utilizing SAP and...

  • SAP Business Analyst

    2 weeks ago

    Pomona, United States APR Consulting Full time

    An electric utility client is looking for a Business Analyst who will be utilizing SAP and SharePoint to gather work order documentation from document libraries and save it to specified locations.Location: Pomona, CA 91768 (Hybrid)Position: Business AnalystPay Rate: $35.40/hr. on W2Duration: 17 months or longerSchedule: M-F 7-3:30 (open to flexing ±...

  • Data Analyst

    3 weeks ago

    Pomona, California, United States KB Home Full time

    About KB HomeKB Home is a leading homebuilder in the United States, with a rich history spanning over 65 years. With operations in 47 markets across the country, we are committed to building strong relationships with our customers and employees. Our team is driven by a shared culture of customer obsession, guided by our focus on sustainability and providing...

  • Data Analyst

    2 weeks ago

    Pomona, United States Rose International Full time

    Description:Education RequirementHigh School Diploma or EquivalentKnowledge & SkillsData 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,...

  • Business Systems Analyst

    2 weeks ago

    Pomona, California, United States AllSTEM Connections Full time

    AllSTEM Connections is seeking a skilled Business Analyst to join their team in Pomona, CA. This is a 14-month contract with possible extension, offering a hybrid schedule with onsite requirements.Key Responsibilities:Utilize SAP and SharePoint to gather work order documentation and ensure accuracy.Monitor shared inboxes and respond to emails, forwarding to...

  • Power BI Data Analyst/Document Control Specialist

    2 weeks ago

    Pomona, California, United States ASK Consulting Full time

    Job OverviewASK Consulting is seeking a highly skilled Power BI Data Analyst/Document Control Analyst to join our team. As a key member of our team, you will be responsible for utilizing SAP and SharePoint to gather work order documentation, validating documentation for accuracy, and performing PowerBi Dashboard Refreshes.Key Responsibilities:Utilize SAP and...

  • Business Analyst 2

    2 weeks ago

    Pomona, United States Rose International Full time

    Description:Bachelor''s degree in Business, Finance, Accounting, Statistics or related field or an equivalent combination of education, training and experience. The candidate must possess the demonstrated ability to perform moderately complex quantitative analysis with the ability to gather, document, analyze and draw conclusions on data and...

  • Senior Management Analyst

    4 weeks ago

    Pomona, California, United States Metrolink Full time

    Job SummaryWe are seeking a highly skilled Senior Management Analyst to join our team at Metrolink. As a key member of our project controls team, you will be responsible for implementing tools and systems to effectively manage and report on construction and engineering capital and state of good repair projects.Key ResponsibilitiesDevelop and implement...

  • Human Resources Business Partner

    3 weeks ago

    Pomona, California, United States Akash Management Full time

    Job Title: Human Resources Business PartnerAkash Management, LLC is a leading multi-brand restaurant company seeking a highly skilled Human Resources Business Partner to join our team.Job SummaryThe HR Business Partner will provide day-to-day support across all levels of the organization, implementing HR strategies that align with our company goals. This...

  • Mold/Asbestos Analyst

    2 weeks ago

    Pomona, California, United States Eurofins USA Environment Testing Full time

    Job Title: Mold/Asbestos AnalystWe are seeking a highly skilled Mold/Asbestos Analyst to join our team at Eurofins USA Environment Testing. As a key member of our laboratory team, you will be responsible for performing analysis of bulk samples using PLM for asbestos, and analysis of non-culturable surface and air samples for fungi.Key...

  • Senior Cost Analyst

    4 weeks ago

    Pomona, California, United States PM2CM Full time

    About UsPM2CM, Inc. is a professional services company dedicated to providing exceptional project management, construction management, and project controls services. Our core expertise lies in Project Controls, which includes Scheduling, Cost Controls, Document Management, and Budget tracking.Key ResponsibilitiesProject Budget ManagementWe are seeking a...

  • Human Resources Business Partner

    4 weeks ago

    Pomona, California, United States Akash Management Full time

    Human Resources Business Partner **Job Summary** We are seeking a highly skilled Human Resources Business Partner to join our team at Akash Management, LLC. As a key member of our organization, you will provide comprehensive HR support to ensure the success of our company. **Key Responsibilities** * Manage all employee relations, investigations, and...

  • Behavioral Analyst

    2 weeks ago

    Pomona, California, United States Redwood Family Care Network Full time

    Join Our Team as a Board Certified Behavioral AnalystRedwood Family Care Network is a leading provider of home and community-based services for individuals with intellectual and developmental disabilities. We are seeking a highly skilled Board Certified Behavioral Analyst to join our team in Whittier.About the RoleAs a Board Certified Behavioral Analyst, you...

  • Behavioral Analyst

    1 week ago

    Pomona, California, United States Redwood Family Care Network Full time

    Job Title: Board Certified Behavioral Analyst- WhittierRedwood Family Care Network is seeking a highly skilled Board Certified Behavioral Analyst (BCBA) to join our team in Whittier, CA. As a BCBA, you will be responsible for providing ongoing consultation using principles of Applied Behavior Analysis (ABA) to support individuals with developmental...

  • Board Certified Behavioral Analyst

    2 weeks ago

    Pomona, California, United States Redwood Family Care Network Careers Full time

    Job Title: Board Certified Behavioral Analyst - WhittierRedwood Family Care Network Careers is seeking a highly skilled Board Certified Behavioral Analyst to join our team in Whittier. As a Behavioral Analyst, you will play a crucial role in providing person-centered home and community-based services to individuals with intellectual and developmental...