Data Engineer

About The Role

We use innovation to shape data so it works for everyone and we’re planning to re-platform and improve the existing (commercial, operational and customer) data assets and develop new ones, as well as transform how we work with the business to use our data better.

We’re looking for a data engineer able to turn data into insights so they flow consistently across MO and shape our thinking to drive a culture of customer focused, evidence‑based decision making. You have the important task of automating and integrating multiple data systems, and developing business intelligence solutions for reliable, seamless reporting to serve multiple stakeholders.

You will be part of a team acting as the centralized function for creating data products to support reporting requests and strategic analyses, serving as the single source of truth across MO. Your work will underpin data integrity including developing, maintaining, and publishing commonly used terminology across MO. You will support teams who provide forecast and predictive models, develop customer segmentation, audience personas, and journey maps.

You innovate to go faster by providing tools and methods for the wider business to garner insights from our data warehouse and data lake. We work mainly on Oracle technologies hosted on AWS, with additional use of Snowflake and Postgres. Within the D&A team, the successful candidate would be:

• Designing, building, and maintaining a Data Warehouse and related applications.
• Analysing, developing, delivering, and managing business intelligence reports in OAS and other tools.
• Assisting in the design of the ETL process, including data quality, reconciliation, and testing.
• Contributing to technical process improvement initiatives.
• Supporting UAT processes by working with stakeholders to successfully sign‑off business requirements.
• Assisting in prioritisation and estimation of project work.
• Transform data into meaningful insights and recommendations.

• Experience of building a data warehouse using an ETL/ELT tool.
• Star schema/dimensional modelling.
• 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.
• Proficient in turning raw, structured and unstructured data into meaningful insights and recommendations.
• Efficient at handling large data sets in data platforms (such as Oracle, Snowflake), with mastery of SQL and Power BI. Additional Proficiency in Python or R is an asset.
• Experienced in delivering difficult and complex projects involving multiple teams – We’re looking for a lynchpin who isn’t afraid to get things done even when they don’t have formal authority over everyone who needs to be involved to make it work, and is able to build collaborative working relationships across organizational boundaries.

Plus points if you have experience working across multiple data sources. You have successfully created data products within Agile development teams and possess a good understanding of data science principles and practices. You also have the following attributes:

• Strong analytical and problem solving skills.
• Ability to make recommendations and take decisions.
• Effective time management and planning skills.
• Highly organised with excellent attention to detail.
• Able to perform well as a sole developer on a project and as part of a wider BI team within MO.
• Willingness to adapt to change.
• Ability to work to strict deadlines.

You also have excellent communication skills, are highly customer focused with the ability to work collaboratively. You are confident in dealing with all levels of staff.

• Proven Experience of Oracle ODI.
• Experience in Oracle.
• Familiarity with Snowflake.
• Experience of building Oracle OBIEE/OAS reports & dashboards.
• Experience with working on the cloud, preferably with AWS, including certifications.
• Familiarity with Apex.
• Data migration.
• Understanding of machine learning or data science, including python.

Motability Operations is a unique organisation, virtually one of a kind. We combine a strong sense of…