Data Engineer

Motability Operations Limited; City Of London; Hybrid; GBP 55,000 - 90,000; Full time

Benefits offered by this job

Annual discretionary bonus

15% pension (non-contributory)

25 days annual leave

Hybrid working

Private medical insurance

Job summary

Motability Operations Limited is seeking a skilled BI/ETL specialist to join the D&A team in delivering data integration, transformation and visualisation across the organisation.

You will work in an agile scrum team to design data feeds, develop ETL code using Oracle ODI, dbt, Snowflake and AWS, and enable self-serve BI environments for business users within our data warehouse and data lake.

Qualifications

• 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

Responsibilities

• 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

Skills

SQL

Snowflake

Oracle ODI

dbt

Power BI

AWS

ETL

Data warehouse

Agile

Communication

Analytical

Tools

Oracle ODI

dbt

Snowflake

Power BI

AWS

Terraform

Job description

About The Role

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

About You

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.

About The Company

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.