Oracle HRIS Analyst 4 in Chicago, Illinois
Acts as interface between business and IT organization with regards to HRMS implementation.
Supports users in the report generation process. Works closely with the Business HR to ensure all reports in (via HRMS) including SQL queries (both ad hoc and maintenance reports) are accurate. Process Mass Change Spreadsheets. Ensures data integrity in Oracle HRMS database by running regular audits. Conducts high-level HRMS needs analysis, prepares business specifications, implements modifications and enhancements and ensures system documentation are updated. Assists with the development and delivery of HRMS training to users. Provides systems support for HR applications, including Oracle Core HRMS, HR Self Service Applications, Discoverer Reports, etc. Participates in User Acceptance Tests. Undertakes special projects on an as need basis to address specific HRMS issues.
Leading contributor individually and as a team member, providing direction and mentoring to others. Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Strong knowledge of Oracle applications, HRMS functionality, set-up tables, table structures, PL/SQL, and Microsoft applications such as Excel. 2 to 3 years Oracle Applications experience. Problem solving skills and strong analytical skills. Good oral and written communication skills. Ability to manage vast amount of data efficiently. Typical experience 8 plus years.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans status or any other characteristic protected by law.
Oracle's Mergers & Acquisitions (M&A) Human Resources Organizationis looking for an HR Data Analyst to lead the data management and reporting responsibilities in support of the integration and onboarding process.
*Data Management and Reporting
Liaise with the acquired company to obtain employee information.
Collate, validate, and audit HR employee data in support of data management integration activities.
Manage employee data using the M&A HR Data Management Tool (DMT) and spreadsheets, ensuring data accuracy and timely updates.
Audit and prepare employee data for offer approvals and generation.
Audit and prepare new hire load data for upload to the Oracle HR system.
Coordinate offer and new hire load timing with the Global HR Service Center (GHRS).
Provide data reports, pivots and audit results to the Oracle M&A HR team and relevant Oracle stakeholders.
Develop and maintain data management processes, tools and communications when needed.
Assist with the resolution of acquired employee issues in the DMT and the Oracle HR System.
Assist in the testing of new enhancements to the M&A HR DMT and related applications.
Manage the data management activities and track progress in the M&A project management tool (MAPP).
Attenddeal specific M&A HR acquisition meetings to provide updates related to the data management activities.
Point of contact for Oracle stakeholders as it pertains to deal specific data management responsibilities, timing, issues, or escalations (e.g., Global HR Service Center, Account Provisioning, Payroll, Benefits, Line HR).
Build and maintain relationships with Oracle stakeholder to ensure understanding of M&A HR data management processes.
Provide data management process and DMT training when needed.
- Proficient in Excel, as follows:
o Basic cell functions:sum, average, count, etc.
o Advanced cell functions:vlookup, hlookup, vested if functions.
o Macros:recording macros, buttons and hotkeysfor macros, fundamental Visual Basic coding knowledge for macro editing andcreation.
o Advanced sorting:sort, subtotal.
o Protection:protecting entire workbooks and single worksheet.
o Filters:autofilter, custom filters, working with filtered data.
o Data consolidation and concatenation for data reconciliation and auditing.
o Creating and altering charts.
o PivotTables and PivotCharts.
o Custom number formats.
o Change tracking.
o Data Validation.
o Range naming.
Self-starter with the ability tosuccessfully manage multiple priorities in a complex fast paced environment.
Able to analyze and present data andrecommendations in an organized and logical manner.
Demonstrated project management skillsand the ability to consult with all levels of organization.
Experience working on complex issueswhere analysis requires an in depth evaluation of variable factors.
Well-developed problem analysis andresolution skills, with ability to exercise judgment in selecting methods,techniques and evaluation criteria for obtaining results.
Exceptional customer service and communicationskills.
Experience working in a teamenvironment, collaborating on projects, as well as resolving daily issues.
Human Resources experience, includingM&A HR is preferred.
Job: *Human Resources
Title: HRIS Analyst 4
Location: United States
Requisition ID: 170013WH