Data Engineer

Motability Operations Ltd; City of Edinburgh; On-site; GBP 50,000 - 70,000; Full time

Job summary

Motability Operations Ltd is seeking a data professional to help integrate, transform and visualise data across MO’s platforms. You will work in an agile scrum team to design and build data feeds and related applications, writing and reviewing ETL code in Oracle ODI, dbt, Snowflake and AWS.

You will partner with business users to configure self-serve data environments within our data warehouse and data lake, analyse, develop and deliver BI reports, and contribute to data quality, reconciliation,

Qualifications

• Were looking for experience in agile SCRUM environments and ETL development.
• Hands-on work with Oracle ODI, dbt, Snowflake and AWS to build data feeds.
• Ability to design self-serve data environments and BI reports.
• Experience with data quality, governance and reconciliation processes.
• Contribute to continuous improvement and production support activities.

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

Agile Scrum

ETL development

Oracle ODI

dbt

Snowflake

AWS

BI reporting

Data governance

Tools

Oracle ODI

dbt

Snowflake

AWS

Job 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