Deputise for the Senior ODA Delivery Manager as required. Deliver the agreed work programme of the Business Intelligence Team, in relation to service information including the development, documentation, implementation and maintenance of all relevant returns and all national and local data flows. Support other BI Leads with services supported by the Office of Data and Analytics within the scope of Business Intelligence. Have expert knowledge of NHS information standards and systems, including NHS Data Dictionary, Secondary User Service guidance and Patient Administration Systems. Have expert knowledge of operational services standards and be prepared to share that knowledge to facilitate taking a leading role. Allocate data analysis and reporting tasks to members of the Business Intelligence Team. Ensure routine work, information requests and products of the Office of Data and Analytics are prioritised and allocated accordingly. Allocate new reporting tasks to members of the Business Intelligence Team accordingly, producing good quality specifications where necessary to meet service users needs. Attend regular meetings with Divisional and Operational Services to determine information requirements and design specifications to meet those requirements whilst balancing the direction and strategic goals of the Office of Data and Analytics. Gather and analyse business requirements and translate business needs into technical development specifications. Support members of the Business Intelligence Team in all aspects of the production of analysis and information ensuring accurate and timely reports. Encourage effective team working and promote a reflective and learning culture where improvement is constant. Directly line-manage staff as necessary and undertake all aspects of recruitment, performance review and management including disciplinary and grievance procedures. Write complex data manipulation routines using relevant database query tools, linking multiple data tables, specifying output format and records to be retrieved. Ensure that the most appropriate and effective solution is provided, according to the specific requirements. Design and run programs making use of the more advanced data manipulation tools in Microsoft Excel/SQL Server (including formulae, pivot tables and macros), to convert complex raw data into the required format of information. Monitor processes to ensure information quality in accordance with NHS Standards and Definitions by checking that data has been recorded to the above standards. Provide cover when required for any other Business Intelligence Leads and Senior ODA Delivery Manager. Forge strong working relationships with members of the wider Office of Data and Analytics and communicate effectively with staff at all levels within the Trust and external stakeholders. Have advanced written, verbal and presentation skills to assimilate and relay highly complex, and often sensitive and contentious information to senior managers and clinical colleagues, often within large groups, where there are likely to be significant barriers to acceptance because of strong opposing views and resistance to change.