Oracle Report Developer

On behalf of FCDO we are looking for an Oracle Report Developer (Inside IR35) for a 4 month contract. Hybrid working based in London or Milton Keynes.

The Foreign, Commonwealth & Development Office (FCDO) pursues our national interests and projects the UK as a force for good in the world. We promote the interests of British citizens, safeguard the UK's security, defend our values, reduce poverty, and tackle global challenges with our international partners.

This role is a 'hands-on' OBIEE/OBIA/OACS developer and requires working with others to specify, design and implement the reporting technical and dashboard/report requirements for the Hera Service, this involves developing, validating and reviewing conceptual, logical and physical report designs.

As an Oracle Report Developer your main responsibilities will be to:

. Execute data flows by using Oracle Database Cloud.
. Create scalable data flows including ingestion, transformation, and persistence.
. Create connections and data sources for drill-through, data loads and dimension builds.
. Collect collaborative data, create scenarios, and perform what-if analysis using Smart View.
. Build data models, reports, and analytic dashboards in an enterprise Business Intelligence environment.
. Design and publish pixel-perfect reports from the enterprise data.
. Maintain live and optimized connectivity to on-premises data warehouses.

Essential:

. An active SC Clearance is an essential requirement for this role, as a minimum you must be willing & eligible to undergo checks. (Please note, due to the exceptional requirements of this position (short-term nature of this role and speed at which we require a postholder in situ) preference may be given to candidates who meet all of the essential criteria and hold active security clearance.)
. Experience of Oracle BI Tools - OTBI (Oracle Transactional Business Intelligence), Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition (OBIEE) including report development.
. Experience of Oracle Database technologies - data warehouse development including dimensional modelling.
. Good ODI skills, both in terms of the basics, but also being able to write knowledge modules, integrate with OBIEE, deployment and migration.
. Solid database skills - partitioning, materialized views, index types and Oracle PL/SQL - to support BI development.

Desirable:

. Experience of ERP/HCM systems on Oracle eBusiness Suite.
. Exposure to Oracle ICS Middleware tools.
. Experience with Oracle Financials ERP and customization including using BI Publisher reports.

Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident

As a member of the Disability Confident Scheme, FCDO guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".