Senior Database and Analytics Developer

To mentor and coach any Database and Analytics Development officers (career grade) within the team, acting as the main contact for any training companies in the officer’s development., * To be recognised as the specialist in corporate database storage solutions design, creating policy, processes and revising as necessary. Define and maintain the data technology architecture, including metadata, integration and business intelligence or data warehouse architecture.

• Design and implement complex data flows to connect operational systems, data for analytics and business intelligence (BI) systems.
• To manage provision of support, training and problem solving to the core users of the corporate data storage solutions. Work within the organisation to minimise data risks and increase data literacy.
• Work closely with stakeholders to clarify changing business requirements. Identify, recommend and support the development and delivery of improvements.
• To analyse Service requirements and develop corporate data storage solutions / integrations from in-house and third party disparate data sources/systems to solve problems.
• To facilitate the development of corporate business intelligence systems from in-house and third party disparate data sources/systems (to include Oracle, SQL Server, Access) by trained Super Users.

Substantial relevant experience of working in the service area / profession, with evidence of appropriate specialist knowledge of relevant systems, policies, regulations, professional guidelines and legislation.

Substantial demonstrable experience in the design, development, and maintenance of reports.

Substantial, demonstrable experience managing Relational Database Management Systems. For example Microsoft SQL Server, Oracle Database, Microsoft Access.

Substantial demonstrable experience of technical administration of corporate business intelligence systems and associated data storage solutions.

Authoritative knowledge of the specialist work practices, systems, policies, procedures and professional guidelines relevant to the work area.

Authoritative knowledge in relational theory and manipulation and security of non-relational data sources.

Relevant experience within a large organisation, delivering similar services, with evidence of specialist knowledge and work responsibilities appropriate to the role.

Excellent communication and interpersonal skills with the ability to engage effectively with a range of audiences and explain specialist information in a way which a non-specialist can understand.

Good record keeping, report writing and presentational skills.

Good planning and organisational skills, with proven ability to prioritise and co-ordinate workloads, monitor and evaluate work, to ensure standards, outcomes and deadlines are achieved.

Proven initiative and judgement to identify and resolve problems.

Experience of successfully undertaking business intelligence solution and reporting error troubleshooting.

Able to demonstrate ability to prioritise, coordinate, and respond to incidents, problems, and event resolutions.

Knowledge of the OSI 7-layer Model.

Excellent ICT skills - including use of Microsoft applications and specialist systems which support procedures and record keeping.

Knowledge and experience of contributing to the development of policies, procedures and practices.