Job Title: Product Specialist 5 (ETL Developer)
NFP rate: $73.59
Interviews: Skype or onsite
Will close to submissions: Wednesday 3/6/2019 at 10:00am EST
DODD operates a significant enterprise suite of applications. Included within this suite are Medicaid related applications and applications supporting health, safety and welfare of DODD consumers. Many of these applications support processes based on ORC statute and Administrative rules as well. In order to have a strong enterprise application suite DODD maintains a Microsoft SQL server environment. This environment supports both the noted applications and associated reporting. In order to maintain a robust database infrastructure DODD continues to optimize existing data structures and provide a framework for migration of data across transactional reporting environments to data warehouse environments. Current ETL work is focused on supporting development of a hub and spoke DW environment to support the DW pilot project within the county boards. This project allows counties better access to key data and maintains health and safety for consumers. DODD is proposing to retain key modeling, and enterprise transformation experts in order to complete the initiative.
The Product Specialist is the expert for a technical development or execution environment product or set of products. The primary responsibility of a Product Specialist is to ensure the availability and facilitate the productive use of a product for Application Teams or end users. The DODD Product Specialist for this engagement will be well versed in COGNOS and standard ETL tools processes and databases associated with BI/DW
DODD is currently seeking a senior level person with complete and demonstrable understanding of data warehousing concepts. Additionally, the candidate should possess a strong knowledge of ETL processes including a complete functional understanding with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments. This understanding would include hands on experience in control and data flow with SSIS. The candidate will also possess fluency in normalization of table structures and have demonstrated modeling experience with hub and spoke architectures. The candidate will be part of the DODD BI DW team working on support and continued enhancements of the aforementioned project.
1. 5 years of supporting ETL in a production environment
a. Understands and can independently setup/configure SISS packages to run in production
2. 4 years of senior level SSIS experience
a. Knows control flow and data flow items and can demonstrate usage of each
3. 4 years Senior level SQL skills that include database development activities
4. 5 years of data modeling experience (hub and spoke, dimensional, data vault)
5. Has a complete understanding of database normalization and can fluently speak about the various normal forms (1st – 6th)
