Similar Jobs

View More

HW Set Up Configuration Specialist 5/31/2018

Aon Hammonton, NJ

Hammonton, NJ
AJE Ref #
Job Classification
Full Time
Job Type
Company Ref #
Mid-Career (2 - 15 years)
High School Diploma or GED


Job Family US-NJ-Hammonton


Aon is looking for a Health & Welfare Set Up Configuration Specialist

As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting Aon Risk Solutions in Hammonton, NJ/Maitland, FL/Irvine, CA

Your impact as a Health & Welfare Set Up Configuration Specialist

Job Responsibilities:

Data Analysis, this position requires that you have the ability to:

* Interface with Clients/Brokers/Carriers/Vendors/Team Members

* Import various file types using queries, code modules, and specs.

* Code using Microsoft VBA for data manipulation and building forms.

* Export data to various file/report types using client/carrier/ vendor specification.

* Conduct program testing and file/report auditing.

* Perform all necessary testing to ensure completeness and accuracy of data files.

* Track and follow up on transmission of production files to ensure timeliness in loading client s data.

* Track and resolve any discrepancies that may occur before, during and post all data files.

* Assist with and create various ad hoc reports for internal and or external users as needed.

* Perform all other related and compatible duties as assigned.

* Coordinate closely with IT management, other programmer analysts, project managers, and external clients, as needed, to ensure proper development and implementation of program and system specifications.

* Handle assigned research and development projects.

* Perform all other related and compatible duties as assigned.

You Bring Knowledge and Expertise

* 3 to 5 years (Preferred), 2 to 3 years (Acceptable), 1 yr (Minimum) with the following:

* Strong working knowledge of MS Access with emphasis on working with Access databases tables, queries, built-in functions, import/export capabilities.

* Working experience of SQL and its querying functions.

* Working MS Excel knowledge on custom formulas and built-in features such as Pivot tables, Lookups, etc.

* Formal training and/or experience in Microsoft Office (Required).

* Proficient using Microsoft Access Queries, Macros, Reports, Multi-Table Joins and SQL statements.

* Formal training with Visual Basic/ (Preferred).

* Sets priorities and manages work flow to ensure efficient, timely and accurate processing of transactions and other responsibilities.

* Maintain a cordial and effective relationship with clients, co-workers, carriers, vendors and other business contacts. Ability to work in a team environment.

* Work well with others as well as alone.

* Excellent verbal, writing and listening skills and the ability to multitask and organize.

* Comprehension of benefit plans and benefit systems in terms of describing their capabilities, requirements and determining if in-house system will be able to provide the solutions needed.


* High school diploma or equivalent required. BS/BA preferred.

Aon provides equal employment opportunities (EEO) 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, or domestic partner status. Aon is committed to a diverse workforce and is an affirmative action employer.


Aon plc (NYSE:Aon) is a leading global professional services firm providing a broad range of risk, retirement and health solutions. Our 50,000 colleagues in 120 countries empower results for clients by using proprietary data and analytics to deliver insights that reduce volatility and improve performance.

Company Size:
50,000+ Employees
Financial Services
Social Media:
200 East Randolph
Chicago, IL 60601

View Larger Map