Job Description :
Role : Peoplesoft HCM BA
CTH afer 8 month
MUST-HAVE QUALIFICATIONS
5 years experience with PeopleSoft HCM with very strong knowledge of the underlying data (this person should know the tables like the back of his/her hand
5 years experience with relational databases and reporting tools
Thorough understanding of PeopleSoft HCM Data Tables (ERD)
Strong aptitude for writing native SQL
Tableau and/or Power BI experience
Advanced user of Excel including extensive use of pivot tables, vlookups, and other analysis functions
Excellent written and oral communication skills
Hands on-Self starter
RESPONSIBILITIES AND DUTIES
(50%) Data Administration/Support
Create a data dictionary for use outside of PeopleSoft
Define and document business rules for identified KPI’s
Document existing table and field usage for clarity and understanding or relationships for transmission to data warehouse
Perform quality checks on data within client''s ecosystem
Audit for out of bounds conditions on data elements and recommend or implement clean up procedures
Review and resolve issues with data transmissions to data warehouse
(50%) Decision Support
Develop queries via the PeopleSoft Client Server Query Tool, the PeopleSoft Web based query tool and native SQL.
Respond to adhoc data requests
Assist in preparing data for audits and/or legal requests
Analyze disparate sets of information and summarize analysis for business owners
Utilize Tableau and/or Power BI to create meaningful visualizations of HCM data
Troubleshoot reported issues by mining data for scope and patterns
             

Similar Jobs you may be interested in ..