Please answer the following questions in order to process your application.
Select your working status in the UK *
File Attachments:
(2MB file maximum. doc, docx, pdf, rtf or txt files only)
* denotes required field
Additional Information:
Availability/Notice
Hourly Rate GBP
Approximately how far are you willing to travel to work (in miles) ?
Key Privacy Information
When you apply for a job, ComputerWork will collect the information you provide in the application and disclose it to the advertiser of the job.
If the advertiser wishes to contact you they have agreed to use your information following data protection law.
ComputerWork will keep a copy of the application for 90 days.
More information about our Privacy Policy.
Job Details
Contract Database Analyst (Contract)
Location: Guildford, Surrey Country: UK Rate: OUTSIDE IR35 - FULL REMOTE WORKING
Spectrum IT's Guildford based client are actively seeking a Contract Database Analyst to join them on an initial 8 week contract. This is an OUTSIDE IR35 role with remote working and occasional office visits to Guildford, Surrey.
As the Contract Database Analyst you will play a key role in the supporting, testing and maintaining business system reports. You will have excellent experience with SQL Server and creating SQL insert/select/update statements with large databases. Experience with Visual Studio 2017+ and Crystal Reports will be key.
Responsibilities
- Support users both directly and via the Service Desk in relation to various business systems.
- Liaise with IT colleagues and/or third-party suppliers in order to resolve technical issues.
- Support, test, and maintain business system reports, making the best use of available technology to fully exploit each application.
- Design and support system/data integration and import/export routines between systems (on premise and cloud-based).
- Promote and sustain a constructive, supportive and friendly working relationship with all customers, external and internal, immediate and senior management and other work colleagues.
- Work on Business Change Projects and internal IT projects, liaising with the Business Systems Developers and where applicable other departments in the production of functional specifications.
- Producing Technical Specifications.
- Work on Business Change Projects and internal IT projects, liaising with the Business Systems Analysts and where applicable other departments in the production of functional and technical specifications.
- Ensure data accuracy and consistency between systems including but not limited to: checking data validation routines are in place both on data input and ongoing checks, ensuring data duplication routines are in place across systems and creating data cleansing routines are in place where required
- Provide an audit of data issues and resolutions
- Data Migration
- Create ad-hoc data migration scripts
- Maintain Scribe data integrations to migrate data from one system to another
- Systems Integration
- Create ad-hoc Integration scripts
- Maintain Scribe data integrations to migrate data from one system to another
Experience/Skills
- Experience in relational database architecture and design
- Proficient in SQL - able to write complex select/insert/update scripts
- Crystal Reports or Microsoft Reporting Services
- Proficient Microsoft applications user
- SQL Server - able to create SQL insert/select/update statements with large databases
- Experience with Ellucian Banner ERP and reports HIGHLY DESIRABLE
- Visual Studio 2017+
- Crystal Reports
- Knowledge of BASIC programming syntaxes, (eg. VBA, JavaScript beneficial)
- Business Processing mapping experience beneficial
- Experience writing Mark-up Language code from a BASIC language (HTML from JavaScript, PDF from VBA)
- Ability to manage personal and team workloads effectively
- The ability to pick up and utilise new technologies or systems with minimal intervention
For more information and to submit your interest, please apply with an updated CV.
Spectrum IT Recruitment (South) Limited is acting as an Employment Business in relation to this vacancy.
Posted Date: 22 Mar 2024
Reference: JS-BBBH16580
Employment Business: Spectrum IT Recruitment (South) Ltd
Contact: Aaron Giles