Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Peoplesoft HCM Business Data Analyst (179 views)

Atlanta, GA/Remote
August 19, 2021

***** Direct Client Requirement*****

Title                                    : Peoplesoft HCM Business Data Analyst

Location                             : Atlanta, GA/Remote

Rate                                    : DOE /If your experience and skills match call us immediately for submission

Duration                             : 7+ Months

Interview Type                   : Web Cam or In Person

Job Type                            : C2C,C2H, W2

Experience                        : 7+ Years

Job Description:        

Responsibilities:

This position will focus heavily on reporting, data integrations, and other data-related projects. The Business Analyst will gather requirements both from stakeholders and from own analysis of existing reports to meet new needs and introduce improvements. They will identify data sources and criteria needed, document specs for developers, test the output, and ensure user acceptance. Extensive use of SQL is expected throughout this process. The Business Analyst will prioritize tasks and coordinate the work of the development team.

  • Collect and prioritize requests for reports, integrations, and other data needs
  • Work closely with stakeholders to understand the business process and turn vague one-liner requests into detailed, testable requirements that meet business needs
  • Identify and document data sources, criteria, and data mapping
  • Use SQL to explore, extract, and analyze data to support and test requirements
  • Write report and data feed specifications for BI and ETL Developers
  • Organize tasks for the development team and coordinate development, testing, and deploy
  • Communicate prioritization and progress on requests to stakeholders
  • Test reports and data feeds hands-on, as well as lead stakeholders through UAT
  • Design reports/dashboard layouts to present data in a clean, consumable, and insightful format
  • Audit existing reports and propose improvements for findability of data
  • Assist customers with ad-hoc reporting needs

The ideal candidate has proven working experience taking a vaguely stated business question and unpacking it into specific requirements, data sources, and criteria. The skillset is a cross between a business analyst working with the customer on requirements discovery and a “data detective” identifying and interpreting data using strong SQL and analysis skills. Analytical /conceptual/ curious/ problem-solving mindset is an absolute must. Experience writing SQL against complex tables containing historical/future data is a must. Working knowledge of HR data and processes is strongly preferred.

Interview Expectations: During the interview, the candidate will be expected to walk GTRI through his/her data gathering, analysis, and SQL experience in detail. The interviews will be very thorough and the candidate will be expected articulate answers for scenario based questions. .1st Interview: Phone, Second Interview: Virtual, Final Step: Extend Offer

Education and Experience (required)

  • Bachelor’s degree in Business, Computer Science, or related field
  • 6-8 years of business analysis experience, including:
  • 4-5 years of experience performing data analysis
  • 3-4 years of experience writing complex SQL queries

Qualifications (required)

  • Above average analytical and conceptual thinking; resourceful problem-solving
  • Quick grasp of new information and ability to lead stakeholders to articulate core hidden needs
  • Strong SQL skills; experience writing complex queries with multiple table joins, subqueries, and effective- dated data
  • Experience communicating with all levels of the organization in a clear and concise manner using non- technical language
  • Great organizational skills for own work and prioritization and coordination of team activities
  • Excellent documentation skills; attention to detail
  • Strong experience working with HR data and processes; process analysis skills

Additional Qualifications (preferred)

  • Experience with PeopleSoft HCM data
  • Eye for aesthetics and usability in report design
  • Strong Excel skills (formulas, charts, pivot tables)
  • Strong presentation skills

This role is expected to extend into mid-year 2022.

Required / Desired Skills

  • Above average analytical and conceptual thinking; resourceful problem-solving
    Required 4 Years
  • Quick grasp of new information and ability to lead stakeholders to articulate core hidden needs
    Required 4 Years
  • Strong SQL skills; experience writing complex queries with multiple table joins, subqueries, and effective-dated data
    Required 4 Years
  • Experience communicating with all levels of the organization in a clear and concise manner using non-technical language
    Required 4 Years
  • Great organizational skills for own work and prioritization and coordination of team activities
    Required 4 Years
  • Excellent documentation skills; attention to detail
    Required 4 Years
  • Strong experience working with HR data and processes
    Required 4 Years
  • PeopleSoft HCM data
    Highly desired 4 Years
  • Eye for aesthetics and usability in report design
    Required 4 Years
  • Strong Excel skills (formulas, charts, pivot tables)
    Required 4 Years

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus*******

Thanks

Ben/Siva

Ben@Sohanit.com/Siva@sohanit.com

PH: 470-480-2413 EX 104/470-480-2412 EX 103

Apply here or please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true

Twitter: https://twitter.com/SohanITInc1

Position Keywords: PeopleSoft HCM data, SQL,data analysis,UAT

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 9 Months

% Travel Required: None

Job Posted by: Consulting Services

Don't have time now?
Get a reminder in your inbox