PART 1:JOB PROFILE

DIRECTORATE:Corporate Services

TEAM:Information Systems

JOB TITLE:Business Systems Data Analyst

LAST UPDATED:15th May 2015

  1. MAIN PURPOSE OF JOB

Design, support and maintain an appropriate data architecture for the organisation’s business systems and reporting needs which ensures single points of truth, integrity of data and ease of access to information through the organisation’s chosen management information systems.

  1. POSITION IN ORGANISATION
  • Reports into: Business Systems Manager
  • Line Manages: n/a
  • Liaises with:Staff and volunteers at all levels within Samaritans Central Charity, the wider organisation, and external partners/suppliers
  • Works within a team of:10 (4 in the Business Systems function)
  1. SCOPE OF JOB
  • Configuration, administration and development of management information systems
  • Maintenance & support of management information systems
  • Continual improvement of management information systems
  • General duties of an IS team member
  • General duties of a Samaritans’ staff member
  1. DIMENSIONS AND LIMITS OF AUTHORITY
  • The SME for QlikView and dependent systems
  • The SME for dashboards and reporting in the Salesforce platform
  • Support the Business Systems Analyst as the SME for Salesforce
  1. QUALIFICATIONS
  • A computer-related university degree would be a significant advantage as would Microsoft or other recognised certification and membership to industry bodies (e.g. BCS).
  • Salesforce ADM201/ADM301 certification would be advantageous
  • QlikView Designer, Developer and/or Systems Administrator would be advantageous
  • Microsoft Technology Associate (MTA) Database, Microsoft Certified Solutions Associate for SQL Server certification or similar would be advantageous
  1. SKILLS, KNOWLEDGE AND EXPERIENCE

The successful candidate will be able to demonstrate current experience developing and maintaining data architectures which support the organisations management information needs and strategic objectives.

Previous experience should include the following:

  • Experience of pulling data from various different sources and designing reporting structures for business analysis and problem solving
  • Experience in using data modelling tools
  • Experience of using reporting tools such as Salesforce and QlikView (reports, dashboards and setting up appropriate folder structures)
  • Experience of working with any of the following would be advantageous: SPSS, Cognos, Crystal Reports, SQL Server, SSIS.
  • Good knowledge of the logic and structure of relational databases
  • SQL Server and T-SQL experience querying and manipulating data
  • Experience analysing information and creating data mining solutions using Microsoft Reporting Services and Microsoft Excel. Experience of QlikView would be an advantage
  • Document writing (both technical and end user)
  • Experience using source code control software (preferably git)

Skills

  • Able to design and implement data processes
  • Analytical mindset, ability to see the big picture and convey to others
  • Detail-orientated with good problem solving skills
  • Good organisational skills and ability to prioritise workloads
  • Good written and verbal communication skills and experience of cross-departmental working
  • Able to anticipate customers’ needs
  • An awareness of data protection issues
  • Skills such as logical data modelling, physical data modelling, data policies development, data strategy, data warehousing, data querying languages would be advantageous.
  • Able to appreciate the values of merging disparate data sources to enhance organisational MI capability.
  1. PERSONAL ATTRIBUTES
  • Able to work with minimal supervision
  • Self-motivated and can motivate others
  • Ability to prioritise workload and work well under pressure to meet deadlines and manage business expectations
  • Good interpersonal, communication and presentation skills with the ability to present complex ideas to technical and non-technical audiences
  • Able to think creatively and present solutions to problems together with their benefits and drawbacks
  • Positive, proactive approach
  • Good team worker
  • Passionate about problem solving, continuous improvement and customer service
  • Good attention to detail and checks quality of own and other’s work.

PART 2: DUTIES & KEY RESPONSIBILITIES

Configuration, administration and development of management information systems

  • Shape the structure and appropriate storage of information in a variety of systems so that data can be effectively retrieved by users at all levels.
  • Design, create, deploy and manage a data architecture for the organisation using tools such as QlikView, Salesforce and SPSS.
  • Oversee data management and database optimisation
  • Create reports and dashboards and set up appropriate folder structures to meet organisational needs.

Maintenance & support of management information systems

  • Act as SME for QlikView and Salesforce reporting.
  • Create documentation such as process guides, policy documents, configuration standards, change logs and help related materials for users
  • Set and monitor standards for data management within the organisation. Ensure that the organisation’s data assets are kept in line with any set standards and defined data architecture.
  • Help and train users to develop and create reports and dashboards
  • Share business and system knowledge and information

Continual improvement of management information systems

  • Translate data requirements, turning them into appropriate data models and data system developments.
  • Act as a bridge between systems developers and consumers of the data
  • Work with project teams, informing and advising appropriate data structures in line with the data strategy and to meet business and organisational needs
  • Act as the authority and sign-off for data models and storage ensuring that they are optimised to inform all reporting outputs.
  • Develop an understanding of the organisation’s needs for data, producing data model designs that meet business and operational requirements.
  • Review whether a metadata registry and organisational dictionary would be advantageous to the organisation. If appropriate, set up and maintain.
  • Analyse data quality, manage data quality issues, escalating where appropriate and recommending solutions.
  • Work with stakeholders (business and IT) to facilitate the design and execution of an organisational data strategy.
  • Work with and support the IS team to create a systems strategy and roadmap.
  • Map systems and interfaces used to manage data within the organisation. Carry out analysis of current state and provide concepts of desired future state, identifying projects needed to close the gap between the two.
  • Analyse the impacts of any proposed functional system enhancements.
  • Manage the relationship with implementation and support partners for specific development pieces of work.
  • Work closely with Evidence, Data Protection and Operational Data teams to ensure that needs are met.

General duties of an IS team member

  • Contribute to the efficient running of the IS team
  • Attend IS team meetings
  • Provide support and assistance to other members of the IS team as requested by the Head of Information Systems
  • Investigate and implement best practice with regards to data processes and improvement
  • Keep abreast of technology developments both within and outside of Samaritans’ industry through creating a network of colleagues and attending industry / technology seminars as appropriate to help Samaritans deliver and maintain competitive advantage

General duties of a Samaritans’ staff member

  • Contribute to the effective and efficient running of the General Office as appropriate
  • Participate, as appropriate, in staff forums and meetings
  • Adhere to all Samaritans’ policies and procedures
  • Represent the General Office appropriately across Samaritans to the wider community as appropriate
  • Treat all colleagues, volunteers and members of the public with dignity and work within and adhere to Samaritans’ equal opportunities statement and policies
  • Carry out any reasonable requests made that are with the broad remit of the role

Signed by employee:______Date: ______

This job description is a statement of requirements at the time of writing and is not contractual. It should not be seen as precluding future changes after appointment to this role. When the job description is updated please a signed and electronic copy to HR.