Senior Business Analyst (Oracle HCM Reporting)

Lancesoft; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

A leading company is seeking a highly skilled Senior Business Systems Analyst to join their HR Technology team. The role involves providing expert support for Oracle Cloud HCM reporting, designing complex reports, and ensuring data security and integrity. Candidates should have extensive experience with Oracle HCM Reporting and strong analytical skills. This position offers the flexibility of remote work and requires collaboration with various stakeholders to meet reporting needs.

Qualifications

• Minimum 5 years of extensive experience with Oracle HCM Reporting.
• Total 5 to 7 years of IT experience in building reports and dashboards using Oracle BI Publisher and OTBI.

Responsibilities

• Act as primary liaison for Oracle HCM Cloud Reporting, consulting with internal customers.
• Design and maintain complex reports using Oracle BIP and OTBI.
• Implement security rules within Oracle HCM reporting.

Skills

Oracle HCM Reporting

Oracle BI Publisher

OTBI

Analytical skills

Good Communication

Stakeholders Management

Tools

Oracle Analytics Cloud

SQL

Job description

Note: 70% should be in Functional and 30% in Technical

Skills - Oracle HCM Reporting, Oracle BI Publisher and OTBI, Interactive dashboards, and Analytical skills, HR Modules, Good Communication, Stakeholders Mgt,

Exp 7 to 10 Years

Rel. Exp 5+ Years into Functional

Shift timings 2 PM to 9PM

Work Mode – Remote

Job Summary:
We are seeking a highly skilled and detail-oriented Senior Business Systems Analyst to join HR Technology team and provide expert support for Oracle Cloud HCM reporting. The successful candidate will be responsible for designing, maintaining complex reports using both Oracle Business Intelligence Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI) across HR, Benefits, Compensation, Performance and Talent modules. An important component of this role is the understanding and implementation of security rules within the reporting environment to ensure confidentiality and integrity of data.
Experience:
• Minium 5 years of extensive experience with Oracle HCM Reporting.
• Total 5 to 7 years of IT experience in building reports and dashboards using Oracle BI Publisher and OTBI.

Responsibilities:
• Requirements Gathering and Analysis:
o Act as primary liaison for Oracle HCM Cloud Reporting, consulting with internal customers to create requirements for new reports, report changes, and data requests.
o Developing or translating requirements to technical developers.
o Collaborate with HR, Benefits, Compensation, Performance, and Talent stakeholders to understand their reporting and security needs.
o Translate complex business requirements into clear and detailed Funcitonal specifications, including security requirements.
o Analyze existing reports and security configurations to identify areas for improvement and performance optimization.
o Document requirements, specifications, security design, and testing plans.
• Report Maintenance:
o Design and maintain complex reports using Oracle BIP and OTBI, including data modeling, SQL queries, and layout design.
o Ensure data accuracy, consistency, and security across all reports.
o Optimize report performance and troubleshoot reporting and security issues.
• Security Implementation and Management:
o Design and implement security rules within Oracle HCM reporting to control access to sensitive data.
o Understand and apply Oracle HCM security concepts and configurations related to reporting.
• Data Analysis and Validation:
o Perform data analysis to validate report results and identify data discrepancies and security vulnerabilities.
o Develop and execute test plans to ensure report accuracy and functionality.
• User Support and Training:
o Provide support to end-users regarding report usage, troubleshooting, and security guidelines.
o Develop and deliver training materials and documentation for reports and reporting tools.
o Assist in the development of best practices and standards for reporting and security.
• Project Management and Collaboration:
o Participate in project planning and execution related to reporting and security initiatives.
o Collaborate with IT, security, and other business teams to ensure successful report and security implementation.
o Manage multiple reporting and security projects and prioritize tasks effectively.
o Keep up to date on oracle HCM cloud updates, new report features and security patches.
Preferred Skills:
• Experience with Oracle Analytics Cloud (OAC).
• Experience with other reporting and security tools.
• Knowledge of data warehousing concepts and security best practices.
• Project management experience.
• Experience with SOX or other compliance standards