SonicJobs Logo
Left arrow iconBack to search

Oracle Developer

Copello
Posted 20 hours ago, valid for 20 days
Location

London, Greater London EC3V 3LA, England

Salary

£55,000 - £66,000 per annum

info
Contract type

Full Time

In order to submit this application, a TotalJobs account will be created for you. As such, in addition to applying for this job, you will be signed up to all TotalJobs’ services as part of the process. By submitting this application, you agree to TotalJobs’ Terms and Conditions and acknowledge that your personal data will be transferred to TotalJobs and processed by them in accordance with their Privacy Policy.

Sonic Summary

info
  • The Oracle Report Writer position is based in London with a hybrid work model and is a 6-month contract inside IR35.
  • The role requires a minimum of 3-5 years of experience in report writing with Oracle Fusion Cloud and associated reporting tools.
  • Candidates should have proficiency in BI Publisher, OTBI, FRS, Oracle Smart View, and OAC, along with strong SQL and data modeling skills.
  • The position offers a salary of £450-£500 per day, depending on experience and qualifications.
  • The successful candidate will collaborate with cross-functional teams to deliver actionable insights and maintain reporting solutions.

Job Title: Oracle Report Writer

Location: London/Hybrid

Contract: Inside IR35 / 6 months


Job Purpose:

The Report Writer (Oracle Fusion) is responsible for designing, developing, and maintaining reports and dashboards across all Oracle Fusion reporting tools. The individual will work closely with business stakeholders to understand reporting requirements, analyse data sources, and deliver actionable insights. The role requires proficiency in Oracle Fusion applications reporting tools like BI Publisher, OTBI, Oracle Smart View, and FRS, to develop comprehensive reporting solutions that support strategic business decisions. Require good experience in Oracle Analytics Cloud (OAC) data modelling, dashboard, and report activities.


Key Responsibilities:

Report Development:

  • Design and develop reports & dashboards using Oracle Reporting tools such as BI Publisher, OTBI (Oracle Transactional Business Intelligence), FRS (Financial Reporting Studio), Smart View, and OAC (Oracle Analytics Cloud).
  • Build complex data models and data extracts to meet business requirements, ensuring high performance and data integrity.
  • Create dashboards and interactive visualisations for users to analyse real-time data.

Data Analysis & Validation:

  • Perform data analysis and validation to ensure the accuracy and consistency of report outputs.
  • Troubleshoot data inconsistencies and discrepancies, working with IT and functional teams to resolve data quality issues.
  • Refine reports for better performance and usability

Documentation & Maintenance:

  • Document report specifications, data sources, and business logic to ensure long-term maintainability and scalability.
  • Maintain and update existing reports based on evolving business requirements or Oracle Fusion updates.
  • Ensure adherence to data governance policies and best practices for data security and compliance.


Key Skills & Competencies:

Technical Expertise:

  • Proficiency in Oracle Fusion Cloud applications and modules landscape (Financials, Procurement, etc. and their interdependencies).
  • In-depth knowledge of Oracle reporting tools: BI Publisher, OTBI, FRS, Oracle Smart View, Narrative Reporting[NR1][MK2] and OAC.
  • Familiarity with SQL, PL/SQL, and database structures for creating data models and queries.
  • Good understanding of security model on Fusion Application and OAC platform to ensure that reports are delivered to meet business requirements in secured way.
  • Knowledge of various EPM reporting writing tools, in particular Oracle Smart View, Web Forms, Dashboards & Infolets, and Financial Reporting Studio.
  • Desirable: Knowledge of how to connect external reporting tools like Power BI and QliKSense with EPM data sources.
  • Desirable: Knowledge of Narrative Reporting and how to leverage its capabilities to build rich narrative driven reports

Communication & Collaboration:

  • Ability to explain technical details to both technical and non-technical stakeholders.
  • Strong collaboration skills to work within cross-functional teams including IT, Finance, HR, and other departments.

Qualifications & Experience:

Education:

Bachelors degree in Computer Science, Information Systems, Business, or related field.

Experience:

  • Minimum 3-5 years of experience in report writing with Oracle Fusion Cloud and associated reporting tools.
  • Hands-on experience with BI Publisher, OTBI, FRS, Oracle Smart View and OAC.
  • Proven experience in SQL, database querying, and building data models
  • Experience working in cross-functional teams and communicating with business and IT stakeholders
  • Prior experience in creating reports & dashboard for Fusion Cloud Applications must have.


Desirable Skills:

  • Experience in archive data reporting would be preferred but not mandatory.
  • Familiarity with additional Oracle Fusion tools like HCM Extracts, Financial Analytics, and Oracle Data Visualisation.
  • Experience with reporting tools outside Oracle Fusion (e.g., Power BI, Tableau) for comparative data visualisation skills.
  • Knowledge of cloud computing and understanding of Oracle Autonomous Datawarehouse (ADW), Oracle Data Integrator (ODI) market place and Oracle Cloud Infrastructure (OCI) would be beneficial.
  • Good understanding of how data is extracted from Fusion Cloud to OAC using BICC Connectors
  • Good understanding of EPM modules, in particular Financials, Workforce, and Projects.
  • Understanding of EPM dimensionality and how it can be enhanced through attributes and UDAs

Apply now in a few quick clicks

In order to submit this application, a TotalJobs account will be created for you. As such, in addition to applying for this job, you will be signed up to all TotalJobs’ services as part of the process. By submitting this application, you agree to TotalJobs’ Terms and Conditions and acknowledge that your personal data will be transferred to TotalJobs and processed by them in accordance with their Privacy Policy.