Accounts Administration Specialist (US Shifts) at Huntswood

Introduction

• We are seeking a detail-oriented and highly organized Accounts Administration Specialist to join our internal project team supporting a key client initiative. This role is critical in ensuring accurate financial reconciliations and maintaining compliance with company policies and regulatory standards. If you have strong analytical skills, advanced Excel proficiency, and thrive in a fast-paced environment, this is an excellent opportunity to contribute to a high-impact project.

Key Responsibilities

• Perform daily, weekly, and monthly reconciliations of bank accounts, supplier accounts, and other financial records.
• Ensure compliance with company policies, procedures, and regulatory requirements.
• Maintain and update reconciliation spreadsheets for multiple accounts.
• Utilize advanced Excel formulas (e.g., VLOOKUP, SUMIF, IF statements) to match transactions and identify discrepancies.
• Create pivot tables to summarize large volumes of financial data for reporting purposes.
• Conduct data validation to ensure accuracy and consistency in reconciliation reports.
• Generate charts and graphs in Excel to visualize reconciliation trends and variances.
• Automate repetitive reconciliation tasks using Excel macros where applicable.
• Consolidate data from multiple sources into a single workbook for monthly and quarterly reconciliations.
• Apply conditional formatting to highlight variances or outstanding items.
• Prepare and maintain audit-ready Excel files with clear documentation of reconciliations.
• Ensure proper version control and secure storage of Excel-based reconciliation reports.

Skills and Competencies

• Strong attention to detail and accuracy.
• Excellent analytical and problem-solving skills.
• Ability to work under pressure and meet deadlines.
• Good communication and interpersonal skills.
• Proficiency in Microsoft Excel (including Pivot Tables, Macros, and advanced formulas).

Experience/Background:

• Minimum 1 year exp in a similar role - Essential
• Fully proficient in MS Excel - Essential 
• Matric certificate (Grade 12) Complete - Essential