Job Seekers, Please send resumes to resumes@hireitpeople.com

Complete Description:

The Department of Game and Inland Fisheries (DGIF) is the Commonwealth agency that manages Virginia’s wildlife and inland fish to maintain optimum populations of all species and strives to provide opportunities for all Virginians to enjoy wildlife, inland fish, boating and outdoor recreation. 

This contract will support the IT and Planning and Finance sections by analyzing and implementing approved solutions for the agency's financial data warehouse.  The agency’s financial system is a custom built, tightly integrated suite of applications based on Microsoft technologies.  This position will analyze the existing data warehouse for completeness, consistency and accuracy and review designs, coding and extractions to validate data quality and integrity.  This may require review of data sources to determine data quality errors and/or investigation of issues at the data staging phase.  Based on analysis, the candidate will review and recommend solutions to business owners.  The candidate will be responsible for implementing and thoroughly documenting approved solutions.

A successful candidate will have experience in Microsoft decision support systems, specifically SQL Analysis Services 2000 and SQL Server 2005, and be comfortable working independently in a casual environment with both IT developers and financial business users.

Years of Experience: 

4-7 years of experience in decision support systems, ETL development, and/or data warehouse design.

This candidate needs to get the job done in the 6 weeks allotted.

Skills:

SQL Server 2005

Required 4 Years

SQL Server Analysis Services

Required 4 Years

SQL Server 2000 DTS

Required 4 Years

Microsoft Excel Pivot tables

Required 4 Years

Communication orally and in writing

Required 4 Years

Experience in ETL development, and/or data warehouse design

Required 4 Years

Experience with Decision Support Systems

Required 4 Years