Systems Analyst (Microsoft Access) - Job at Aon in Irvine, CA

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 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

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 program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.

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.

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