Willis Towers Watson ETL Analyst in Buffalo, New York

ETL Analyst

Date Posted: April 13, 2018


Not ready to Apply? at https://willistowerswatson.avature.net/WTWTalentNetwork


In this role, you will be part of a dynamic ETL team which is involved in data mapping for our benefits administration product. Qualified candidates will have experience in SQL and Excel with solid communication skills and the ability to project manage their own work.

The Role

As an ETL Analyst, you 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

The Requirements

• Bachelor’s 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

The Company

Willis Towers Watson is a leading global advisory, broking and solutions company that helps clients around the world turn risk into a path for growth. With roots dating to 1828, Willis Towers Watson has 40,000 employees serving more than 140 countries. We design and deliver solutions that manage risk, optimize benefits, cultivate talent, and expand the power of capital to protect and strengthen institutions and individuals. Our unique perspective allows us to see the critical intersections between talent, assets and ideas – the dynamic formula that drives business performance. Together, we unlock potential. Learn more at willistowerswatson.com. at https://www.willistowerswatson.com/

Willis Towers Watson is an equal opportunity employer

Willis Towers Watson is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to, among other things, race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a protected veteran, or disability.

Equal Employment Opportunity: Know your rights. at https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf

Unsolicited Contact: Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Willis Towers Watson are considered property of Willis Towers Watson and are not subject to payment of agency fees. In order to be an authorized Recruitment Agency/Search Firm for Willis Towers Watson, any such agency must have an existing formal written agreement signed by an authorized Willis Towers Watson recruiter and an active working relationship with the organization. Resumes must be submitted according to our candidate submission process, which includes being actively engaged on the particular search. Likewise, for our authorized Recruitment Agencies/Search Firms, if the candidate submission process is not followed, no agency fees will be paid by Willis Towers Watson. Willis Towers Watson is an equal opportunity employer.


Not ready to Apply? at https://willistowerswatson.avature.net/WTWTalentNetwork


  • Share on Facebook

  • Share on Twitter

  • Share on Google+ Share on Pinterest

  • Share on Linkedin

  • Share by Mail


  • Location:Buffalo, NY, US

  • Date Posted:April 13, 2018