Accounts Data Analyst

Accounts Data Analyst

Position: Accounts Data Analyst

Level: Mid-Level

Location: Nairobi

Industry: HealthCare/Medical

Nationality: Kenyan

Age Group: 27 & above

Salary: 40,000 – 50,000 Gross

Reporting to the Head of Finance, The role holder will bridge the gap between day-to-day bookkeeping in Tally and high-level strategic reporting using Advanced Excel.

This role requires a methodical professional who can manage complex reconciliations, perform service-line profitability analysis, and maintain data integrity within a fast-paced hospital environment.

Academic & Professional Requirements

• Bachelor’s degree in Accounting (B.Com/BA) or a related field
  
• Professional accounting studies (CPA Part II/III or ACCA) advantageous.

Experience

• 3–5 years relevant experience; experience in hospital/healthcare accounting is an advantage.

Technical Skills

• Strong, demonstrable proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query desirable).
  
• Working knowledge of Tally (day-to-day bookkeeping and reporting).
  
• Good understanding of basic accounting principles, reconciliations and reporting.
  
• Attention to detail, analytical mindset and ability to present figures clearly to non-finance staff.

Responsibilities & Requirements

1. Financial Reporting & Data Modeling

• Design and maintain sophisticated Excel models for P&L analysis, cost-center reporting, and cash flow forecasting.
  
• Develop automated dashboards using Power Query and PivotTables to visualize KPIs for senior management.
  
• Analyze billing data, tariff structures, and service-line profitability to identify revenue leakage or growth opportunities.

2. Core Accounting & Ledger Management

• Execute daily and weekly accounting entries within Tally, ensuring all ledgers are accurately maintained and reconciled.
  
• Prepare comprehensive monthly management accounts, including detailed variance analysis and receivables reports.
  
• Facilitate month-end and year-end closing processes and provide technical support during external audits.

3. Operational Collaboration & Integrity

• Partner with clinical departments to gather operational data necessary for holistic financial assessments.
  
• Monitor data integrity across all financial platforms and ensure strict compliance with internal hospital controls and patient confidentiality.
  
• Support the billing team in revenue recognition and the follow-up of outstanding patient invoices.

Benefits: As per the company policy

Joining: Immediate