Consultant, Data Analyst
About The Position
The Data Designer performs intensive data analysis to inspect, cleanse, transform, and model data, and resolves issues related to data completeness and quality. The role analyzes ETL components in Informatica PowerCenter to identify existing source-to-target transformation logic; creates visual ETL data-mapping documents using Informatica and IBM InfoSphere DataStage; and writes complex SQL queries to profile data and verify mapping accuracy in current data-warehouse models using Teradata SQL Assistant. The position also automates frontend tools using UFT (QTP) and Selenium, and mocks and tests XML, API, and web-service calls with SOAP UI and IBM Rational Tester. The position requires a bachelor's degree in Computer Science or Engineering and five years of experience performing the described duties. It is hybrid in a normal office environment. Associates may have on-call responsibilities after normal working hours and/or on weekends. Overtime eligibility is exempt.
Requirements
- Bachelor's degree in Computer Science or Engineering.
- Five years of experience performing the duties described in the job posting.
Responsibilities
- Inspect, cleanse, transform, and model data, and resolve data completeness and quality issues.
- Analyze Informatica PowerCenter ETL components to determine existing source-to-target data transformation logic.
- Create visual ETL data-mapping documents using Informatica and IBM InfoSphere DataStage.
- Create complex SQL queries and use Teradata SQL Assistant to profile source data and verify mapping accuracy in current data-warehouse models.
- Automate frontend tools using UFT (QTP) and Selenium.
- Mock and test XML, API, and web-service calls using SOAP UI and IBM Rational Tester.
- Regularly and consistently demonstrate Nationwide Values.
Benefits
- Medical, dental, and vision coverage
- Life insurance
- Short- and long-term disability coverage
- Paid time off, including a minimum of 18 days per full calendar year for newly hired associates, prorated quarterly based on hire date
- Nine paid holidays
- Eight hours of Lifetime paid time off
- Eight hours of Unity Day paid time off
- 401(k) with company match
- Company-paid pension plan
- Business casual attire
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
