ODI Developer at Motability Operations Ltd, Bristol, 6 Months, £Contract Rate
Jan 06, 2021
6 Months or more
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 ODI (Oracle Data Integrator) 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 a knowledge and experience of Google Analytics as well as Python and Spark libraries would be advantageous.
You have experience of the following:
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 Oracle Data Integrator (ODI)
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)
Experience building, enhancing, supporting data warehouse solutions (primarily using Oracle data warehouse technologies)
Proven technical ability in developing, enhancing, tuning and supporting ETL/ELT and data integration solutions using tools from Oracle (Oracle Data Integrator)
Strong experience with a PL/SQL
Star schema/Dimensional modelling
An understanding of Google Analytics structures, 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 JSONs 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
An understanding of AWS DMS, Kafka, real time analytics, NoSQL, Elastic Stack would also be advantageous
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 625,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:
About Contract Spy
Discovering Direct IT Contract Opportunities for Contract Spy members.