Billing and Data Analyst at AON

• 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.
• The role of a Data Analyst is to work closely with health and benefits Senior Data Analyst and Operations Manager and BUH Health to ensure that all/any data that needs analysis be it from Industry or existing systems are presented in a professional manner with application of mind to what is being requested. The Data Analyst is one of the first point of contact for data analysis and input in support of the Employee Benefits division and contributes critically to the accuracy of data and reporting on Industry, and Executive reports and System report data, within Business Systems.
• 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.
• Provides administrative support (data capturing of medical scheme and Gap applications received, loading and closing queries on Aon Access) to the team.
• 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
• CMS Accreditation.
• Accredited on 6 Medical Schemes, 2 gap covers and 1 Occupational Health product.

Knowledge

• Individual with knowledge of the principles and practices within a technical/ professional discipline.
• Strong knowledge of and experience with advanced excel and power point skills. As well as be competent in all other Microsoft office suites.
• Knowledge of statistics and have the ability and skills with regards to reconciliation of figures.

Working knowledge in: 

• SQL
• Power BI 
• SSRS
• ETL
• Data Visualization
• Data Warehousing
• Cloud Computing
• Data Governance
• Business Intelligence
• Project Management

Skills and Abilities

• Possesses advanced analytical, technical and problem-solving skills and abilities.
• Very good use of the English language – writing skills
• Ability to communicate effectively, adept at queries, report writing and presenting findings.
• Have a high work ethic and must have the ability to function effectively under pressure.
• Be a team player, have the ability to build good relationships, support and actively participate in, and contribute to any team initiatives.

Experience

• Have a minimum of 3- 5 years’ experience in a similar or related role.
• Proven working experience as a data analyst.