Data Manager III

Aon Corporation Lincolnshire , IL 60069

Posted 2 months ago

Job Description:

Aon is looking for a Data Manager III

As part of an industry-leading team, you will help empower results for our clients by delivering innovative and effective solutions supporting Global Compensation & Talent space in Lincolnshire or Chicago, IL. Candidates in Toronto may also be considered.

Your impact as a Data Manager III

Job Responsibilities:

Essential Role Responsibilities

  • Perform data processing and data management tasks, such as coding, data manipulation/cleaning, merging, presentations, and reporting.

  • Conduct data tabulation/analysis for various types of client projects (e.g., engagement, culture, exit, onboarding).

  • Tasks include reviewing requirements and understanding best practices; data management and processing; client discussions and training as required.

  • Prepare off-line, custom ad-hoc reports in MS Excel, PowerPoint, PDF and/or SPSS/Tableau.

  • Responsible for cleaning and uploading HRIS file to system; creating organization structure from client HRIS using available tools.

  • Accountable for maintaining, reviewing, and updating all / relevant key project documents throughout the project lifecycle in the specified format as applicable (e.g. timeline, checklists, requirement documents).

  • Responsible for flawless project delivery. Ensures quality control of all deliverables by ensuring adherence to process for survey including, but not limited to data cleaning, processing, and conversion.

  • Takes ownership of the client project / relevant deliverables.

  • Manages client HRIS file, org structure development, and provides guidance to clients on preferred format.

  • Responds to all internal and external inquiries in a timely manner and with an appropriate sense of urgency.

  • Develop and enhance tools for Org Structure creation, exploring alternatives (e.g., matrix reporting).

  • Create data coding file for data entry provider if applicable.

  • Downloads survey data, reviews and makes revisions as needed. Check offline scores against result expectations (e.g., N-count) in all related QA documents, includes running initial results for initial QA.

  • Responsible for ensuring that all deliverables (e.g., data tabulations, demographics, benchmarks, HRIS information, org structure, reports, spreadsheets, data files & written comments) are fully tested and accurate.

  • Keep and monitor project schedules and the activities related to data management and reporting. Identify risks and potential delays to schedule and raise to project manager and other members of project team in a timely manner.

  • Provide the Project Manager or Lead Consultant with guidance / consultation for ad hoc analysis or report requests to ensure we provide the best possible solution to our clients.

  • Identifies, communicates, and resolves project issues and changes (including impact to timing, additional fees / scope) that require attention or action of project team members and client (as assigned).

  • Mentor and coach less experienced Project Support and Data Managers. May include people management responsibilities.

  • Assists with presentation insights/observations.

  • Responsible for tasks including, reviewing requirements and understanding best practices; setup; client demonstrations and training as required.

  • Serves as the day-to-day client contact throughout the duration of the project for defined project phases, from design and development through delivery of results.

  • Take active lead role in improving internal processes for operational tasks, such as survey, reporting, data management.

  • Develops in-depth knowledge of industry and process solutions, provide guidance to clients around the best process solutions.

  • Effectively prioritize and escalate client issues as required.

  • Collaborate with Project Manager to finalize and clarify project requirements

  • Demonstrates good judgment in selecting methods and techniques for obtaining solutions.

  • Communicate issues and changes requiring attention or action to project team members (including risks and opportunities).

  • Assist with proposals and/or other estimates as required.

  • Identifies potential risks and assists with contingency planning.

  • Troubleshoot data or software questions and /or issues (e.g., reporting site, historical mapping, org structure, tabulations, presentations, offline reports) and answer questions from project team members.

  • Recognize opportunities to improve internal processes and take the lead on the process improvement initiatives.

  • Contributes to the financial success of our practice by learning about how our business works (i.e. earns revenue and profit), seeking opportunities to be fully productive during lower billable work cycles, timely and accurate completion of your time card.

  • Responsible for sending client data to global database team for benchmarking.

  • Take ownership of the project deliverables. Ensure that the Project Manager is involved at all relevant points of the project as per procedures.

  • Provide the Project Manager with estimates of effort and timing for ad hoc analysis or reporting requests, if requested.

  • Conducts Peer reviews (as assigned) as per the procedures.

  • Conduct team orientations on data needs and train clients on reporting sites as needed.

  • Ensures the client can serve as a reference upon project completion.

  • Implement client solutions using our suite of human capital management software and supporting technologies.

  • Become an expert in our product and supporting technologies. Use your expertise to research, troubleshoot, and resolve questions or issues in a timely manner.

  • Troubleshoot data and/or technical issues, log issues and work to identify solutions or workarounds. Find and advocate for software and process improvements.

  • Provide requirements for testing and feedback on new technology software or solutions. Participate and contribute in technology requirements gathering and user acceptance testing.

  • Participate in Pre-Sales, Finalist Sales and Kick-off client meetings and represent Operations - Survey, Reporting, Data Management & Analytics as applicable

