Job Description :
Title : Product Specialist 5/PS5 - 48825

Location : 43215,Columbus,OH

Duration : 9 + Months

Job Type : C

Description :

The Product Specialist is the expert for a technical development or execution environment product or setoff 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, Tableau and SSRS development as well as OLTP/OLAP/Data warehouse modeling including multidimensional modeling and standard ETL tools processes and databases associated with BI/DW.

The Department of Developmental Disabilities (DODD) is the fourth largest state agency with over3000 employees providing direct care to individuals. Over 300 staff located in central Ohio, provide oversight for almost 100,000 individuals receiving services from county boards; central office staff also administer 3 Medicaid waiver programs whose8000 providers deliver service and supports to 27,000 individual’s representing1.2 billion dollars in claims. The Datawarehouse program was implemented to provide data integration using cutting-edge technologies to support business process improvement. The data warehouse is built on cutting edge technologies and hardware with demonstrated cost benefits. The warehouse presents data in a common aggregated format supported by advanced ETL processes that allow users to do adhoc reporting on data in order to allow for fresh perspectives on data while supporting common results. The approach also maintains access to historical data reporting. DODD has focused on multi-faceted approach to ensure success of the project. Efforts include infrastructure, ETL, and process.

Skills :

DODD is currently seeking a senior level person with complete and demonstrable understanding of data warehousing/business intelligence concepts. Additionally, the candidate should possess a strong knowledge of Cognos, Tableau and SSRS development. Understanding ETL with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments would be desirable. The candidate will also possess fluency in normalization of table structures and have demonstrated modeling experience with hub and spoke architecture. The candidate will be part of the DODD BI DW team working on support and continued enhancements of the aforementioned project.


Five years of experience with Cognos, Tableau and SSRS development.

Five years of experience with OLTP/OLAP/Data warehouse modeling.

Understanding of ETL/ETL using SSIS/TSQL would be desirable.

Please fill up details below if you would be interested and would like to be considered for it

Consultant Details:

Full Legal Name:

Current Location:



Work Authorization:

Expected salary:

Total Years of Experience:

Currently on Project:

Last 4 digits of S.SN:

Availability to start after interview:

If you are not interested but know someone who might be interested, please refer that person to us. We would be happy to offer you referral bonus if your referral accepts the assignment and stays for at least 3 months.