Senior Data Warehouse ETL Developer

Overview

Responsible for the development of all processes necessary to complete all phases of the

Enterprise Data Warehouse (EDW). This includes source identification, data collection, data

transformation, normalization, rule administration, error detection and correction, data

consolidation, data storage, data distribution, schema mapping, data enrichment, and data

governance.

Responsibilities

• Essential Duties and Responsibilities
• Lead ETL resource on new ETL development for the Data Warehouse.
• Responsible for the entire flow of the data into the Data Warehouse.
• Develops and maintains in-depth understanding of SQL Server, Oracle, BusinessObjects,

Access databases, and Analysis Services.

(ETL) processes for EDW.

development of the EDW.

procedures in the EDW.

of data.

the Associate Director, Data Warehouse and Architecture.

documentation.

environments.

WSDL, SOAP and UDDI

Secondary Duties and Responsibilities

and the accuracy of reporting data.

Qualifications

Education and Experience

minimum four (4) years of systems analysis experience with

experience in medical information systems; or equivalent combination

of education and experience. Experience with healthcare data is

preferred.

Special Skills, Licenses and Certifications

Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS,

normalization, queries, views). Some knowledge of Oracle and Oracle

programming methodologies. Knowledge of data warehousing, data

marts, OLAP, ROLAP, MOLAP, etc. Ability to move data between

systems as needed, effortlessly. High standards for data presentation.

Significant knowledge of PCs, Windows 2000, and related

applications. Understanding of systems and related systems interfaces

and how changes impact various systems.

Performance Based Competencies

Ability to quickly acquire in-depth knowledge of new systems and

software configuration at PHC. Strong written and oral communication

skills with ability to interpret and understand technical requirements.

Excellent analytical skills to troubleshoot and resolve systems

problems. Able to develop procedures to automate jobs and to

document extensively and clearly. Good client relations skills.

Work Environment And Physical Demands

More than 50% of work time is spent in front of a computer monitor.

May be required to bend, stoop, kneel, crawl, or work in other non-standing and non-sitting positions to install cabling, systems hardware,

and other related equipment.

All HealthPlan employees are expected to :

HIRING RANGE :

$136,296.78 - $177,185.82

IMPORTANT DISCLAIMER NOTICE

The job duties, elements, responsibilities, skills, functions, experience, educational factors and the requirements and conditions listed in this job description are representative only and not exhaustive of the tasks that an employee may be required to perform. The employer reserves the right to revise this job description at any time and to require employees to perform other tasks as circumstances or conditions of its business, competitive considerations, or work environment change.