Data Engineer

The D&A team works on allowing integration, transformation and visualisation throughout MO, allowing the organisation to maximise on the power of its data.

The successful candidate would be:

Working in an agile scrum team to design and build data feeds and related applications

Writing, testing and peer review of ETL code in Oracle ODI, dbt, Snowflake and AWS.

Working with business users to design and configure self-serve data environments within our data warehouse and data lake

Analysing, developing, delivering, and managing BI reports

Assisting in the design of the data processes, including data quality, reconciliation, testing, and governance

Contributing to technical process improvement initiatives

Releasing and supporting software through environments including production support and working with stakeholders to sign-off business requirements

Assisting in prioritisation and estimation

In addition to a candidate who is technically very strong, we are also seeking:

Communication

Ability to interact with Business users in a professional manner

Ability to communicate directly with peers and customers remotely or face-to-face

Excellent presentation skills

Highly customer focused with a drive to work collaboratively

High Performer

Strong analytical and problem solving skills

Ability to make recommendations and take decisions

Highly organised with effective time management and planning skills

Excellent attention to detail

Able to perform well as a sole developer on a project and as part of a wider BI team within the organization

Willingness to adapt to change

Ability to work to deadlines

Enjoys technical challenges and learning new skills

Willingness to take part in overnight support rota

Minimum Criteria

You’ll need all of these.

Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODI or dbt

Significant database experience in Snowflake and/or Oracle

Star schema/dimensional modelling.

Excellent SQL skills

Good knowledge of standard data formats (XML, JSON, csv, etc)

Proven experience of delivering BI solutions for business requirements

Experience of developing using an Agile development approach

Proven experience working in a cloud environment

Desirable

Proven Experience of Oracle ODI / OAS, Power BI, dbt or Snowflake.

Experience in AWS (in particular terraform, lambda, step functions, S3)

Understanding of machine learning or data science, including python.

Experience working with customer or vehicle data.

Motability Operations is a unique organisation, virtually one of a kind. We combine a strong sense of purpose with a real commercial edge to ensure we provide the best possible worry-free mobility solutions to over 800,000 customers and their families across the UK. Customers exchange their higher rate mobility allowance to lease a range of affordable vehicles (cars, wheelchair accessible vehicles, scooters, and powered wheelchairs) with insurance, maintenance and breakdown assistance included. We are the largest car fleet operator in the UK (purchasing around 10% of all the new cars sold in the UK) and work with a network of around 5,000 car dealers and all the major manufacturers. 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. They represent ambition, and we look for our people to live and breathe them every day:

We find solutions

We drive change

We care

We operate hybrid working across the organisation where we split our time between working on-site at our offices, and at home, remotely within the UK. We believe hybrid working achieves a good work/life balance for our colleagues, allowing us to connect with each other, collaborate on important work, and perform together to deliver for our customers. It allows us to have the flexibility to work remotely up to 2-days per week whilst also using the great office spaces we have available.

As a Motability Operations team member, the benefits you can expect are:

Competitive reward package including an annual discretionary bonus

15% non-contributory pension (9% non-contributory pension during probation period)

28 days annual leave with option to purchase and sell days

Free fresh fruit and snacks in the office

1 day for volunteering

Funded Private Medical Insurance cover

Electric/Hybrid Car Salary Sacrifice Scheme and Cycle to Work Scheme

Life assurance at 4 times your basic salary to give you a peace of mind that your loved ones will receive some financial help

Funded health screening for over 50s

Voluntary benefits: charitable giving, critical illness insurance, dental insurance, health and cancer screenings for you and your partner, discounted gym memberships and season ticket loans

Employee Discount Scheme with an app to save on the go

Free access to healthcare apps such as Peppy, Unmind, Aviva Digital GP and volunteering app on Hand for all employees

Generous family leave policies

At Motability Operations, we believe in building a diverse workforce, where our people are empowered to attend work as their true selves, and we encourage people from all backgrounds to apply. We want to sustain a culture that nurtures, where employees are free to flourish and where they’re rewarded equally, regardless of race, nationality or ethnic origin, sexual orientation, age, disability, or gender.

We pride ourselves on being an inclusive employer and as such, all our offices provide first rate disability access. With our hybrid working environment, we do our best to accommodate part-time and flexible working requests where possible, building on our culture of trust, empowerment, and flexibility.