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

As the Senior SQL Developer you will primarily be focused on the development of solutions that involve databases, and to provide the oversight and design of SQL based solutions.  You will be responsible for mentoring and coaching other team members when required, to help ensure that the business intelligence architecture and standards are achieved.

You will carry out primarily working on the data warehouse platform where you will be responsible for the extract, transform and load of data from source systems into the Data Warehouse Platform.

Strong knowledge in Data Visualisation tooling such as Tableau / PowerBI / Oracle BI Publisher etc. will be required for the role. 

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.
  • Lead the development of new solutions on projects when required.
  • Work closely with the Data Architect in order to map existing entities to the overall business Data Model.
  • Become the “trusted advisor” for data development.
  • Mentor and guide other team members.

What you will need

Essential

  • Educated to degree standard or equivalent (e.g. Management of Information Systems, Computer Studies)
  • Experience within a database environment area, working with SQL languages (Oracle SQL / PostgreSQL / MS SQL / etc.)
  • Experience of development of data warehouse platforms
  • 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 recognises system deficiencies and implements effective solutions
  • Excellent systems analytical skills to transform innovative and creative solutions into functional systems.
  • Self-starter, self-motivated,  self-sufficient and foster ‘trusted advisor’ relationships with the business
  • Strong skills with OLTP database environments as well as business intelligence and data warehousing design principles and complex database concepts
  • Good understanding of software security and application performance best practices
  • Communication skills and the ability to present complex concepts in a simple logical manner, both technical and business terms
  • Works well under pressure and to deadlines and can use own initiatives
  • Logical analysis and trouble-shooting skills
  • Problem solving and resourceful methodical thinking
  • Good organisation 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
  • PowerBI
  • Understanding of predictive modelling and probability analysis
  • Toad
  • Functional analysis
  • Greenplum Engines
  • AWS development knowledge
  • MongoDB / Cassandra / NOQSL experience a strong plus

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.