Talent.com
Billing And Data Analyst

Billing And Data Analyst

AONJohannesburg, Gauteng, South Africa
7 days ago
Job 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.

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.
  • How we support our colleagues

    In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work / life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well.

    Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

    Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

    Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

    We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience.

    #LI-AO1

    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.

    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.
  • How we support our colleagues

    In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work / life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well.

    Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

    Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

    Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

    We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience.

    #LI-AO1

    #J-18808-Ljbffr

    Create a job alert for this search

    Data Analyst • Johannesburg, Gauteng, South Africa

    Related jobs
    • Promoted
    Senior Analyst Data Sandton

    Senior Analyst Data Sandton

    DatacentrixSandton, Gauteng, South Africa
    Senior Analyst in Data and Analytics.Senior Analyst in Data and Analytics.Must have 3+ years experience using.Azure platform for Data and Analytics products specially focused in Data Services : .Cosm...Show moreLast updated: 30+ days ago
    • Promoted
    SAP / Performance Data / BI Analyst (Petrochemical) - 6 month contract (LOCALS)

    SAP / Performance Data / BI Analyst (Petrochemical) - 6 month contract (LOCALS)

    Isilumko StaffingSasolburg, Free State, South Africa
    Industry : Petrochemical | Mining | Chemical | FMCG | Banking.Employment Type : Full-time | On-site.A University Degree in Engineering, BCom, IT, or a related field. Business Intelligence & Data Analy...Show moreLast updated: 18 days ago
    • Promoted
    Senior Data Analyst Centurion

    Senior Data Analyst Centurion

    Hire ResolveCenturion, Gauteng, South Africa
    Our client is looking for a skilled and passionate Senior Data Analyst to join their data analyst team to deliver data-driven products and insights to internal and external stakeholders through the...Show moreLast updated: 30+ days ago
    • Promoted
    Data Analyst

    Data Analyst

    Santam InsuranceJohannesburg, Gauteng, South Africa
    Now more than ever it’s important to be cybersafe.See Santam’s tips to help you stay safe online.Here we ensure we receive all your documents to get you onto our payroll system.Step 1 – Our vacanci...Show moreLast updated: 30+ days ago
    • Promoted
    Billings Analyst JHB - North

    Billings Analyst JHB - North

    Pillangó PlacementsRandburg, Gauteng, South Africa
    Join an International Firm as a Billings and COGS Analyst.Manage and analyze all aspects related to invoicing and the cost of goods sold, including accurate billing processes and overseeing cost an...Show moreLast updated: 30+ days ago
    • Promoted
    BI Data Analyst I

    BI Data Analyst I

    nedbankJohannesburg, Gauteng, South Africa
    To support and maintain the data warehouse in line with the data model; metadata repository and to provide business intelligence analysis through performing strategic and operational support.Struct...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Analyst in Data and Analytics

    Senior Analyst in Data and Analytics

    DatacentrixSandton, Gauteng, South Africa
    Senior Analyst in Data and Analytics.Senior Analyst in Data and Analytics.Must have 3+ years experience using.Azure platform for Data and Analytics products specially focused in Data Services : .Cosm...Show moreLast updated: 30+ days ago
    • Promoted
    Senior BI and Data Analyst

    Senior BI and Data Analyst

    Nedbank Private WealthJohannesburg, Gauteng, South Africa
    To manage and oversee multiple complex projects as a Data Analysis Manager to ensure that relevant and high-quality data is available in a timely manner from the Golden Sources into the Enterprise ...Show moreLast updated: 18 days ago
    • Promoted
    Billing-to-collection Manager

    Billing-to-collection Manager

    Crawford InternationalSandton, Gauteng, South Africa
    The role of the Billing-to-Collection Controller is to ensure accurate AR reporting (balance sheet and income statement) and minimize the Brand debt and drive maximization of revenue (billing compl...Show moreLast updated: 5 days ago
    • Promoted
    Senior BI and Data Analyst

    Senior BI and Data Analyst

    NedbankJohannesburg, Gauteng, South Africa
    To manage and oversee multiple complex projects as a Data Analysis Manager, to ensure that relevant and high-quality data is available in a timely manner from the Golden Sources into the Enterprise...Show moreLast updated: 30+ days ago
    • Promoted
    BI Data Analyst

    BI Data Analyst

    NedbankJohannesburg, Gauteng, South Africa
    Nedbank Retail Business Banking.Join Nedbank as a BI Data Analyst and drive strategic decisions with your expertise in SQL Server, SSIS, and PowerBI. Design and maintain secure database systems, pro...Show moreLast updated: 30+ days ago
    • Promoted
    Billings and COGS Analyst

    Billings and COGS Analyst

    Pillangó PlacementsRandburg, Gauteng, South Africa
    Join an international firm as a Billings and COGS (Cost of Goods Sold) Analyst!.Manage and analyse all aspects related to invoicing and the cost of goods sold that will include accurate billing pro...Show moreLast updated: 30+ days ago
    • Promoted
    Lead, Billing Specialist

    Lead, Billing Specialist

    North HighlandSandton, Gauteng, South Africa
    MAKE STRATEGY A REALITY | ACCELERATE YOUR GROWTH | CHOOSE YOUR PATH.As the world's leading change and transformation consultancy, we’re helping businesses move from strategy to reality by taking a ...Show moreLast updated: 10 days ago
    • Promoted
    Senior BI and Data Analyst

    Senior BI and Data Analyst

    nedbankJohannesburg, Gauteng, South Africa
    To manage and oversee multiple complex projects as a Data Analysis Manager, to ensure that relevant and high-quality data is available in a timely manner from the Golden Sources into the Enterprise...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Data Analysts

    Senior Data Analysts

    SavageOne Pty LtdMidrand, Gauteng, South Africa
    Apply only if you possess the following skills within the.Power BI, Qlik, and other interactive visualization tools.We are seeking an experienced Data Analyst to join our clients team.The ideal can...Show moreLast updated: 30+ days ago
    • Promoted
    Data Analyst_II

    Data Analyst_II

    WesBankJohannesburg, Gauteng, South Africa
    To develop and lead a team that understands the various data sources, how the data flows through the organization and provide expertise, thought leadership, guidance and support through translating...Show moreLast updated: 7 days ago
    • Promoted
    Data Analyst / Data Modeler

    Data Analyst / Data Modeler

    ExusiaWorkFromHome, Gauteng, South Africa
    Department : Sales and Delivery Team - Empower.Information Technology & Services, Computer Software, Management Consulting. Masters / Bachelor of Engineering or Equivalent.Exusia, a cutting-edge dig...Show moreLast updated: 30+ days ago
    • Promoted
    BI Developer / Data Analyst R30 000

    BI Developer / Data Analyst R30 000

    Express Employment Professionals SA - MidrandCenturion, Gauteng, South Africa
    The successful candidate will be responsible for developing and maintaining a Business Intelligence System.Good understanding of IT Infrastructure. Good understanding of Microsoft applications and S...Show moreLast updated: 30+ days ago