Data & Analytics Senior Developer Morson are recruiting for a Data & Analytics Senior Developer to join our client in London, England. Key Accountabilities *To undertake the maintenance of existing and development of new data and analytics solutions to ensure the optimal production of operational dash boarding, reporting and other applications in line with the strategy set by the Chief Data Officer *To develop data and analytics solutions using industry best practice so that the code delivered is running, meets business requirements and definitions, conforms to Data & Analytics design specifications and have the controls and checks in place to satisfy audit/finance guidelines. *To document the technical design of developed components in accordance with Data & Analytics standards *To develop to estimated timelines or update management of deviations to these estimates. To raise critical technical issues to the Development Stream Lead/Technical Delivery Manager that may impact on the timeline. *Working with their scrum agile team members, to undertake and support unit and regression testing of the codebase to ensure it can be delivered and meets business/operational requirements and can be run in a system testing environment. 6) To undertake fixes to the code, where necessary. To undertake performance tuning of where required. *To participate and contribute fully in quality assurance design walk-throughs of developed technical components with colleagues in the Analytics Development and Delivery team. When faced with business scenarios which do not fit a standard approach, to collaboratively work through each issue with peers to ensure that the solution meets business/operational requirements and the principles of best practice. *To ensure that TfLs policy on privacy and data protection is adhered to in the design of all solutions and that access to data is controlled, personal data is stored securely and is anonymised in accordance with best practice guidelines. *To provide, where appropriate, user access to Technology & Data information and to give advice on information and databases, including training and familiarisation with revenue collection and other performance, operational or customer experience data. Knowledge *Detailed working knowledge of ETL/ELT, data warehousing/business intelligence methodologies and best practice including dealing with big data, cloud technology and unstructured data and the relative required approaches *Knowledge of star schema structure & design, detailed understanding of Kimball & Inmon and hybrid data warehouse design *Understanding and experience of Agile development approach and tools *A degree in a relevant technology/computer science subject/equivalent technical qualification plus sound on the job experience of the platform specialism *Familiar with the variety of SDLC concepts and approaches *Knowledge and interest in the latest and emerging technologies likely to be employed in designing and delivering Enterprise Wide quality solutions in the chosen platform Skills *Extensive use of and fully conversant with on premise, cloud based or hybrid Oracle and/or Microsoft database technologies in particular ETL/ELT design, development and testing in Microsoft SQL Server 2008 onwards , TSQL, APS, Azure, SSIS and/or Oracle 11g/RAC SQL, PL/SQL, ODI and OBIEE. *Expert at writing/reading complex queries, performance tuning & monitoring *Skilled at solving and communicating problems collaboratively, applying knowledge and technology to the full *Strong analytical skills *Communicates all needs, instructions and decisions clearly. Adapts the style of communication to meet the needs of the audience. Checks for understanding *Proficient at use of standard computer packages *Excellent writing style including translating technical information into â€plain English Experience *Has recent experience as a business intelligence developer working in a large scale data warehouse system within the data and analytics industry *Recent experience in the latest techniques and methodologies in delivering quality solutions *Experienced in large enterprise business /data warehouse implementations *Experience of operating in a dynamic working environment, handling multiple tasks and deadlines, delivering to time, budget, and quality If you are interested and have relevant qualifications and experience, apply now and I will be in touch with you shortly. Alternatively, contact Connah OKeeffe at Morson International for more information about this position.