Job ID :
6509
Company :
Virginia Information Technology Agency
Location :
RICHMOND, VA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
25 Feb 2015
Job Seekers, Please send resumes to resumes@hireitpeople.com

Complete Description:

The primary role of this position is to provide data analysis and architecture support to ITPM development project teams. 

 

•This position will analyze and develop complex database designs, logical & physical data models & architectural system models. 

•This position will assist with the identification and resolution of information flow, content issues and the transformation of business requirements into logical data and system models.

•This position identifies opportunities to reduce data redundancy, trends in data uses, and single sources of data while maintaining an enterprise wide perspective. 

•This position will assist with the development and collaboration of an enterprise wide data model and data dictionary.

•This position is eligible for telework

•This position is not eligible for over-time and will be capped at 40 hours a week.

 

 

What knowledge, skills, abilities, experiences, certifications are needed for this position?

 

•Data Modeling and Database Design (strong knowledge of relational database concepts)

•Ability for an end-to-end vision (see how a logical design will translate into one or more physical databases, and how the Data will flow through the successive stages involved for presentation to an end-user)

•Data Validation, Cleansing, Mapping, Extraction and Migration

•SQL (PL/SQL is a plus)

•Data Integration

•Create and manage Data Dictionaries

•Strong analytical skills, attention to detail and logical thinking

•Ability to understand the business data needs and translate into data models (DFDs, DSDs and/or  ERDs)

•Ability to create ETL specifications and develop data mappings

•Ability to engage in detailed analysis of data discrepancies to determine the source and resolution of errors

•Clear and concise documentation skills

•High level knowledge of programming practices

•Aptitude for learning new technologies/applications/businesses

•Excellent presentation, communication and customer service skills while maintaining a professional manner

•Self-motivated team player – able to work cooperatively in a team environment

•Ability to work under pressure, prioritize and meet deadlines when required

•Remain flexible on changing workloads and priorities

•Ability to communicate with diversified stakeholders

•Data Warehousing is a plus 

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

normalized data modeling and database design (dimensional modeling a plus)

Required

5

Years

data-centric positions or roles

Required

5

Years

data management experience

Highly desired

3

Years

SQL (PL/SQL is a plus)

Highly desired

3

Years

hands on experience with ETL Tools

Highly desired

3

Years

Public Sector experience

Nice to have

2

Years

strong knowledge of relational database concepts

Required

5

Years

Data Validation, Cleansing, Mapping, Extraction, Migration, Integration

Required

5

Years