AgencyImage

Job Profile The selected individual will play a pivotal part in bringing Analytics to the business by developing both short term quick wins and be part of the long term roadmap of developing and integrating the function with colleagues at Motor Finance and across the bank. The role will be filled by an intelligent individual who thrives on using their technical skills to make a positive difference to the team and organisation as a whole. The data sources and analytics requirements are constantly evolving so the ability to use internal and external data in an agile way, together with various technologies, is essential. You will also be expected to support a high availability platform providing support for solution analysis, development, testing and deployment requirements. Responsibilities BI/Analytics Support with defining and documenting business/project requirements Design, develop and document ongoing changes to existing environment Testing development changes including team peer review, following deployment life cycle process from development and test through to production releases Help define, articulate and satisfy the analytic needs of Motor Finance and the wider bank Help the business understand trends across the markets, as well as those specific to Motor Finance to determine the biggest opportunities and threats and their potential impact Present findings and project status to a wide audience including higher level management and ensure high level of support is met Bring disparate data sets together to create repeatable models showing customer and dealer behaviour so that analysis can be an iterative and ongoing process Review and optimise reporting solutions for speed and performance Diagnose and fix issues associated with reporting solutions People/Business Establish and maintain excellent inter-departmental communications and relationships specifically with Sales, Marketing, Finance, Operations, Credit Risk and IT Understand business objectives/processes and identify opportunities to translate these in to BI/Analytical solutions Pro-actively coaching and learn from colleagues and business users on technologies and methodologies used for analysis Display a can do attitude to meeting stakeholder requirements, overcoming obstacles to delivery Have the drive and determination to be a self-directed learner Adapt communication style and approaches to articulate findings, business impacts and recommendations confidently and effectively to senior management/stakeholders Ensure that all governance and compliance requirements are adhered to and all reporting and reviewing activities required by the regulatory bodies are carried out to the standards required Carry out all duties in line with the Companys values of: Teamwork, Expertise, Service Excellence, Valuing People, Empowerment and Recognition Skills and Experience Essential Experience working in a BI/Analytics environment in a development and support capacity A good understanding of how to query data from relational databases using SQL Experienced in the extraction and manipulation of data A high level of creativity, drive, innovation and initiative; a self-starter with a constant desire to learn Ability to work well within a team environment, building effective relationships with key stakeholders in the business Proven ability to work without the need for close supervision, showing excellent time management, planning and organisational skills, delivering to agreed timescales A natural ability to work quickly, with a high level of attention to detail and accuracy, providing a highly analytical approach to problem solving Appreciation/experience of embedding data visualisation in businesses Desirable Understanding of Kimball methodology and data warehouse architectures Experience designing and developing data models, star schemas, dimension and fact models and slowly changing dimensions Technical/database skills including Oracle Discoverer, TOAD, Access, Business Objects CMC, IDT, Universe design, Web Intelligence, Xcelsisus dashboards, Alteryx, Tableau, Lumira Experienced and competent in the use of statistical packages (eg SAS, SPSS, R, Matlab) to build models Previous experience working with sales/marketing analytics Motor Finance domain knowledge Education Essential A good degree in a numerate subject with knowledge of statistical and analytical techniques Desirable Postgraduate qualification in a relevant subject eg computer science, statistics, economics