Data Analyst in Glenview, IL at ITW

Date Posted: 7/15/2018

Job Snapshot

Job Description

Position at ITW Corporate

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.


  • 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


  • 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.

If you are a qualified individual with a disability and are unable or limited in your ability to use or access the online application system process due to your disability, please click corp_accessibility@ to request assistance. No other requests will be acknowledged.