Data Warehouse/ SQL Developer Extend Health
THIS JOB HAS EXPIRED
Description
Extend Health, Inc. is a business segment of Towers Watson & Co. and operates the largest private Medicare exchange in the country. Founded in 2004, the Extend Health Medicare Exchange and the company?s licensed and certified benefit advisors have helped hundreds of thousands of Medicare-eligible retirees and their dependents identify and evaluate private Medicare plans that best meet their needs and budgets based on their individual medical and pharmaceutical needs. Extend Health has also helped Fortune 500 companies, unions, and municipalities realize significant savings for healthcare coverage for Medicare-eligible retirees when compared to employer group plans
Job Responsibilities:
? Develop stored procedures, triggers and user-defined functions.
? Develop and support extraction of large volume of data from various sources into the Data warehouse after significant cleansing, transformation
and processing using SSIS and other ETL tool sets.
? Support of a Data Warehouse/Data Mart to meet end user data needs (Metrics driven Business Intelligence Solution).
? Performance optimization of the Data warehouse.
? Identify system deficiencies and recommend solutions.
? Designing, coding, and writing unit test cases from functional requirements.
Job Requirements:
? Expert knowledge of SQL programming with a minimum of 4 years with Microsoft's SQL server products. Proficient with SQL Server 2008 R2/2012
? SSIS, SSAS, etc.
? Solid Microsoft Data warehouse performance tuning and troubleshooting experience. Strong SQL background including writing stored procedures
and triggers etc.
? Working knowledge of custom SSIS script tasks ,VBScript, .Net and C#
? Experience in dimensional modeling - Star Schema / Normalized Schema etc.
? Experience with other Data warehouse /ETL tools such as Data Manager (IBM) or Data Stage.
? Knowledge with Business Intelligence tools like Cognos or Business Objects is a plus.
? Excellent communication skills.
? Ability to prioritize multiple tasks effectively.
? Strong technical documentation skills.
? Bachelor?s degree in Computer Science or related field.
Physical Demands and Work Environment:
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
? Physical demands: While performing duties of the job, employee is occasionally required to stand; walk; sit; use hands to finger, handle or feel
objects, controls, keyboards; work on desktop or laptop computers; reach with hands and arms; balance; stoop; talk and hear. The employee
must occasionally lift up to 15 lbs.
? Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability
adjust focus.
? Work environment: The noise level in the work environment is usually moderate to low.
Equal Employment Opportunity:
The Company is an equal opportunity employer and makes employment decisions on the basis of merit. In accordance with applicable law, the Company prohibits discrimination based on race, color, religion, sex, pregnancy, age, national origin or ancestry, physical or mental disability, genetic characteristic, veteran status, or any other consideration protected by federal, state or local laws.
| Location: |
South Jordan, UT
United States
|
THIS JOB HAS EXPIRED