Job Title: Programmer 5 / PR5
Interviews: Two rounds. Skype/phone for first round acceptable. Short phone interview for second round.
Will close to submissions Friday, 12/8/17 at 10:00am EST
Job Description:
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 SQL and data quality using tools like Cognos, Tableau, SSRS and SSMS as well as understanding 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 over 3000 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 whose 8000 providers deliver service and supports to 27,000 individuals representing 1.2 billion dollars in claims. The data warehouse 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 ad hoc 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.
DODD is currently seeking a data quality assurance person with complete and demonstrable understanding of transactional data, data warehousing and business intelligence concepts. Additionally, the candidate should possess strong skills in understanding business requirements, data flow, data integrity and business flow. Candidate should be able use tools like Cognos, Tableau, SSRS, SQL Server Management Studio and Excel for doing data quality analysis. Candidate should also have fluency in writing SQL and understanding data models. The candidate will be part of the DODD BI DW team working on support and continued enhancements of the aforementioned project.
Requirements:
Five years of experience with writing SQL and data quality analysis.
Two years of experience with using tools like Cognos, Tableau, SSRS and SSMS.
Understanding OLTP/OLAP/Data warehouse modeling.
