Description5 Months Fixed Term ContractThe D&BI 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 applicationsWriting, testing and peer review of ETL code in Oracle ODIWorking with business users to design and configure self-serve data environments within our snowflake data lakeAnalysing, developing, delivering, and managing BI reportsAssisting in the design of the data processes, including data quality, reconciliation, testing, and governanceContributing to technical process improvement initiativesReleasing and supporting software through environments including production support and working with stakeholders to sign-off business requirements in UATAssisting in prioritisation and estimationQualificationsIn addition to a candidate who is technically very strong, we are also seeking:CommunicationAbility to interact with Business users in a professional mannerAbility to communicate directly with peers and customers remotely or face-to-faceExcellent presentation skillsHighly customer focused with a drive to work collaborativelyHigh PerformerStrong analytical and problem solving skillsAbility to make recommendations and take decisionsHighly organised with effective time management and planning skillsExcellent attention to detailAble to perform well as a sole developer on a project and as part of a wider BI team within the organizationWillingness to adapt to changeAbility to work to deadlinesEnjoys technical challenges and learning new skillsWillingness to take part in overnight support rotaMinimum CriteriaYou'll need all of these.Experience of building a data warehouse using an ETL/ELT tool, preferably Oracle ODISignificant database experience in Snowflake or OracleStar schema/dimensional modelling.Excellent SQL skillsGood knowledge of standard data formats (XML, JSON, csv, etc)Proven experience of delivering BI solutions for business requirementsExperience of developing using an Agile development approachProven experience working in a cloud environmentDesirableProven Experience of Oracle ODI / OASExperience 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.Who you'll be working withThis role would be to join the data portion of the Customer team, where we work across the business to digitise and improve interactions with our customers and business partners. This could be data transfer from third parties, ETL into the data warehouse or data lake, providing insights and metrics, or improving performance or processes.This is a dynamic team, with data engineers and analysts working closely alongside members of the business in an agile way to deliver quick, innovative value. This role would be one of five within the Customer area, while the wider D&BI team has around 30, allowing team members significant opportunity for training and movement within the team.BenefitsMotability 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 815,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 solutionsWe drive changeWe careWe 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 bonus15% non-contributory pension (9% non-contributory pension during probation period)28 days annual leave with option to purchase and sell daysFree fresh fruit and snacks in the office1 day for volunteeringFunded Private Medical Insurance coverElectric/Hybrid Car Salary Sacrifice Scheme and Cycle to Work SchemeLife assurance at 4 times your basic salary to give you a peace of mind that your loved ones will receive some financial helpFunded health screening for over 50sVoluntary benefits: charitable giving, critical illness insurance, dental insurance, health and cancer screenings for you and your partner, discounted gym memberships and season ticket loansEmployee Discount Scheme with an app to save on the goFree access to healthcare apps such as Peppy, Unmind, Aviva Digital GP and volunteering app on Hand for all employeesGenerous family leave policiesAt 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.TPBN1_UKTJ
