Systems Analyst - Irvine, United States - Aon

    Aon
    Default job background
    Description
    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 System Analyst opportunity is a hybrid role, with the flexibility to work both virtually and from our Lake Mary, FL or Irvine, CA,

    office.
    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 issues

    Managing Data:
    Importing files using SQL and MS Access queries, code modules, and specs; exporting data to varied file and report types using provided specs

    Coding:
    Using MS VBA to manipulate data and build files

    Testing & Quality Assurance:
    Testing enrollment systems and auditing files and reports to ensure accuracy and completeness

    Tracking:
    Following up with Clients, Carriers, Vendors to ensure timely loading of the production data files provided

    Resolving Issues:
    Working jointly with Team Members, and individually, to identify, track, and resolve, any discrepancies that occur throughout the data file's life cycle

    Reporting:
    Assisting with and creating various ad hoc reports for internal or external users, as needed

    Coordinating:
    Working closely with internal and external stakeholders as needed, to ensure proper development and implementation of program and system specifications

    Research and Development:
    Handling any R&D related projects, when assigned

    Learning:
    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 capabilities
    1 plus years of experience with SQL and its querying functions
    Advanced level proficiency with MS Excel
    Applies critical thinking to complex problems that may arise from system builds and report analysis
    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 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

    Preferred:
    Formal training with Visual

    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

    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 Transparency
    The 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.
    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 p rogram 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

    Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

    # LI-HL2
    #LI-HYBRID
    2527879
    #J-18808-Ljbffr