Warning
This job advert has expired and applications have closed.
Reports Analyst (IT Business Analyst)
| Posting date: | 12 February 2025 |
|---|---|
| Salary: | £25,152 to £35,149 per year |
| Hours: | Full time |
| Closing date: | 14 March 2025 |
| Location: | Swindon, Wiltshire |
| Remote working: | Fully remote |
| Company: | Pioneer Consultancy Services UK Limited |
| Job type: | Permanent |
| Job reference: | PCSRA0225 |
Summary
Position : Reports Analyst (IT Business Analyst)
Vacancies : 2
Job type : Permanent
Work Hours: Monday – Friday Full-Time (37.5 hours per week)
Salary : £25,152-£35,149 / Per Year
Job Ad Posting Date : 12/02/2025
Job Ad Closing Date : 14/03/2025
Job Ad Reference : PCSRA0225
Job Work Location : Swindon (SN2)
Skills Required:
- Microsoft Visio
- Microsoft - SQL Server
- Microsoft Office (Excel,PowerPoint,Word,Visio,Outlook)
- Hands on skills on Microsoft Excel VLOOKUPs/Data Graphs
- Querying database results by SQL
- Operating knowledge of Unix / Linux for file transfers (FTP/SFTP)
- Knowledge of AWS Cloud
- Microsoft - Project Planning
- SQL Loader
- Knowledge of ETL
- JIRA / Confluence/Bugzilla
Responsibilities:
- Comparing reports data from legacy systems to newly migrating systems
- Performing BAT & UAT
- Expert in using Microsoft Excel with VLOOKUps and compare the reports data
- Able to query the data from databases systems mainly SQL Server & Oracle databases
- Writing UAT test cases and executing UAT test scenarios
- Participating in change control meetings
- Verify the Business Intelligence reports and their data calculations
- Verify the Business Intelligence reports in Power BI and Excel dash board reports
- Performing UAT in QA,PreProd & Prod Environments
- Assist in the design, development, implementation, and ongoing support of existing reports and changes in the reports
- Liasoning with other customer busienss departments like Sales teams and HR teams
- Gathering and analysing customer new reports requirements
- Writing customer and functional / technical specifications
- Meeting the clients for technical discussions
- Ability to work under pressure
- Data analysis using Microsoft Excel
- working knowledge of Agile environment
- Working knowledge of Microsoft Project
- Exposure of Data visualizations tools like QlikView,Tableu,
- Good interpersonal and organisational skills
- Good client facing skills
Databases:
Microsoft - SQL Server
Oracle
MySQL
Educational Qualification:
Bachelors degree or above
If you are interested, Please apply on or before 14/03/2025