Data Engineer

Description
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

Qualifications
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.

Benefits
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.