Job Details: Senior Data Warehouse ETL Developer Date: Jan 14 2021

Job Tools

- 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.