Job Description :
Job Title: Data Warehouse Developer - Kimball Methodology
Location: Saint Paul, Minnesota
Duration: 12 Months - Onsite - Contract

Skill:
Kimball Methodologies
MS SQL Server SSIS Developer
BI Reporting
Data Modeling and Analysis tools
Datawarehousing
In-depth understanding of data management
Database languages: MySQL, MSSQL, DB2, Oracle, MS SQL or MS Access
ETL and scripting
Business requirements analysis and specifications

Description:
The Consultant will be working on two projects that will build up an Early Childhood Data Warehouse and move data from the warehouse to an application called Early Childhood Education Outcomes. This resource will be responsible for ETL into the warehouse, developing a scheduling mechanism to easily load new data into the warehouse and manage the dependencies between data sources. New data marts will be needed to support Tableau reporting. In addition, optimization on existing ETL and Stored Procedures needs to be done to allow procedures to be called from Java Applications. Also, the resource will need to improve documentation and data dictionary for end users.

Minimum Requirements:
Five (5) years’ experience in Database Development role (A Master’s degree substitutes for three (3) years of experience, or a Bachelor’s degree substitutes for two (2) years, or an Associate’s degree substitutes for one (1) year)
Two (2) engagements lasting more than six (6) months in Database Development role
Five (5) years'' experience with business intelligence project management.
Five (5) years'' combined experience with MS SQL Server databases and SSIS.
Five (5) years'' combined experience with data modeling and analysis tools.
Five (5) years'' experience with warehouse data modeling using the "Kimball" approach.
Five (5) years'' experience with implementing applications based on SQL in stored procedures and creation of views