Systems Analyst

Profile

AON is looking for a System Analyst – Consumer Benefit Solutions Are you looking for a systems and data related role, that will offer you an interesting variety of responsibilities, opportunities for challenge, and tremendous potential? Interested in joining a highly engaged, diverse team, within a dynamic practice that consistently outperforms its competition, while being part of a worldwide organization, that will highly value your individual contributions? Then read on! This Systems Analyst opportunity is a hybrid role, with the flexibility to work both virtually and from either our Irvine, CA,  What the day will look like 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.  As a Systems Analyst, you will report directly to the Director of System Delivery. Your day will involve fulfilling a variety of the responsibilities listed below. Communicating: Corresponding and directly interacting with Clients, Brokers, Carriers, Vendors, Team Members, and IT colleagues to support enrollment projects, and research and resolve issuesManaging Data: Importing files using SQL and MS Access queries, code modules, and specs; exporting data to varied file and report types using provided specsCoding: Using MS VBA to manipulate data and build filesTesting & Quality Assurance: Testing enrollment systems and auditing files and reports to ensure accuracy and completenessTracking: Following up with Clients, Carriers, Vendors to ensure timely loading of the production data files providedResolving Issues: Working jointly with Team Members, and individually, to identify, track, and resolve, any discrepancies that occur throughout the data file’s life cycleReporting: Assisting with and creating various ad hoc reports for internal or external users, as neededCoordinating: Working closely with internal and external stakeholders as needed, to ensure proper development and implementation of program and system specificationsResearch and Development: Handling any R&D related projects, when assignedLearning: Opportunities to learn and grow within the team How this opportunity is different This is a unique opportunity to leverage your established technical skills as part of a larger client delivery team. In this exciting role, you will not only “do” but also consider the best way to deliver value to Aon, and our clients and carriers. You will become a technical subject matter expert on our systems and how they drive overall value and use that knowledge to consult on how to leverage our solutions. At the same time, you will have primary responsibility for data and system configuration. And while you lend your expertise to these conversations, you are also supported by a team of professionals on voluntary benefits, process, and architecture.Skills and experience that will lead to success 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 functionsFormal training with Visual Basic/VB.net preferredAdvanced level proficiency with MS ExcelApplies critical thinking to complex problems that may arise from system builds and report analysisSets 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 organize while balancing multiple priorities Ability to learn and describe capabilities, and requirements of proprietary enrollment system Preferred: Comprehension of benefit plans and benefit systems  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 For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction records in accordance with the local Fair Chance ordinances. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Pay TransparencyThe salary range for this position (intended for U.S. applicants) is $55,000 to $70,000 annually. 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. How we support our colleagues  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; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, 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 is governed by the applicable plan documents and policies. 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. Select Work-style (delete as appropriate): #LI-DH1#LI-HYBRID#LI-REMOTE  2527879,qualifications:UNAVAILABLE,responsibilities:AON is looking for a System Analyst – Consumer Benefit Solutions Are you looking for a systems and data related role, that will offer you an interesting variety of responsibilities, opportunities for challenge, and tremendous potential? Interested in joining a highly engaged, diverse team, within a dynamic practice that consistently outperforms its competition, while being part of a worldwide organization, that will highly value your individual contributions? Then read on! This Systems Analyst opportunity is a hybrid role, with the flexibility to work both virtually and from either our Irvine, CA,  What the day will look like 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.  As a Systems Analyst, you will report directly to the Director of System Delivery. Your day will involve fulfilling a variety of the responsibilities listed below. Communicating: Corresponding and directly interacting with Clients, Brokers, Carriers, Vendors, Team Members, and IT colleagues to support enrollment projects, and research and resolve issuesManaging Data: Importing files using SQL and MS Access queries, code modules, and specs; exporting data to varied file and report types using provided specsCoding: Using MS VBA to manipulate data and build filesTesting & Quality Assurance: Testing enrollment systems and auditing files and reports to ensure accuracy and completenessTracking: Following up with Clients, Carriers, Vendors to ensure timely loading of the production data files providedResolving Issues: Working jointly with Team Members, and individually, to identify, track, and resolve, any discrepancies that occur throughout the data file’s life cycleReporting: Assisting with and creating various ad hoc reports for internal or external users, as neededCoordinating: Working closely with internal and external stakeholders as needed, to ensure proper development and implementation of program and system specificationsResearch and Development: Handling any R&D related projects, when assignedLearning: Opportunities to learn and grow within the team How this opportunity is different This is a unique opportunity to leverage your established technical skills as part of a larger client delivery team. In this exciting role, you will not only “do” but also consider the best way to deliver value to Aon, and our clients and carriers. You will become a technical subject matter expert on our systems and how they drive overall value and use that knowledge to consult on how to leverage our solutions. At the same time, you will have primary responsibility for data and system configuration. And while you lend your expertise to these conversations, you are also supported by a team of professionals on voluntary benefits, process, and architecture.Skills and experience that will lead to success 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 functionsFormal training with Visual Basic/VB.net preferredAdvanced level proficiency with MS ExcelApplies critical thinking to complex problems that may arise from system builds and report analysisSets 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 organize while balancing multiple priorities Ability to learn and describe capabilities, and requirements of proprietary enrollment system Preferred: Comprehension of benefit plans and benefit systems  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 For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction records in accordance with the local Fair Chance ordinances. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Pay TransparencyThe salary range for this position (intended for U.S. applicants) is $55,000 to $70,000 annually. 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. How we support our colleagues  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; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, 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 is governed by the applicable plan documents and policies. 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. Select Work-style (delete as appropriate): #LI-DH1#LI-HYBRID#LI-REMOTE ,skills:UNAVAILABLE,workHours:UNAVAILABLE,jobBenefits:UNAVAILABLE,datePosted:2023-05-24T18:36: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:2024-05-24T19:13:01.000Z,industry:UNAVAILABLE,hiringOrganization:{@type:Organization,name:Aon Corporation,sameAs:https://jobs.aon.com,logo:https://assets.jibecdn.com/prod/aon/0.0.51/assets/brands/https://aon.icims.com/icims2/servlet/icims2?module=AppInert&action=download&id=1134557&hashed=154379},jobLocation:{@type:Place,address:{@type:PostalAddress,addressLocality:Irvine,addressRegion:California,streetAddress:17875 Von Karmon,postalCode:92614,addressCountry:United States}}}

Company info

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