Previous Job
Previous
Reporting Specialist I
Ref No.: 18-16279
Location: HOUSTON, Texas
Job Title: Reporting Specialist I
Duration: 8 months
Location: Houston, TX- 70056
 
 
Description/Comment:
 
  • The PeopleSoft HR/ELM Reporting Specialist produces, presents and analyzes customer-required reporting needs. Reports will generate from the Peoplesoft HR and ELM applications or directly from the application data tables.
  • The position may require mass corrections be made to PeopleSoft data by leveraging the tools provided within ELM or, in limited cases, using SQL updates.
  • The Reporting Specialist must be able to export and convert raw data from various databases and applications and extrapolate that data into customer usable reports.
  • The Reporting Specialist must also be able to synthesize and interpret relevant data to generate comparisons of current and historical information.
  • This position is part of the HR Infrastructure team and may be required to assist with other tasks as needed.
  • This position reports to the HR Curriculum and Infrastructure Systems Lead and has no direct reports.
  • The position, based in Houston Texas, will not require travel.
 
Specific Duties Performed:
 
  • Generate and analyze raw data to meet client requirements.
  • Develop, test, and implement reports using PeopleSoft reporting tools, PSquery, Showcase, MS SQL Reporting Services (SSRS), or MS Excel.
  • Maintain a schedule of documented reports.
  • Create pivot tables, charts, graphs, presentations and SQL queries.
  • Quickly design and execute ad-hoc reports.
  • Analyze current and historical data to make statistically credible predictions of future states.
  • Perform trend analysis, use statistical methods to analyze data.
 
Specific Experience Required:
 
  • Two (2) years of experience in a customer service environment, working with Peoplesoft reporting and data analysis.
  • Two (2) years of experience using Peoplesoft HR/ELM application data tables; knowledge of data structures.
  • Experienced using SQL and writing SQL queries.
  • Work history to demonstrate advanced proficiency with MS Office Suite applications; specifically MS Excel.
  • Familiarity with MS Power Query, Power View, or Power BI is preferred
  • Ability to create macros or tools to automate processes
  • Proficiency with PeopleSoft (specifically HR and ELM)
  • Strong written and oral communications skills.
  • Strong attention to detail.
  • Ability to work flexible schedule
  
Hours:  8:00am to 5:00pm
 
Shift Type : 1st Shift


Regards,

Rashmi Magal | Team Lead
Sunrise Systems Inc
105 Fieldcrest Ave, Suite#504, Edison, NJ 08837
Direct: (732) 272 0331 |rashmi@sunrisesys.com