ED - Business Analyst 3 - First Tek, Inc.
Pomona, CA 91768
About the Job
Roles and 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 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 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 scope, including Commissioning, GO165 Compliance Sweep, and yearly scope.
- work closely with internal invoicing resource to ensure validation occurs seamlessly
- ensure 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 accuracy of scope
- Conduct analysis 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, Client)
- 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), priority (due date) in Excel
- Assign Block IDs
- Share scope files with vendors via email and SharePoint
Update source sheets and ensure the dashboard have 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, 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 weekly/daily basis
--? scopes such a
Qualifications and Education Requirements:
High School Diploma or Equivalent
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
SAP SME
- 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 at SCE, 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
Must have a valid driver's license and current state required minimum vehicle insurance coverage to drive onto Client and Company property.
Preferred Skills:
Ability to breakdown complex details and dynamics into easy to read, executive level summaries or visuals. Ability to handle working with very different personalities and skillsets given this cross functional project requires business, technical, regulatory, and financial knowledge and acumen.
Pay Range:
The pay range for this position is $30.00-$39.00 per hour; however, the pay offered may vary depending on job-related knowledge, skills, and experience. This pay information is being provided pursuant to applicable law and is based in part on market location.
Benefits:
The benefits available with this position include:
Cenergy is a dynamic, diverse, woman-owned company that has provided stellar support to our clients globally for over 25 years! We hire extraordinary people, and each of our team members are encouraged to embody our core values to drive innovation and own it with integrity and trust while adding to our positive and forward-thinking atmosphere.
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 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 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 scope, including Commissioning, GO165 Compliance Sweep, and yearly scope.
- work closely with internal invoicing resource to ensure validation occurs seamlessly
- ensure 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 accuracy of scope
- Conduct analysis 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, Client)
- 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), priority (due date) in Excel
- Assign Block IDs
- Share scope files with vendors via email and SharePoint
Update source sheets and ensure the dashboard have 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, 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 weekly/daily basis
--? scopes such a
Qualifications and Education Requirements:
High School Diploma or Equivalent
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
SAP SME
- 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 at SCE, 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
Must have a valid driver's license and current state required minimum vehicle insurance coverage to drive onto Client and Company property.
Preferred Skills:
Ability to breakdown complex details and dynamics into easy to read, executive level summaries or visuals. Ability to handle working with very different personalities and skillsets given this cross functional project requires business, technical, regulatory, and financial knowledge and acumen.
Pay Range:
The pay range for this position is $30.00-$39.00 per hour; however, the pay offered may vary depending on job-related knowledge, skills, and experience. This pay information is being provided pursuant to applicable law and is based in part on market location.
Benefits:
The benefits available with this position include:
- Ongoing Training (RSO, Systems, Software Programs, OSHA Safety, JJ Keller, etc.)
- Continuous Employment Development and Learning
- Ongoing Advocacy, internal assets with HSE, Legal and HR teams and experts to aid in Employee Career Path and Advancement
- 401K
- Healthcare & Healthcare Group Medical Coverage
- Dental Insurance Coverage
- Vision Insurance Coverage
- Basic Life Insurance & AD&D
- Long Term Disability
- Voluntary Short-Term Disability
- Access to Health Joy
- GAP Medical Coverage
- Direct Deposit
- Health Savings and Flexible Spending Accounts
Cenergy is a dynamic, diverse, woman-owned company that has provided stellar support to our clients globally for over 25 years! We hire extraordinary people, and each of our team members are encouraged to embody our core values to drive innovation and own it with integrity and trust while adding to our positive and forward-thinking atmosphere.
Source : First Tek, Inc.