Data Analyst

The Data Analyst will support the corporate HR department in the management and analysis of multiple data sources and programs interacting internally with Workday (HRIS), Payroll, Finance, Legal and externally with multiple vendors (e.g. Blue Cross/Blue Shield, CVS/Caremark, IBM Watson, Empyrean Benefit Solutions, etc.). Serve as key liaison with ITW Finance and external actuaries and accountants on data integrity, reconciliations and submissions. Additionally, support compliance efforts keeping abreast of federal tax and benefits laws related to critical and time-sensitive reporting and filing. Contribute to a wide range of complex projects involving the design, financing, delivery and management of health and welfare benefit programs including medical, wellness, dental, life, disability and leaves.

Duties:

• Understand the system flows (data interface from the HR and payroll systems, transmission of information to outside parties)
• Understand and improve existing internal data flow and develop/implement new data flows where necessary for plan operations
• Compile data from multiple sources and varied formats as required for FAS census, audits and health and welfare plan operations and analysis
• Develop working relationships with vendors and key stakeholders
• Process confidential data and information per organizational guidelines
• Provide timely and accurate routine and ad hoc reports
• Manage Health Plan Data Warehouse (IBM Watson/Truven Advantage Suite) including vendor data oversight, queries, reports and analysis
• Develop plan financial/operational dashboards, implement and execute
• Coordinate plan information with Financial Accounting, actuaries, and government required reporting
• Troubleshoot data issues with vendors and internal stakeholders
• Manage transmission and receiving of encrypted data with external vendors

Requirements:

• Bachelor’s degree in Mathematics, Statistics, Finance or related discipline.
• 2-5 years of experience with data management
• Expertise in Microsoft Excel and Access, excellent computer skills in other Office applications
• Detail oriented with ability to manage and document data across multiple platforms
• Ability to map data and translate raw data output into usable reports
• Team player with proven track record of managing projects
• Ability to research and troubleshoot issues associated with data and benefits administration
• Problem solving and analytical thinking
• Ability to manage multiple priorities and deadlines
• Strong communication skills
• Ability to effectively use technology to best meet the needs of HR staff and employees
• Experience with a data warehouse (e.g. IBM Watson/Truven Health) a plus
• Familiarity with employee benefits administration and HRIS systems (e.g. Workday, PeopleSoft) a plus

EEO is the Law
Applicants and employees of ITW are protected under Federal law from discrimination on several bases. Follow the link above to read more.