Welcome to Simply Hired!

Like what you see here? Check out more Computer Occupations, All Other like this one.

Show Me More

Data Warehouse Architect

Apply Now

Company: Hire IT People

Location: Richmond, VA

Date Posted: August 20, 2014

Source: Hire IT People, LLC

The Department of Game and Inland Fisheries (DGIF) is the Commonwealth agency that manages Virginias 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 agencys 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 ...

The Department of Game and Inland Fisheries (DGIF) is the Commonwealth agency that manages Virginias 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 agencys 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

Show more

Other jobs you might like

  • Data Warehouse Developer

    Ittblazers

    - Virginia

    Greetings, My name is Shibasis and I'm an IT recruiter at ITtrailblazers. Our records show that you are an experienced IT professional with experience in dataearehouse . This...

    28 days ago from TheLadders.com
  • SQL Architect

    NEW

    New York Global Consultants

    - Glen Allen, VA

    SQL Architect - SQL Farm - Perform a Discovery of the SQL Environment, to understand the scope of the environment, collect requirement for target SQL Farm Design. Enumerate the...

    2 days ago from Tech Fetch
  • Senior Data/Information Analyst (SQL/UNIX/Teradata)

    NEW

    Sis-systems Integrations Solutions

    - Richmond, VA

    Title: Data Information Analyst Duration: 8 months Location: Richmond, VA An immediate consulting opportunity for an experienced Data Information Analyst in the Corporate Planning...

    1 day ago from SIS-Systems Integrations Solutions, Inc.
  • Hadoop Developer

    NEW

    Iconma

    - Richmond, VA

    Hadoop Developer Location Richmond, VA (Multiple Location) Duration 7-8 months (Contract to Hire) The Job - Building efficient storage protocols for unstructured data, and data...

    3 hours ago from Dice
  • Oracle CC&B Solution Architect Senior Associate (5977195)

    NEW

    PwC

    - Richmond, VA

    PwC/LoS Overview: Are you interested in the opportunity to work for an industry-leading firm that services clients that include the Fortune 500, and will give you the experience...

    4 hours ago from PwC
  • Data Integrity Architect

    Hire IT People

    - Richmond, VA

    The position will basically be the State Board of Election's Data Sheriff. The successful candidate will dig into our voter registration system database and help us identify and...

    7 days ago from Hire IT People, LLC
  • Hadoop Developer

    Qsi Services

    - Richmond, VA

    Title Hadoop Developer Location Richmond VA Plano TX Wilmington DE Duration 6 Months need data engineers to power its big-data transformation In this role you ll use your...

    9 days ago from WisdomJobs.us
  • IT Data Architect

    Office of the State Inspector General

    - Richmond, VA

    The Virginia Office of the State Inspector General (OSIG) is seeking a highly motivated, experienced professional to further the work of the agency by planing and conducting...

    10 days ago from Office of the State Inspector General
  • Infrastructure Design Engineer - Architect

    Razznet

    - Richmond, VA

    Infrastructure Design Engineer Architect ? Great opportunity for a sharp individual to make an impact on a global organization.? A successful candidate does not have to have...

    10 days ago from RazzNet
  • Data Modeler

    Hire IT People

    - Richmond, VA

    ยท Includes functions to create the conceptual, high-level, and detailed design of the software solution. Usually possesses extensive experience with multiple technical...

    8 days ago from Hire IT People, LLC

Show Me More

Were you satisfied with these results? Yes | No
Thank you for your feedback!