Required Education, Skills, Knowledge

  • Possesses a college/university degree or higher in computer science, business administration, engineering, mathematics, or other relevant field.

  • Has experience in related field, approximately five years or more.

  • Exposure to or experience with databases, statistical or reporting programs (like, Crystal Reports) is a plus.

  • Experience with SPSS, Tableau or other statistical software is a plus.

  • Has excellent analytical, problem solving, and multi-tasking skills.

  • Has excellent interpersonal skills related to collaboration and team building; persuasive, encouraging and motivating.

  • Proficiency in MS Office Suite (especially Excel and PowerPoint) are required. Knowledge and Experience in MS Access, and SPSS are strongly preferred).

  • Knowledge of university level statistical theory and application preferred.

  • Comfortable working with large and complex MS Excel data files.

  • Flexible; adept at reordering priorities and activities to address ever-changing requirements.

  • Ability to anticipate problems and take appropriate actions to avoid them.

  • Highly organized, giving high attention to detail, and having strong time-management abilities. Ability to manage to deadlines and deliver on commitments.

  • Has strong communication skills both written and verbal (clear and concise).

  • Comfortable working with, interpreting, and summarizing large sized data sets including, but not limited to: paper distribution sheets, HRIS files, response rates.

  • Experience in market research (or similar research) would be beneficial.

  • Experience with system testing and requirements development an asset.

  • Ability to work effectively with teams and individually with minimal supervision.

  • A strong desire to delight clients and provide exceptional service.

  • Openness and aptitude for learning new skills and software.

  • Aptitude for data, information, business intelligence, analysis and reporting.

  • Has a passion for customer service.

  • Has an ability and willingness to learn, understand, and represent new technologies.

  • Loves to bring their best to work every day.

Embraces the values of Service, Quality, Innovation, Integrity, and Determination.


Bachelor's degree or equivalent years of industry experience

We offer you

A competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

Our Colleague Experience:

From helping clients gain access to capital after natural disasters, to creating access to health care and retirement for millions, Aon colleagues empower results for our clients, communities, and each other every day. They make a difference, work with the best, own their potential, and value one another. This is the Aon Colleague Experience, defining what it means to work at Aon and realizing our vision of empowering human and economic possibility. To learn more visit Aon Colleague Experience.

About Aon:

Aon plc (NYSE:AON) is a leading global professional services firm providing a broad range of risk, retirement and health solutions. Our 50,000 colleagues in 120 countries empower results for clients by using proprietary data and analytics to deliver insights that reduce volatility and improve performance.

By applying for a position with Aon, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Aon's employment policies. Background checks may include some or all of the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

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, or domestic partner status. Aon is committed to a diverse workforce and is an affirmative action employer.


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

Job number: 2450153

Category: Consulting

Location: United States, IL, Lincolnshire
9/20/2018 16:50:12

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Executive Assistant Data Center Solutions


Posted 4 days ago

VIEW JOBS 11/14/2018 12:00:00 AM 2019-02-12T00:00 The Executive Assistant supports Senior and Executive Leadership with all daily, monthly and quarterly responsibilities related to internal and external stakeholders. This role takes initiative for all administrative duties in order to aid leadership in all facets. This highly visible position will contribute to the success of CDW through support of the VP of Data Center Solutions. In addition to the duties required to support day-to-day activity, this individual will coordinate internal and external events and meetings as well as regular communication channels. Successful candidates will develop exceptional external relationships, as well as with peers and coworkers at all levels within the company Key Areas of Responsibility * Manage Executive's calendar and scheduling, including all internal and external meetings. * Field incoming phone calls, follow-up and resolve appropriately. * Plan and manage all aspects of Executive's travel. * Act as a department liaison when appropriate. * Draft, prepare and proofread letters, memos, reports, spreadsheets, charts and presentations. Responsibilities * Coordinate and lead preparation for all Senior Leadership meetings, including but not limited to: securing meeting location, travel, accommodations, , catering, equipment/supplies, etc. * Arrange all aspects of department gatherings (location, set-up, food, and activities). * Develop collaborative relationships across CDW, to ensure positive results. * Effectively interact with all stakeholders including internal and external customers. * Create professional PowerPoint presentations. * Process expense reports, requisitions and new hire needs. * Enter all invoices and create PO's to ensure timely payment to Vendors. * Maintain a variety of department lists. * Maintain department and Senior level organizational charts. * Handle time-clock issues for the department. * Special projects and additional duties as assigned to support specific Executive and department operations. * Support Executive's Director team with calendaring and travel arrangements Qualifications Minimum Qualifications * 5 years assisting executive-level management. * High school diploma. Other Required Qualifications * History of maintaining confidentiality in working with private and sensitive information. * Proficient in Microsoft Office applications, WebEx, SharePoint, and SharePoint Designer * Strong organizational and time management skills, with the ability to be resourceful and creatively problem solve. * Excellent verbal and written communication skills with the ability to positively and professionally interact with all coworkers across CDW, including executive leadership and external stakeholders. * Solid understanding of social media usage including but not limited to; LinkedIn, Facebook, Twitter, YouTube, Forums, Wikis and blogs. * Demonstrated ability to take initiative and work independently with little direction. * History of balancing multiple priorities, schedules, and logistics, simultaneously with the ability to adapt to the changing needs of the business. * Influential with others, tailoring communication to the needs of the target audience * Demonstrated working experience in event planning, meeting coordination, and partner and vendor relations * Ability to effectively facilitate and lead meetings, tailoring messages to the given audience * Proficient negotiation and persuasion skills, with the ability to enable win-win resolutions * Critical attention to detail and solid creative problem solving skills * Demonstrated knowledge of the business, organization and solutions that are the back bone of the organization * Ability to adapt to changing conditions, strategies and organizational direction * Demonstrated ability to manage expense reports, travel request, while managing timelines * Proven track record of successfully supporting the needs of project team members and internal stakeholders (locally and virtually) * Demonstrate influence without authority. * Ability to effectively resolve conflict with appropriate escalation Preferred Qualifications * Bachelor's degree Job Category: Administrative Job Type: Full-Time Travel Percentage: 10% CDW Lincolnshire IL

Data Manager III

Aon Corporation