Bi Developer - Oracle Analytics

Bi Developer - Oracle Analytics

Temporary 63000 - 77000 £ / year (est.) On-site
R

At a Glance

  • Tasks: Lead the migration of legacy reporting systems to modern Oracle Analytics and Python automation.
  • Company: Dynamic financial services firm located in Canary Wharf, London.
  • Benefits: 12-month contract with competitive pay and opportunities for professional growth.
  • Other info: Join a collaborative team focused on innovation in a regulated environment.
  • Why this job: Make a significant impact by modernising enterprise reporting frameworks and enhancing data analytics.
  • Qualifications: 8+ years in Oracle DB development and strong Python skills required.

The predicted salary is between 63000 - 77000 £ per year.

  • Hiring: BI Architect - Oracle Analytics & Access
  • Duration: 12-Month Contract
  • Workstream: Finance / Operations Reporting Modernisation

Are you an experienced Solution Architect / Lead Engineer with deep expertise in Oracle Analytics, Python, and legacy Access modernization?

We are looking for a hands-on Lead Architect to drive the end-to-end migration and modernization of an enterprise Microsoft Access & Oracle reporting environment into a modern Oracle Analytics Server (OAS), BI Publisher, and Python-driven automation architecture.

Role Overview

In this role, you will lead the assessment, design, build, and deployment of a replacement reporting framework for a legacy MS Access/VBA application.

You will work across data layer engineering, OAS/BI Publisher builds, Python ETL/automation, and stakeholder engagement within a financial services / enterprise environment.

Key Responsibilities

  • Discovery & Assessment: Inventory legacy MS Access databases (. mdb/. accdb), linked tables, pass-through queries, macros, and VBA logic to define target-state architecture.
  • Oracle DB Engineering: Develop and tune complex Oracle SQL, PL/SQL, views, materialized views, and stored procedures.

Analyze execution plans, AWR/ASH evidence, and TEMP/PGA usage for high-volume workloads.

  • OAS & BI Publisher: Build interactive OAS dashboards, analyses, and BI Publisher data models, layouts, bursting, and automated schedules.
  • Python

Automation: Design production-grade Python scripts (pandas, oracledb, SQLAlchemy, openpyxl, etc.) to replace Access macros, automate extraction, and deliver automated report packs.

  • Testing & Delivery: Conduct parallel runs, complete data reconciliation, establish rollback plans, and deliver production runbooks and team support handovers.
  • Required Experience & Skills
  • 8+ years of Oracle DB development and SQL performance tuning.
  • 5+ years in OAS / OBIEE and BI Publisher development.
  • 5+ years in Python development for data extraction, transformation, and reporting automation.
  • 3+ years migrating legacy Microsoft Access / VBA applications.
  • Strong experience in Financial Services or highly regulated enterprise environments preferred.
  • Experience with Dev Ops concepts, Git, CI/CD, and enterprise schedulers (e. g., Control-M, Autosys).

Bi Developer - Oracle Analytics employer: Randstad Technologies Recruitment

Join a dynamic team in Newcastle where your contributions as a Customer Service Representative will be valued and recognised. We pride ourselves on fostering a collaborative work culture that prioritises employee growth, offering training and development opportunities to enhance your skills. With a focus on delivering exceptional customer service, you'll enjoy a supportive environment that encourages teamwork and innovation, making it an excellent place for meaningful and rewarding employment.

R

Contact Details:

Randstad Technologies Recruitment Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Bi Developer - Oracle Analytics

✨Tap into Online Data Science Communities

Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Randstad Technologies Recruitment before they're even advertised!

✨Show Off Your Skills With Projects

Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.

✨Check Out Specialist Job Boards

For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Randstad Technologies Recruitment.

✨Leverage University Resources

If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Randstad Technologies Recruitment.

We think you need these skills to ace Bi Developer - Oracle Analytics

Oracle Analytics
Python
Microsoft Access
VBA
Oracle SQL
PL/SQL
OAS

Some tips for your application 🫡

Highlight Your Data Projects:When applying for a temporary data science role at Randstad Technologies Recruitment, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.

Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!

Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Randstad Technologies Recruitment, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.

Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Randstad Technologies Recruitment’s attention and show the tangible impact of your work.

How to prepare for a job interview at Randstad Technologies Recruitment

✨Showcase Your Analytical Skills

For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Randstad Technologies Recruitment.

✨Brush Up on Technical Skills

You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.

✨Highlight Your Adaptability

Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Randstad Technologies Recruitment.

✨Prepare a Portfolio of Your Work

Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Randstad Technologies Recruitment.