Job Openings >> ETL Analyst
ETL Analyst
Title:ETL Analyst
Department:Technical Operations
Job Type:Full-Time
Campaign Start Date:03/28/2014
Location:Buffalo, NY
Position Description:

This ETL Analyst position will design and implement automated processes to maintain eligibility and deduction interfaces to payroll systems and third party vendors from an online benefits administration application.
Responsibilities Include:
  • 834 format data mapping
  • Payroll deduction code mapping
  • Development and documentation of standard file formats
  • Developing process flows and documentation
  • Assist in developing a scalable data mapping and transmission strategy
  • File mapping using commercial ETL tools (ex. Pervasive, WebMethods, BizTalk, Sterling, etc.)
  • Providing test case input and assisting with production validations
  • Consulting with upstream and downstream customers on problem solving and best practices.
  • Leading and participating on cross-functional project teams
  • Data trending and analysis
  • Some B2B client interaction
  • Interfacing with offshore teams
  • Creating dashboards for transmission and quality statistics

  • Bachelors degree in Information Systems, Computer Science, or other related field
  • Experience with 6 sigma, Lean, or ISO 9000 quality programs strongly preferred
  • Extensive technical tool/technique experience on ETL platforms
  • Experience with Visio and MS Project or equivalents
  • Proficient in SQL
  • Benefits data mapping and transmission experience
  • Experience evaluating and purchasing commercial ETL tools
Company Description:    

Founded in 2007, Liazon Corporation operates industry-leading private benefits exchanges for businesses. Its flagship product, the Bright Choices® Exchange, is an online benefits store that is changing the way employers and employees buy benefits. Bright Choices helps employers save money on their health care costs by setting predictable budgets while allowing employees to personalize their benefits package with a selection of health, dental, vision, life, disability, and other benefits from top national and regional providers. Award-winning decision support and education helps employees make smarter benefits selections. Liazon supports businesses nationwide through a distribution network of leading broker partners, including nine of the ten largest brokers in the country.

In six years, Liazon has grown to over 100 employees and now supports more than 2,400 businesses nationwide. Company offices are in Buffalo, NY and New York City. 

The management team includes industry experts and pioneers from McKinsey and Company, CIGNA, Prudential, Online Benefits, Iron Mountain, and Watson Wyatt.

Liazon was acquired by Towers Watson in November 2013.

Company Website:

Limitations and Disclaimer:

The above job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required for the position.
All job requirements are subject to possible modification to reasonably accommodate individuals with disabilities. Some requirements may exclude individuals who pose a direct threat or significant risk to the health and safety of themselves or other employees.
This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform other job-related duties requested by their supervisor in compliance with Federal and State Laws.
Requirements are representative of minimum levels of knowledge, skills and/or abilities. To perform this job successfully, the employee must possess the abilities or aptitudes to perform each duty proficiently. Continued employment remains on an "at-will" basis.
Powered by ApplicantStack