Apple Recruitment are recruiting for Lead Technical Data Specialist (Band 7)on behalf of our client, Northern Ireland Ambulance Service (NIAS), to work on a temporary basis in the Belfast area. Main duties and responsibilities: Develop and EDWs infrastructure Consolidate andoptimiseavailable EDWs infrastructure. Conceive analytics and business intelligence platform architecture for users, including internal and external stakeholders. Design and implement ETL procedures for intake of data from both internal and outside sources; as well as ensure data is verified and quality is checked. Design and implement ETL processes and data architecture to ensure proper functioning of analytics lead, as well as the Trusts or third-partys reporting environments and dashboard. Collaborate with business and technology stakeholders in ensuring EDWs architecture development andutilisation. Carry out monitoring, tuning, and database performance analysis Perform the design and extension of data marts, meta data, and data models Ensure all EDWs architecture codes are maintained in a version control system. DevelopandadvancetheabilityoftheTrusttoaccess businessintelligencesolutionsforthe continued improvement of service delivery to patients and clients. GainanunderstandingoftheunderlyingdatabasestructuresofTrustsystemsparticularly the modern systems with complex datasets.Work with System Managers and Service Managers to understand the linkages between database structures and the identified EDWs requirements (including those required for monitoring data quality). Developandimplementpolicies,procedures,standardsandguidance tosupportthe management of the EDWs. Producehighqualitydocumentationandensuretheyarekeptuptodate. Designandproducethoroughanddetailedtestplansandscriptswhichareadoptedpriorto the release of new and / or updated software. Workingalongsideotherdevelopersanddataincarryingout testing activities. BeresponsiblefortroubleshootingEDWs,databases,andsoftware. Be proactive in suggesting improvements and amendments to existing BI products, tools, databasestructures,queries,reports,etc.andresponsible forimplementinganychanges AssisttheTrustandRegionaldatawarehouseteams withupgradesandenhancementsof the data warehouse. Delivertechnicaltutoring&trainingtoothermembersof thedevelopmentteam. Communicatecomplexideastolayaudiencesatalllevels. Identifytheskillsrequiredtoprovideahighquality BusinessIntelligence servicewithinthe team and wider Trust area, making recommendations on the fulfilment of these needs. Employtheprinciplesofgoodinformationgovernanceensuringdatasecurityismaintained, as outlined in the Trusts ICT Security Policy. Communicateeffectivelyatalllevels,includingwithsystemsuppliersandregionalgroupson technical data related issues. If you wish to apply or would like more information, please email your CV in Microsoft word format toCaroline Parkerby clicking on the link below by Friday 22nd November 2024. You must also include a bullet pointed synopsis at the top of your CV demonstrating how exactly you meet the Essential Criteria below: 1a.) A university degree or relevant professional qualification in an analytical related field, including information technology, science, and engineering discipline and worked for at least 2 years in a senior role performing data warehouse architecture development and management. OR 1b.) Have at least 5 years experience working in a senior role* developing databases, codes, testing for quality assurance, administering RDBMS, and monitoring of databases. In addition applicants must provide evidence of continual professional improvement plus have experience of delivering against challenging performance objectives, meeting key targets and making significant improvements. 2.) Essential skills and knowledge: Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel Ability to analyse and present complex information in a meaningful way In depth and thorough specialist knowledge of the following Business Intelligence technologies: -MS SQL Server -MS SSIS -MS SSAS -MS SSRS Knowledge of practical uses of software packages, operating systems and communication technologies. Knowledge of development methodologies such as Agile. High level interpersonal and verbal communication skills High level people management and organisational skills Awareness of the Health & Social Care (HSC) organisation and Business Intelligence function Knowledge of Project Management methodologies Data Analytics Tools and Techniques 3.) Hold a current full driving license which is valid for use in the UK and have access to a car on appointment. This criteria will be waived in the case of applicants whose disability prohibits driving but who have access to a form of transport approved by the Trust which will permit them to carry out the duties of the post. Further Details: Hourly Rate: £22.37 Hours: 37.5 hours pw Duration: 6 months (with possibility of extension) If you wish to apply or would like more information, please email your CV in Microsoft word format toCaroline Parkerby clicking on the link below by Friday 22nd November 2024. Applicants must ensure their CV is accurate and up to date. The CV should include your full employment history inclusive of dates, all academic achievements and full personal contact details. Please note only applicants that match this criteria can be considered for the role. Apple Recruitment Services is acting as an Employment Agency in relation to this vacancy. Apple Recruitment Services is an Equal Opportunities Employer.