The data analyst is responsible for assessing, modifying, and developing ERP reports, ensuring they are accurately designed, tested, and deployed, and that business users are supported through UAT and hypercare.
Responsibilities include:
- Assess existing ERP reports to determine reporting requirements, usage, gaps, and recommendations
- Following data governance standards, modify existing reports using BI Publisher (BIP) and OTBI, applying strong working knowledge of both tools to meet business needs
- Following data governance standards, design data models and technical specifications for reports, ensuring accuracy, performance, and alignment to Oracle best practices
- Develop and execute test plans and scripts for reports, and track and resolve defects through to closure
- Support business users during user acceptance testing (UAT), addressing questions, feedback, and required report adjustments
- Support the deployment of reports to production following change management and release processes
- Provide hypercare support after go-live, resolving reporting issues promptly to ensure stabilization
- Create and maintain documentation, including technical designs, test evidence, and report user guides
- Collaborate with Finance, Oracle, and technical teams to clarify requirements and resolve data issues
Requirements and skills:
- Strong working knowledge of BI Publisher (BIP) and OTBI reporting, including report design, data models, and subject areas
- Experience with Oracle ERP Cloud Fusion reporting and data structures
- Experience with SQL and data modelling
- Good communication skills are necessary
- Self-starter, motivated and results oriented collaborator
- Detail oriented, strong analytical and problem-solving skills and have an ability to find creative solutions
- Strong teamwork skills, but ability to work independently
- Familiar with Office 365 (intermediate skills in Excel preferred)
- Quick learner
- Preferably working knowledge of ServiceNow and Oracle Cloud Financials
Preferably Oracle reporting certification, but not necessary