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.

• 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.
• Responsible for developing SSIS packages used in the Extract, Transform, and Load
  (ETL) processes for EDW.
• Provides guidance for all Master Data Management (MDM) aspects involved in the
  development of the EDW.
• Responsible for understanding all development in the area of MDM and ETL.
• Responsible for the transition of documentation, security, development, and testing of all
  procedures in the EDW.
• Responsible for coordination with other departments regarding consistency and accuracy
  of data.
• Works with Web Team on development and coordination of ETL and other processes.
• Uses sound technical judgment and makes appropriate systems decisions in absence of
  the Associate Director, Data Warehouse and Architecture.
• Responsible to train new staff on ETL architecture, ETL standards, and ETL
  documentation.
• Responsible for the coordination of the production, development, and sandbox
  environments.
• Designs, develops, tests, and supports client server applications using C# and ASP.NET
• Experience in working with .NET Web Services, WCF framework and Web API using
  WSDL, SOAP and UDDI

Secondary Duties and Responsibilities

• Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databases
  and the accuracy of reporting data.
• Leads and participates in special projects as needed and assigned.

All HealthPlan employees are expected to:

• Provide the highest possible level of service to clients;
• Promote teamwork and cooperative effort among employees;
• Maintain safe practices; and
• Abide by the HealthPlan’s policies and procedures, as they may from time to time be updated.

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.