About The Role
b12 Months Fixed Term Contract
The D&BI team works on allowing integration, transformation and visualisation throughout MO, allowing the organisation to maximise on the power of its data.
- 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 or dbt
- Working with business users to design and configure self serve data environments within our snowflake data lake
- 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 in UAT
- Analysing, developing, delivering, and managing BI reports
- 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 organisation
- 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
- 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
- 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
- Competitive reward package including an annual discretionary bonus
- 15% non contributory pension (9% 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
- 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