SAS Business Data Analyst

4 weeks ago

Pomona, United States APR Consulting Full time
SAS Business Data Analyst

  • Location: Pomona, California
  • Type: Contract
  • Job #78260
An electric utility client is looking for a SAS Business Data Analyst who will support the inspection ORG, related to planning and scheduling.

Location: Pomona, CA 91768 (HYBRID)
Position: SAS Business Data 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 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 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), 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
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 solutioning, through resolution of 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

#SLA

  • Business Data Analyst

    1 week ago

    Pomona, United States APR Consulting Full time

    An electric utility client is looking for a Business Data Analyst who will support the inspection ORG, related to planning and scheduling.Location: Pomona, CA 91768 (HYBRID)Position: Business Data AnalystPay Rate: $38.60+/hr. on W2 (depending on experience)Duration: 8 months or longerSchedule: M-F, 8-5***Hybrid, Mondays and Tuesdays are In-Office days. 1...

  • Business Data Analyst

    7 days ago

    Pomona, United States APR Consulting Full time

    An electric utility client is looking for a Business Data Analyst who will support the inspection ORG, related to planning and scheduling.Location: Pomona, CA 91768 (HYBRID)Position: Business Data AnalystPay Rate: $38.60+/hr. on W2 (depending on experience)Duration: 8 months or longerSchedule: M-F, 8-5***Hybrid, Mondays and Tuesdays are In-Office days. 1...

  • Data Management Business Analyst

    2 months 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 AnalystPay Rate: $38.60+/hr. on W2 (depending on experience)Duration: 8 months or longerSchedule: M-F, 8-5***Hybrid, Mondays and Tuesdays are...

  • Business Analyst

    2 weeks ago

    Pomona, United States Russell Tobin Full time

    Russell Tobin + Associates is currently seeking a Business Analyst. This is a 8+ months contract with potential for extension/conversion for successful contractors!Position: Business AnalystLocation: Pomona, CA (M-F 8-5pm, hybrid schedule)Duration: 8+ months, with possible extensionPay rate: $33.00-35.00/hr on w2JOB SUMMARY: Key job responsibilities...

  • Business Analyst

    2 weeks ago

    Pomona, United States Russell Tobin Full time

    Russell Tobin + Associates is currently seeking a Business Analyst. This is a 8+ months contract with potential for extension/conversion for successful contractors!Position: Business AnalystLocation: Pomona, CA (M-F 8-5pm, hybrid schedule)Duration: 8+ months, with possible extensionPay rate: $33.00-35.00/hr on w2JOB SUMMARY: Key job responsibilities...

  • Business Intelligence Analyst

    3 weeks ago

    Pomona, United States Prosum Full time

    Job Summary:The Power BI - Reporting Engineer will play a critical role in leveraging data to drive informed business decisions. This role involves designing, developing, and maintaining interactive dashboards and reports using Power BI and other business intelligence (BI) tools. The Reporting Analyst will gather, clean, and transform data, perform in-depth...

  • Business Analyst

    2 weeks ago

    Pomona, United States Russell Tobin Full time

    Job Title: Business AnalystLocation: Pomona, CA 91768Pay Range: $27/hr-$32/hr on W2 (DOE)Duration: 11 Months plusShift: M-F 7 am-4 pmDescription:Bachelor's degree in Business, Finance, Accounting, Statistics or a related field or an equivalent combination of education, training, and experience.The candidate must possess the demonstrated ability to perform...

  • Business Operations Coordinator

    4 weeks ago

    Pomona, California, United States Cenergy International Full time

    Business Operations CoordinatorSchedule ManagementCreate and manage schedules for various projects, ensuring timely completion and effective resource allocation. Develop and implement process improvements to increase efficiency and accuracy.Collaborate with cross-functional teams to gather requirements and provide solutions.Analyze data to identify trends...

  • SAP Business Analyst

    3 weeks ago

    Pomona, CA, 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 ±...

  • SAP Business Analyst

    3 weeks ago

    Pomona, CA, 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 W2Duration17 months or longerSchedule: M-F 7-3:30 (open to flexing ± 1hr)Hybrid,...

  • Hl7 Interface Analyst

    3 weeks ago

    Pomona, United States Prosum Full time

    Job Summary:We are seeking a highly skilled and experienced Interface Analyst Level 3 with a background in healthcare integration to join our team. This role is crucial in designing, configuring, and supporting information system solutions that enhance organizational efficiency and support our business objectives. You will work closely with business and...

  • Senior Cost Analyst

    4 months ago

    Pomona, United States PM2CM Inc Full time

    About Us: PM2CM, Inc., (Project Management to Construction Management) is a professional services company and certified SBE and DBE, dedicated to providing Program and Project Management, Construction Management and Project Controls services during the design and construction phase of projects. Our core expertise is in Project Controls which includes...

  • Business Intelligence Engineer

    3 weeks ago

    Pomona, CA, United States Prosum Full time

    Job Summary:The Power BI - Reporting Engineer will play a critical role in leveraging data to drive informed business decisions. This role involves designing, developing, and maintaining interactive dashboards and reports using Power BI and other business intelligence (BI) tools. The Reporting Analyst will gather, clean, and transform data, perform in-depth...

  • Power BI/ Reporting Engineer

    3 weeks ago

    Pomona, United States Prosum Full time

    Power BI/Reporting EngineerContract to hire or Direct Hire Comp: $70-75/HR OR $135-145KOnsite 3 days a week, may be required to be onsite more in the beginningMust be vaccinatedHealthcare experience requiredSomeone who has managed a Power BI environment, creating user permissions, data governance and compliance and strong experience with automation would be...

  • Interface Analyst

    3 weeks ago

    Pomona, United States Prosum Full time

    Qualifications: Education: Bachelor’s degree in Computer Science, Information Technology, Healthcare Informatics, or a related field; equivalent experience may be considered. Experience: 5+ years of experience in systems analysis and integration, with at least 3 years in a healthcare setting preferred. Familiarity with healthcare integration standards and...

  • Board Certified Behavioral Analyst- Apple Valley

    3 weeks ago

    Pomona, United States Redwood Family Care Network Full time

    Job DescriptionJob DescriptionChanging Lives Shaping The FutureBoard Certified Behavioral Analyst- Apple Valley - EBSH Home experienced   Job Type: Full-timeLocation: Apple Valley, CA Salary Range: $87,000 - $92,000 annually Redwood Family Care Network is an innovative leader in delivering person-centered home and community-based services to...

  • BCBA - Up to 10k Bonus

    1 week ago

    Pomona, United States ACES Full time

    Job DescriptionJob DescriptionJob DetailsJob Location: West Covina, CASalary Range: UndisclosedDescriptionSalary: $80,000 - $95,000 Attractive Bonus Package: Up to $10,000 in sign-on, retention, relocation bonuses, tailored to your location and our business needs.Join Our Elite Team as a BCBA! Are you ready to make a profound impact on the lives of children...

  • BCBA - Up to 10k Bonus

    2 months ago

    Pomona, United States ACES Full time

    Job DescriptionJob DescriptionJob DetailsJob Location: Pomona, CA, CASalary Range: UndisclosedDescriptionSalary: $80,000 - $95,000 Attractive Bonus Package: Up to $10,000 in sign-on, retention, relocation bonuses, tailored to your location and our business needs.Join Our Elite Team as a BCBA! Are you ready to make a profound impact on the lives of children...

  • Power BI/ Reporting Engineer

    3 weeks ago

    Pomona, CA, United States Prosum Full time

    Power BI/Reporting EngineerContract to hire or Direct Hire Comp: $70-75/HR OR $135-145KOnsite 3 days a week, may be required to be onsite more in the beginningMust be vaccinatedHealthcare experience requiredSomeone who has managed a Power BI environment, creating user permissions, data governance and compliance and strong experience with automation would be...

  • Director, Enterprise Applications

    4 weeks ago

    Pomona, United States Western University of Health Sciences Full time

    Job Overview Reporting directly to the Associate Vice President of IT, the Director, Enterprise Applications & Databases is one of the key members of the Information Technology Leadership Team (ITLT) and is responsible for the overall support and integration of the institution’s enterprise applications and databases (EAD). Primary duties include functional...