Job ID :
1057
Company :
Virginia Information Technology Agency
Location :
richmond, VA
Type :
Contract
Duration :
6 Weeks
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

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