Senior Data Warehouse ETL Developer

Partnership HealthPlan of California•Fairfield, CA

About The Position

Responsible for the development of all processes necessary to complete all phases of theEnterprise Data Warehouse (EDW). This includes source identification, data collection, datatransformation, normalization, rule administration, error detection and correction, dataconsolidation, data storage, data distribution, schema mapping, data enrichment, and datagovernance.

Requirements

Bachelor's degree in Computer Science, Business, or related field;minimum four (4) years of systems analysis experience withexperience in medical information systems; or equivalent combinationof education and experience.
Knowledge of databases (SQL Server, BusinessObjects, Access, SSIS,normalization, queries, views).
Some knowledge of Oracle and Oracleprogramming methodologies.
Knowledge of data warehousing, datamarts, OLAP, ROLAP, MOLAP, etc.
Ability to move data betweensystems as needed, effortlessly.
High standards for data presentation.
Significant knowledge of PCs, Windows 2000, and relatedapplications.
Understanding of systems and related systems interfacesand how changes impact various systems.
Ability to quickly acquire in-depth knowledge of new systems andsoftware configuration at PHC.
Strong written and oral communicationskills with ability to interpret and understand technical requirements.
Excellent analytical skills to troubleshoot and resolve systemsproblems.
Able to develop procedures to automate jobs and todocument extensively and clearly.
Good client relations skills.

Nice To Haves

Experience with healthcare data ispreferred.

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 thedevelopment 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 allprocedures in the EDW.
Responsible for coordination with other departments regarding consistency and accuracyof 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 ofthe Associate Director, Data Warehouse and Architecture.
Responsible to train new staff on ETL architecture, ETL standards, and ETLdocumentation.
Responsible for the coordination of the production, development, and sandboxenvironments.
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 usingWSDL, SOAP and UDDI
Performs other tasks necessary to ensure integrity of eCommerce / AMYSIS databasesand the accuracy of reporting data.
Leads and participates in special projects as needed and assigned.
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.