Billing and Data Analyst

Posting Description:
**Billing and Data Analyst**

Experienced in working within the Short-Term Insurance Industry? Proven experience as a data analyst? Read on

Aon South Africa is hiring a Billing and Data Analyst within its Employee Benefits & Healthcare department. This is a hybrid role with the flexibility to work both virtually and from our head office in Sandton.

**Aon is in the business of better decisions**

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are united through trust as one inclusive team, and we are passionate about helping our colleagues and clients succeed.

**What the day will look like**
- Responsible for system and process management related to all applicable tasks.
- Work on projects with the current senior data analyst
- To monitor and maintain the monthly medical scheme commissions and recon the accounts. Interpret data, analyze results using statistical techniques and provide ongoing reports.
- To implement processes to effectively manage and report on new and lost business. Aon Access to develop and implement data collection and other strategies that optimize statistical efficiency and data quality.
- To assist with the monthly forecasts and budget recons, sales tracker report, acquire data from primary or secondary data source and /data system accuracy
- To manage the monthly client splits, client database and client numbers nationally. Acquire data from primary or secondary data source and data system accuracy.
- To maintain Healthcare financial information on the Company shared drive. (At all times must be up to date.)
- Co-ordination of TimeSys and submitting monthly report on time to BUH - To identify, analyze and interpret trends or patterns in complex data sets.
- Filter and “clean” data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
- To deliver monthly statistical reports for all super group accounts,
- ensure data is filtered and refined. Additionally, analyze digital reports, printouts, and performance indicators to identify and rectify coding issues, and help with monthly billing for super group accounts.
- Business Systems management and administration. Work closely with management to prioritize business and information needs.
- Aon CRM reports and administration - Work closely with management to prioritize business and information needs.
- Aon Medical Scheme Analysis and Clients Needs Tool - Locate and define new process improvement opportunities
- House view data maintenance, filter, clean and update reports and save on company shared drive. (E-drive)
- Assist all internal staff on medical scheme and gap cover - reviews, benefit and rate comparisons, queries, with efficiency, data quality and have the ability to prioritize.
- Maintaining the data saved on the shared drive (E-drive)
- Broker Profile Reports - Monthly and Quarterly Full Profile Reports. To request relevant information in time to analyses and deliver accurate data on or before deadlines.
- MS Financials Spreadsheet - Done by Mid of May - End June of every year. Acquire data from primary or secondary data sources and provide quality and accurate data. No secondary checking of data by anyone of the internal team. (full accountability)
- Year-end revision
- Broker profile reports
- Aon Access communication
- Calculators
- Aon Access updates all Medical Scheme data benefits and Increases (can request assistance from team members, depending on their tasks being completed.)
- Spreadsheets
- Master increases, Financials
- Master Slides
- Have strong communication, writing and creative skills.
- Be solution driven and can work under pressure.
- Team Player
- Provides billing support to clients by ensuring that monthly billing is submitted on time and is completed in the correct format.
- Ensure that the monthly billing deadlines are met.
- Reconcile billing invoice and client payment schedule
- Control the client billing function in respect of activations, deactivations, timeous transfers, queries and services
- Generate and prepare monthly reports
- Continually contribute to existing processes and procedures to enhance effectiveness, efficiency and performance cost control
- Follow up on outstanding billing issues from clients (where advice is not required), consultants and company.
- Reduce back-dated contributions for members that could cause Errors and Omissions for Aon.
- To ensure that all billing queries are attended to timeously and accurately
- Adhere strictly to turn around times in terms of the client SLA.

**Skills and experience that will lead to success**

**Qualifications**
- A minimum of Grade 12 or equivalent
- A NQF5 or equivalent in Wealth Management/Healthcare
- Data Analyst Diploma or degree will be advantageous
- Relevant financial/accounting degree is preferable.
- Must be registered as a representative with the FSCA in terms of the FAIS Act and