Systems Analyst

Profile

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 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. 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, diverse team, and we are passionate about helping our colleagues and clients succeed.  What the day will look like 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 formsExport data to various file/report types using client/carrier/ vendor specificationConduct program testing and file/report auditingPerform 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 filesAssist with and create various ad hoc reports for internal and or external users as neededPerform all other related and compatible duties as assignedCoordinate 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 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 capabilities1 plus years of experience with SQL and its querying functionsAdvanced level proficiency with MS ExcelSets priorities and manages workflow to ensure efficient, timely and accurate processing of transactions and other responsibilitiesAbility to work as part of a team as well as independentlyExcellent verbal, writing and listening skills and the ability to multitask and organizeComprehension 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 How we support our colleagues  In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive 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, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! 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, diverse 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 (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, domestic partner status, or other legally protected status.  Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply.  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on ReasonableAdjustments@Aon.com Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. #LI-DD1 2510176,qualifications:UNAVAILABLE,responsibilities: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 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. 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, diverse team, and we are passionate about helping our colleagues and clients succeed.  What the day will look like 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 formsExport data to various file/report types using client/carrier/ vendor specificationConduct program testing and file/report auditingPerform 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 filesAssist with and create various ad hoc reports for internal and or external users as neededPerform all other related and compatible duties as assignedCoordinate 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 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 capabilities1 plus years of experience with SQL and its querying functionsAdvanced level proficiency with MS ExcelSets priorities and manages workflow to ensure efficient, timely and accurate processing of transactions and other responsibilitiesAbility to work as part of a team as well as independentlyExcellent verbal, writing and listening skills and the ability to multitask and organizeComprehension 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 How we support our colleagues  In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive 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, but we also recognize that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working! 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, diverse 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 (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, domestic partner status, or other legally protected status.  Aon is committed to a diverse workforce and is an affirmative action employer. People with criminal histories are encouraged to apply.  We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation on ReasonableAdjustments@Aon.com Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. #LI-DD1,skills:UNAVAILABLE,workHours:UNAVAILABLE,jobBenefits:UNAVAILABLE,datePosted:2022-06-03T19:51:00 0000,employmentType:FULL_TIME,educationRequirements:UNAVAILABLE,salaryCurrency:USD,baseSalary:{@type:MonetaryAmount,currency:USD,value:{@type:QuantitativeValue,value:0,minValue:0,maxValue:0,unitText:YEAR}},validThrough:2023-06-03T19:51:20.000Z,industry:UNAVAILABLE,hiringOrganization:{@type:Organization,name:Aon Corporation,sameAs:https://jobs.aon.com,logo:https://assets.jibecdn.com/prod/aon/0.0.47/assets/brands/https://aon.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=1134557&hashed=154379},jobLocation:{@type:Place,address:{@type:PostalAddress,addressLocality:Lake Mary,addressRegion:Florida,streetAddress:605 Crescent Executive Court 
Primera Towers III ,postalCode:32746,addressCountry:United States}}}

Company info

Aon PLC.
Website : http://www.aon.com