Systems Analyst

Company: Aon
Location: Bridgewater
Posted on: August 4, 2022

Job Description:

Aon is looking for a Systems Analyst As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions as part of our Operations business group within Health Solutions, in Hammonton, NJ, Irvine, CA and Lake Mary, FL. As a Systems Analyst, you will report directly to the Technology Manager. While there is a preference for someone in the above listed offices, the team may consider a virtual arrangement for someone in the Continental United States. Your Impact as a Systems Analyst Job Responsibilities: 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 Required Experience: 1 plus years of experience with MS Access, with emphasis on working with databases, tables, queries, macros, reports, multi-table joins, SQL statements, built-in functions, and import/export capabilities 1 plus years of experience with SQL and its querying functions Advanced level proficiency with MS Excel Sets priorities and manages workflow to ensure efficient, timely and accurate processing of transactions and other responsibilities Ability to work as part of a team as well as independently 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 Preferred Experience: Formal training with Visual Basic/VB.net Education: Bachelor's degree in relevant discipline or equivalent years of industry experience We offer you A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization The salary range for this position is $50,000 to $62,000 annually. This salary range is an estimate and the actual salary will vary based on applicant's education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant's geographic location. Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; medical, dental and vision insurance, various types of leaves of absence, paid time off, including sick days and vacation days, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions. Eligibility for benefits are governed by the applicable plan documents and policies. Our Colleague Experience: From helping clients gain access to capital after natural disasters, to creating access to health care and retirement for millions, Aon colleagues empower results for our clients, communities, and each other every day. They make a difference, work with the best, own their potential, and value one another. This is the Aon Colleague Experience, defining what it means to work at Aon and realizing our vision of empowering human and economic possibility. To learn more visit Aon Colleague Experience. About Aon: 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. By applying for a position with Aon, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Aon's employment policies. Background checks may include some or all of the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position. 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. DISCLAIMER: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. #LI-DD1 2502848

Keywords: Aon, Trenton , Systems Analyst, Professions , Bridgewater, New Jersey