Information Analyst - VBA, SQL Coding - Coventry

Information Analyst - VBA, SQL Coding - Coventry

Square One are looking for an Information Analyst to come on baord for a initial one month contract with a view to extend another 6 months starting next Monday based in coventry

Role Objective:
The main objective of the Information Production Team is to transform data into valuable information, by producing quality, easy to use, predominantly Microsoft Office based outputs that enable users to understand and interpret the information contained, and take action to drive business change. This project role is to support the team in reviewing and updating their existing reporting outputs and redesigning these to build into a new workflow management system (Microsoft Dynamics)

Key Accountabilities:
Working to a prioritised list, review and understand existing reporting processes and protocols.
Assess these reporting processes in line with current business practice to identify potential conflicts.
Develop and design reporting process changes to ensure reports are stable and fit for purpose.
Working with colleagues, seek to streamline and systemise reporting processes using VBA and SQL coding to automate where appropriate.
Work with colleagues to standardise reporting outputs across business.
Create standard output designs that are intuitive, fit for purpose and easy for the user to consume.
Create and update Standard Operating Procedures.
Collaborate with Translation and Report Development teams to reduce the volume of manually produced business information.

Experience:
Essential:
Substantial experience of transforming data into valuable information.
Significant experience of designing and building reporting solutions.
Experience of understanding and evaluating business data flows.
Experience of working with Business Analyst in creating business information reports from documented business requirements.
Data warehouse/Data mart knowledge in relation to optimising report development

Desirable:
Experience/understanding of the Water Industry
Advanced data query tools user.

Capabilities:
High level skills with Microsoft Visual Basics Editor to develop reporting solutions in Excel.
Ability to use SQL programming to interrogate data systems
Passionate about, and motivated to transform data into valuable information that business information users find easy to use and interpret (ie they tell the story)
Eye for detail and completeness
An ability to communicate with other team members and colleagues raising questions
The ability to work with Translators and Report Developers to automate reporting, and specify need
Ability to manage own queue of work and deliver to production schedule.
Logical and structured approach

With interviews scheduled this week, and starting next Monday, this role is paying market rates and is expected to be extended another 6 months

Information Analyst - VBA, SQL Coding - Coventry