OTBI and BI Publisher Developer

Our client, a leading global organisation, is partnering with a prestigious end client in Belfast. We are excited to offer a fantastic opportunity for an experienced OTBI and BI Publisher Developer to join a dynamic team on an initial 6-month contract, with the potential for extension.

If you are interested and have the relevant skills and experience, please apply promptly to discuss further.

Role: OTBI and BI Publisher Developer

Duration: 6 months (View to extend to a year)

Location: Remote - Belfast (Occasional travel based on need)

Skillset required:

• Expertise in Oracle OTBI and BI Publisher.
• Strong SQL and PL/SQL skills
• Familiarity with Oracle Fusion SaaS modules (e.g., HCM, ERP, SCM)
• Experience in data modelling, subject areas and schema design.
• Strong analytical and problem-solving skills.
• Effective communication and collaboration with cross-functional teams.
• Ability to understand and translate business requirements into technical solutions.

Key responsibilities:

• Design, develop OTBI reports and dashboards to meet business requirements.
• Leverage OTBI subject areas to create ad hoc queries, analyses and dashboards.
• Ensure data accuracy and relevancy in OTBI Outputs.
• Create and maintain BI Publisher reports using XML, RTF templates, and SQL queries.
• Develop pixel-perfect reports and formatted outputs for printing or distribution
• Optimize report performance and troubleshoot issues
• Analyze business requirements and translate them into data models or reporting solutions
• Collaborate with functional teams to understand key performance indicators (KPIs) and reporting needs.
• Integrate OTBI and BI Publisher with Oracle Fusion SaaS modules (e.g., HCM, ERP, SCM)
• Work with Oracle Data Models and subject areas specific to Oracle SaaS applications.
• Optimize SQL queries and report designs for performance
• Maintain clear documentation for all reports, dashboards and BI processes.