Business Data Analyst

Quality Assurance-Sr. Analyst As part of an industry-leading team, you will help empower results for our clients by focusing on the development and support of our Quality Assurance as well as functional areas within Aon Integramark. This position reports to VP of Program Analytics. This is a hybrid role with the flexibility to work both virtually and from our Alpharetta, GA office 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 SUPPORTS the Account Executives in the management aspects of reporting, data queries, surveillance, and daily operational support of quality assurance platform for our Debt Cancellation clients. BUILDS, thru SQL, VBA, and data visualization of Excel, both client-facing reports as well as internal management surveillance of quality and client metric reporting as well as client-facing reports. COLLABORATES and provides support for client relationships and deliverables with key partner contacts on a day-to-day basis. Prepare and monitor baseline and complex new analytics and that contribute to revenue growth and cost reduction strategies. This position requires extensive knowledge of all functional processes within the company and the impacts of any process changes to reporting for all clients. These activities could vary from ad hoc client requests for data or analytics, new client report development, maintenance of existing client reporting, as well as internal reporting development or enhancements. ACTIVELY LISTENS to concerns, needs, goals or objections, both stated and unstated, and proactively develops reporting solutions to meet those needs. SUPPORTS the VP of Program Analytics & Reporting in organizing tasks and information to effectively deploy meaningful client and customer care reporting while meeting/exceeding expectations. WRITES, DEPLOYS and MAINTAINS complex queries and stored procedures through use of SQL, Excel, and Access to support both internal and client delivery of reporting as well as analytical support and data requests. MAINTAIN accuracy for quality and reporting tables. Understanding the impacts and proactively alerting internal customers and clients regarding issues and delays is entailed as well. This position would help in overseeing the daily operations of processes within the department as well. MAINTAINS reference tables in support of accurate client reporting. PLANS and prepares for new clients, new programs, and new reports occurring in the day-to-day process by working together with those providing data and developing the new reports and gaining a working knowledge of the new reports. DOCUMENTS and MAINTAINS our records of report development work and communicates progress to AIM team members and clients. PUBLISHES an inventory of reports and other contact points periodically. WRITES or otherwise communicates persuasively to team and clients to help explain analysis and /or program recommendations based on the issue/data trends. ATTENDS TO DETAILS with excellent written and verbal communication skills, extreme detail focus to avoid re-work and errors, and 100% follow-thru on outstanding items. MAINTAINS good working relations with client contacts, key members of the Aon team and external resources. MANAGES completion of specific reporting requests/tactics as assigned by Manager of Operational Excellence or VP of Program Reporting & Analytics. How this opportunity is different A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. Skills and experience that will lead to success SQL, VBA, and Excel experience is required. Power BI knowledge is a plus. Candidates will be tested on site for proficiency. Knowledge of Call Center, related Quality and related support functions fundamentals and reporting is desired. Knowledge of Insurance Industry is a plus. MS Office suite: expert user in Excel, Access and PowerPoint are critical; candidates will be tested for proficiency. Must be able to present and communicate, both written and orally, to clients. 3-5 years’ experience in Financial Analysis preferred. Insurance industry experience a plus. Call center experience a plus. Education Bachelor’s degree in business, finance preferred, or 5-7 equivalent years of industry experience. Pay Transparency The salary range for this position (intended for U.S. applicants) is $53,500 to $67,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. This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan. 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 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 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 #LI-HYBRID 2533073 Quality Assurance-Sr. Analyst As part of an industry-leading team, you will help empower results for our clients by focusing on the development and support of our Quality Assurance as well as functional areas within Aon Integramark. This position reports to VP of Program Analytics. This is a hybrid role with the flexibility to work both virtually and from our Alpharetta, GA office 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 SUPPORTS the Account Executives in the management aspects of reporting, data queries, surveillance, and daily operational support of quality assurance platform for our Debt Cancellation clients. BUILDS, thru SQL, VBA, and data visualization of Excel, both client-facing reports as well as internal management surveillance of quality and client metric reporting as well as client-facing reports. COLLABORATES and provides support for client relationships and deliverables with key partner contacts on a day-to-day basis. Prepare and monitor baseline and complex new analytics and that contribute to revenue growth and cost reduction strategies. This position requires extensive knowledge of all functional processes within the company and the impacts of any process changes to reporting for all clients. These activities could vary from ad hoc client requests for data or analytics, new client report development, maintenance of existing client reporting, as well as internal reporting development or enhancements. ACTIVELY LISTENS to concerns, needs, goals or objections, both stated and unstated, and proactively develops reporting solutions to meet those needs. SUPPORTS the VP of Program Analytics & Reporting in organizing tasks and information to effectively deploy meaningful client and customer care reporting while meeting/exceeding expectations. WRITES, DEPLOYS and MAINTAINS complex queries and stored procedures through use of SQL, Excel, and Access to support both internal and client delivery of reporting as well as analytical support and data requests. MAINTAIN accuracy for quality and reporting tables. Understanding the impacts and proactively alerting internal customers and clients regarding issues and delays is entailed as well. This position would help in overseeing the daily operations of processes within the department as well. MAINTAINS reference tables in support of accurate client reporting. PLANS and prepares for new clients, new programs, and new reports occurring in the day-to-day process by working together with those providing data and developing the new reports and gaining a working knowledge of the new reports. DOCUMENTS and MAINTAINS our records of report development work and communicates progress to AIM team members and clients. PUBLISHES an inventory of reports and other contact points periodically. WRITES or otherwise communicates persuasively to team and clients to help explain analysis and /or program recommendations based on the issue/data trends. ATTENDS TO DETAILS with excellent written and verbal communication skills, extreme detail focus to avoid re-work and errors, and 100% follow-thru on outstanding items. MAINTAINS good working relations with client contacts, key members of the Aon team and external resources. MANAGES completion of specific reporting requests/tactics as assigned by Manager of Operational Excellence or VP of Program Reporting & Analytics. How this opportunity is different A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. Skills and experience that will lead to success SQL, VBA, and Excel experience is required. Power BI knowledge is a plus. Candidates will be tested on site for proficiency. Knowledge of Call Center, related Quality and related support functions fundamentals and reporting is desired. Knowledge of Insurance Industry is a plus. MS Office suite: expert user in Excel, Access and PowerPoint are critical; candidates will be tested for proficiency. Must be able to present and communicate, both written and orally, to clients. 3-5 years’ experience in Financial Analysis preferred. Insurance industry experience a plus. Call center experience a plus. Education Bachelor’s degree in business, finance preferred, or 5-7 equivalent years of industry experience. Pay Transparency The salary range for this position (intended for U.S. applicants) is $53,500 to $67,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. This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan. 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 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 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 #LI-HYBRID