Data Analyst / Reports Analyst – VBA, SQL, Crystal Reports, Business Objects. Based in Huddersfield, West Yorkshire my client is looking for a Data Analyst / Reports Analyst.

You must have the following:
• Advanced VBA skills to be able to create and modify VBA code that can
• Open and retrieve data from Excel workbooks
• Compare and manipulate data held on different worksheets or workbooks
• Automate the starting and control of Office applications
• Automate the starting and control of other applications where possible
• Knowledge of Relational Database structures and SQL
• Chart creation
• A proven understanding and track record of one or more of the following is essential:
• SQL
• Crystal reports
• Business Objects (v6.5 or above)
• Business Objects Designer Client
• Database management/ administration

Role involves:
• Responsible for automating new and existing reporting solutions where suitable
• Responsible for providing design input for in-house developed reporting applications and solutions
• Responsible for collaborating with Customer Account Managers/Service Delivery Managers and stakeholders to develop and agree requirements
• Responsible for producing code to required standards
• Responsible for producing system documentation relating to in-house developed solutions
• Responsible for conducting feasibility studies and prototyping to establish proof of concept
• Responsible for undertaking systems analysis in order to develop a detailed understanding of reporting and business processes
• Responsible for collaborating with business colleagues to produce and review requirement documentation
• Responsible for undertaking prototyping using available software to help refine requirements and developing emerging design ideas
• Responsible for undertaking reporting design activities to include:
• Design of automation software for data collection
• Design of software for data manipulation
• Design of software for report production
• Design of bespoke Functions for use in Excel
• Design of graphics user interface
• Document code and procedures as required
• Responsible for designing report schemas as required
• Responsible for documenting reports as required
• Responsible for produce entity relationship diagrams of report data sources as required
• Responsible for collaborating with other staff throughout the organisation to establish report requirements
• Responsible for collaborating with other staff throughout the organisation to advise and produce report designs
• Responsible for making recommendations to senior staff regarding reporting developments
• Responsible for designing, planning and assisting with data migration as required
• Responsible for monitoring database performance with regards to reporting and making recommendations as required
• Responsible for producing installers and deployment methods for reporting solutions as required

Please send your CV ASAP and I will get back to you!
Location: Huddersfield, West Yorkshire
Start: ASAP
Duration: 2 Months
Salary: £326pd
Agency:LATCOM
Contact:Steve Spevack
Telephone:01442 291 800
Email: Steve.Spevack@Latcom.co.uk

Advertisements