Data Entry Analyst

About Us:
We are a leading technology solutions provider, committed to delivering innovative and efficient services to our clients. We pride ourselves on our outstanding growth and excellence in the industry, recognised by multiple prestigious awards. Join our dynamic team and contribute to our continued success.

Job Description:
We are seeking a meticulous and detail-oriented Data Entry Analyst to join our team. The successful candidate will be responsible for extracting timesheet data, enter it into Excel spreadsheets and utilise advanced Microsoft Excel skills to analyse the data and generate reports.

Key Responsibilities:
• Access shared email inboxes to review timesheets submitted by staff
• Review timesheets that are received in various different formats
• Accurately and reliably extract data from timesheets and enter into excel spreadsheets
• Review data entered into excel to identify mistakes, including through aggregated functions such as pivot tables
• Use Microsoft Excel to create, export, and analyse reports.
• Develop and maintain complex Excel spreadsheets, including the creation of pivot tables, VLOOKUPs, and other advanced functions.
• Identify trends and patterns in data to provide actionable insights.
• Ensure data integrity and accuracy through regular audits and checks.
• Collaborate with other departments to support data-related tasks and projects.
• Assist in the preparation of reports and presentations for management.

Qualifications:
• Proven experience as a Data Entry Analyst or similar role.
• Advanced Microsoft Excel skills, including:
o Creating pivot tables and pivot charts.
o Using VLOOKUP, HLOOKUP, INDEX MATCH, SUMIFS, COUNTIF, and other functions.
o Conditional formatting and data validation.
o Understanding of Power Query and Power Pivot (preferred).
• Exceptionally high attention to detail and accuracy.
• Excellent analytical and problem-solving skills.
• Ability to manage multiple tasks and meet deadlines.
• Strong communication and teamwork skills.

Please note that if you are shortlisted for this position, you will be required to undertake a test to demonstrate your skills and ability.