Data Conversion Services Data Specialist (Lincolnshire/Woodlands/Orlando locations) Job in Chicago 60601, Illinois US
Aon Hewitt is the global leader in human capital consulting and outsourcing solutions. The company partners with organizations to solve their most complex benefits, talent and related financial challenges, and improve business performance. Aon Hewitt designs, implements, communicates and administers a wide range of human capital, retirement, investment management, health care, compensation and talent management strategies. With more than 29,000 professionals in 90 countries, Aon Hewitt makes the world a better place to work for clients and their employees. For more information on Aon Hewitt, please visit www.aonhewitt.com.
The Data Specialist (DS) is responsible for the technical execution of the data conversion process to load historical HR and benefits data onto Hewitt's proprietary benefits system (the TBA System) for Hewitt's new benefits clients. The DS is responsible for the coding and testing needed to ensure quality in the data conversion process.
Responsibility Areas
- Codes Informatica maps, edits, processes, and sets up conversion batch jobs according to specifications.
- Maintains documentation, including batch job comments, annotations in Informatica transformations, code versioning, and processing guide template according to standards.
- Profiles and provides analysis reports to data managers based on given specifications.
- Creates ad hoc reports for client data analysis based on specifications from data manager.
- Test Plan execution and documentation.
- Fix any issues identified via test execution.
- Executes and documents data conversion flow to load data onto TBA, including Informatica maps, batch jobs, etc.
- Reconciles data counts through each stage of the data loading process; and documents domain specific required reconciliation (e.g., DC Trial Balancing).
- Researches and resolves errors in the conversion, including edits, duplicate records, and records dropped or bypassed throughout the process.
- Configures and debugs batch jobs for each client; runs these jobs to load data to TBA.
- Executes complete post live date projects, data cleanup.
- Performs fully automated or small scale manual data cleansing.
- Utilize relevant problem-solving resources as needed.
- Escalate issues when appropriate.
Formal Education Certification
- Bachelor's degree, preferably in a technical field, or equivalent work experience.
Knowledge Experience
- Experience performing basic data analysis.
- Able to perform quality checking on data, including creating/executing test plans with conditional logic.
- Basic Benefits Delivery Model knowledge.
- SQL and MS Excel experience; MS Access experience preferred.
- Data Conversion / Extraction, Transformation Loading (ETL) experience valuable, but not required.
- Informatica experience, preferred.
- Domain specific knowledge
All positions require an applicant who has accepted an offer to undergo a background check. The checks run are based on the nature of the position. Background checks may include some or all of the following: SSN/SIN validation, education verification, employment verification, criminal check, search against global sanctions and government watch lists, fingerprint verification, credit check, and/or drug test. By applying for a position with Aon Hewitt, you understand that you will be required to undergo a background check should you be made an offer. You also understand that the offer is contingent upon successful completion of the background check and results consistent with Aon Hewitt's employment policies. You will be notified during the hiring process which checks are required by the position.
Aon Hewitt is an Equal Opportunity Employer Committed to Diversity, M/F/D/V
