• Department / Function IT
  • Location Cardiff City Centre
  • Number of roles available 1
  • Salary Competitive salary plus excellent perks and benefits
  • Closing Date 28/02/2020

As the Oracle Developer you will be responsible for the design, development, implementation and testing of the business intelligence strategy across multiple business areas.  You will be responsible for the implementation and maintenance of our current data warehouse and dashboard tools.

Mentoring and coaching other team members, when required, will be part of the role to help ensure that the business intelligence architecture and standards are achieved.

What you will be doing

  • Provide development on Business Intelligence, BI Publisher, Data Warehouse and Dashboard presentation systems as well as providing higher level support and be actively involved in reporting systems
  • Advanced SQL and PL/SQL development and high performance tuning for a range of requirements including data extracts/loads and complex inquiry and update logic
  • Documenting and maintaining a core document of any data / table / index information to allow for greater data governance
  • Support, administrate, maintain, manage and monitor our OLTP system processes, system functionality and batch processes
  • Produce standard reporting and business intelligence solutions for use by key stakeholders at all levels of the organisation
  • Help with the continued development of the data platform, with responsibility for the company’s growing data warehouse environment, business intelligence tools, and system integrations
  • Keep management well informed of status of management information effort and serves as liaison between MI staff and management where required
  • Agree appropriate design standards, methods and tools in consultation with senior management ensuring they are applied effectively and take account of enterprise and solutions architectures
  • Ensure that problems are managed in accordance with agreed standards and processes and the escalation procedures are adhered to, responding to escalation, complex and high impact problems in a timely fashion

What you will need

Essential

  • Experience within a database environment working with Oracle Database (11g or 12c), SQL, PL/SQL and ETL technologies, other database environments are acceptable in regards to SQL such as Postgres, MYSQL or Microsoft SQL server
  • Warehouse design/ development experience
  • Programming experience and proficient with PL/SQL and SQL based queries and ETL technologies
  • Strong skills with OLTP database environments as well as business intelligence and data warehousing design principles and complex database concepts
  • Exposure to partitioning materialized views and other Oracle analytical functions
  • Easily recognizes system deficiencies and implement effective solutions
  • Excellent systems analytical skills to transform innovative and creative solutions into functional systems
  • Strong skills with OLTP database environments as well as business intelligence and data warehousing design principles and complex database concepts
  • Self-starter, self-motivated, self-sufficient and foster ‘trusted advisor’ relationships with the business
  • Strong understanding of common software failures and faults
  • Excellent analytical skills with a challenging and enquiring mind
  • Communication skills and the ability to present complex concepts in a simple logical manner, both technical and business terms
  • Proven experience of working well under pressure and to deadlines and can use own initiatives
  • Logical analysis and trouble-shooting skills
  • Problem solving and resourceful methodical thinking
  • Good organization and planning skills and attention to detail
  • Flexible to change, motivated and enthusiastic

Highly Desirable

  • ITIL Methodology
  • Financial services industry
  • Financial Calculations – Asset finance agreements
  • Oracle BI Publisher
  • Understanding of predictive modelling and probability analysis
  • Toad
  • Functional analysis

Life in the team

Our Architecture and Delivery function brings the IT Delivery, Architecture and Business Intelligence teams together. They work collaboratively on projects across the business, sharing best practice, knowledge and gaining insight into the end to end delivery of Technology change.

We don’t just focus on the business outcome; here at MotoNovo Finance we recognise the importance of personal and professional development, so we offer great and frequent opportunities for learning and development. There is also the very competitive benefits package which can be found on our ‘Working Here’ page.

What the process looks like

If successful at the application stage, we will invite you to complete a call with our Head of Architecture and Delivery to discuss the role and your relevant experience. Don’t worry this is an opportunity for you to ask us questions too!

Following this, you may be invited into our Head Office for a competency based interview. If this goes well we will be asking you to join the team!

If successful you will need to provide Proof of Right to Work in the UK prior to commencing your employment. We are committed to equal opportunities.

Please be aware that we reserve the right to close this vacancy early should sufficient applications be received.

We welcome applications from all suitably qualified candidates as we know that Diversity & Inclusion is integral to the success of the company and we are striving to build a company where everyone feels welcome and valued and where differences are embraced.

We do not accept speculative agency CVs. Any CV received by Motonovo Finance will be treated as a gift and not eligible for an agency fee. PSL agencies should only send CVs if authorised to do so by the Recruitment team.