Microsoft BI Stack Data Architect

The Ohio Dept of Insurance is looking to add a Technical Specialist 3/TS3 (Data Architect) for a contractor role through the fiscal year 2018.  

Onsite interviews ARE REQUIRED.  Do not submit candidates unavailable to interview onsite.  If a candidate doesn't appear to be local, a bid comment must be included with the submission.

Will close to submissions: 8/16 @ 2PM

The Department’s data warehouse is being developed using Microsoft Data warehouse Tools. OLTP data residing on Oracle is loaded into SQL Server database using SSIS. We are currently
looking for a Data Architect professional who will develop, manage, and model the data warehouse through its life cycle.

The preferred candidate will possess the following skills

8-10 years’ experience with the Microsoft BI Stack (SSAS, SSIS, SSRS).
Experience of delivering BI Solutions across the full project lifecycle.
Experience creating Multidimensional Cubes from scratch (SSAS).
Designing Star Schemas.
Heavy experience with ETL tools (SSIS and any other).
Strong SQL skills.
Lead and conduct conference room pilots and demonstrations.
Ensure proper documentation and on-time delivery of all functional artifacts and deliverables.
Knowledge of MDX skills preferred.
Knowledge of Tableau preferred.