Selections Analyst - Faststats - Charity Sector

Asset Resourcing
United Kingdom
11 Jan 2018
11 Feb 2018
Contract Type
Full Time
Selections Analyst - Faststats: Reporting to this charity's Data Services Manager, the overall purpose of this job is 1) to support communication activity by devising and extracting accurate data selections from their customer relationship management systems to meet the needs of teams throughout the organisation AND 2) to enable them to develop maximum potential from its customer base and communications strategy, while following best practice, data protection, organisational guidelines, and respecting people's communication and marketing preferences. EXPECTED EXPERIENCE: *Data analysis geared at data modelling and cleansing to improve mailing selections *Apteco FastStats, using Discoverer and Cascade to deliver data selections *Querying SQL Server using t-SQL *Requirements gathering and communication with stakeholders *MS Office (Word, Excel VBA & PowerPoint) *Fundraising databases specific to the charity sector MAIN DUTIES AND RESPONSIBILITIES: *Deliver regular selections for communication ensuring business processes are being followed across the organisation and selections are on time. *Create new selections in FastStats, following established business rules and instructions from project leads. *Support development of FastStats to facilitate supporter journeys and automation. *Perform quality checks on selections, reports, and exports to ensure exceptional quality. *Log all communications and proactively identify occasions of over-communication. *Ensure that work is scheduled, deadlines met and communication business rules adhered to. *Review all data requests in a timely fashion and ensure that they meet business requirements. *Play an active part in acceptance testing of the data selection tools and related aspects of new releases of the customer database. *Manage, schedule, and produce data request deliverables within service level agreement deadlines. *Ensure compliance of development standards and conventions in all work. *Ensure all data selected for communicating with contacts and organisations is accurate and compliant with data protection policy and law, as well as the communication instructions of contacts. *Create and maintain technical documentation for all work to agreed quality standards. *Gather and document business requirements via surveys, workshops, and interviews. Facilitate, minute, action, time keep all related meetings. Analyse and design bespoke solutions. *Use initiative and expertise to identify areas of poor data quality on the customer database, notify relevant staff, make recommendations and work with IT and staff to resolve. *Liaise with users to ensure the work meets business needs. *Report on progress/issues to management and users. *Undertake other work as might reasonably be required by the Data Services Manager. *Manage the analysis, design, implementation, testing, and support of data extracts. PERSON SPECIFICATION: *Learn quickly and independently; specifically around business rules and database structures *Manage conflicting priorities and workload *Identify areas of improvement to drive forward improvements *Advise colleagues on selection matters *Effectively manage working relationships