ODI Developer at Motabililty Operations, London, 6 Months, £Contract Rate
Jun 21, 2022
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 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.
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)
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:
About Contract Spy
Discovering Direct IT Contract Opportunities for Contract Spy members.