Analytics and Reporting Analyst

About the Role

Key Responsibilities

• Writes, deploys, and maintains complex queries and stored procedures with SQL experience to support both internal and client delivery of reporting as well as analytical support and data requests.
• Initiate analyses to determine the cause of trends that vary materially from anticipated results sharing conclusions with and recommendations with the client and internal team.
• Creates/updates programming reporting data to a final delivery form through the use of Excel, Access, or other acceptable forms to create customer client reporting.
• Coordinates the gathering of client data from functional areas for review and input into client reports as assigned Delivers custom reporting to clients on a timely basis through emails, ftp sites, etc.
• Reviews and assesses data being reported, alerting team members of any issues or trends that should be acted upon.
• Maintain accuracy for reporting tables provided by IT and provide IT requirements/direction when needed. Understanding the impacts and proactively alerting internal customers and clients regarding issues and delays is entailed as well. This position would oversee the automation of processes within the department as well.
• Writes or otherwise communicates (email, PowerPoint) persuasively to client, and others to help explain analysis and/or program recommendations based on the data trends.
• Documents and maintains our records of report development work and communicates process to AIM team members and clients.
• Publishes an inventory of reports and other contact points periodically.
• 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.
• Maintains a work structure and records to enable extensive multi-tasking while keeping track of deliverables owed and deadlines. Re-prioritizes tasks as required to accomplish each day's work.
• 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 VP.

Requirements

• 5-7 years of Financial Analysis experience.
• Expert level SQL experience is required- candidates will be tested on-site for SQL proficiency.
• Knowledge of Power BI is desired.
• Knowledge of call center fundamentals and reporting is desired.
• Bachelor's degree or equivalent years of industry experience.

Nice to Have

• Knowledge of Power BI.
• Knowledge of call center fundamentals and reporting.

Qualifications

• Bachelor's degree or equivalent years of industry experience.

Benefits & Perks

• Comprehensive benefits package including 401(k) with employer contributions, employee stock purchase plan, and consideration for long-term incentive awards.
• Medical, dental, and vision insurance.
• Various types of leaves of absence, paid time off including 12 paid holidays, 15 days of paid vacation, paid sick leave.
• 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 employee assistance program with free counseling sessions.