ODI Developer at Motabililty Operations, London, 6 Months, £Contract Rate

  • Contract Spy
  • London, UK
  • Jun 21, 2022
6 Months or more

Contract Description

About The Role
6 Months Contract, Inside IR35

We are looking for a Data Engineer (6-month contract) to join our development team on high profile projects.  The candidate should be able to demonstrate experience of building Data warehouses using Oracle Data Integrator (ODI) tool as a part of an overall analytics solution. The candidate should have strong hands-on technical experience in programming, SQL and data manipulation/transformation of large data sets using varied databases and platforms and knowledge and experience of Google Analytics and Oracle Analytics Server (OAS) would be advantageous.
About You
 You will have gained the following experience/skills:
  • Build and support data warehouses/data marts/data stores to facilitate data analytics and insights
  • Build and support data integration and transformation routines from source systems to target data stores using an ETL toolset 
  • Build performant code following good development practices and improve existing code as appropriate
  • Work closely with BA’s and the Business Analysis team to build data structures that facilitate data driven insights using various BI Tools like OBIEE, Tableau, Oracle DV etc.
  • Scope of work includes on premise and cloud platform environments primarily covering relational databases (e.g. Oracle, PostgreSQL) and file/object stores (e.g. AWS S3)
Minimum Criteria
  • Experience of:
    o Building, enhancing, supporting data warehouse solutions (primarily using Oracle data warehouse technologies)
    o Proven technical ability in developing, enhancing, tuning and supporting ETL/ELT and data integration solutions using tools from Oracle (Oracle Data Integrator)
    o Strong experience with a PL/SQL
  • Star schema/Dimensional modelling
  • An understanding of Google Analytics structures (preferably GA4), data collection and storage, GA API calling, extraction and load from GA into a customer warehouse, Configuration and Enhancing GA for specific data requirement such as customer attributes, click journeys and GA reporting
  • Good knowledge of working with JSON in Oracle database
  • Some knowledge of Python/Spark libraries such as numPy and Plotly or other data manipulation libraries to create data pipelines would be advantageous
  • Knowledge/experience of Snowflake and JSON manipulation in Snowflake or the aptitude to understand this technology quickly.
  • Exposure to data pipeline tools e.g. Fivetran/Hevo would be beneficial.
  • An understanding of AWS DMS, Kafka, real time analytics, NoSQL, Elastic Stack would also be advantageous
  • We operate a hybrid way or working which includes home and office based working patterns
About The Company
At Motability Operations Ltd we provide a unique mobility proposition for the specific needs of people with disabilities by leasing cars, scooters and powered wheelchairs to those in receipt of Disability Living Allowance and Personal Independence Payment. We are the largest car fleet operator in the UK (purchasing around 10% of all the new cars sold in the UK) and have over 600,000 customers. We pride ourselves on delivering outstanding customer service, achieving an independently verified customer satisfaction rating of 9.8 out of 10.

Our values are at the heart of everything we do and our people demonstrate these values:
  • Empowerment
  • Empathy
  • Inclusion
  • Forward thinking
  • Excellence