VITA Data Architect 8/12/2016

MCI - Contract Richmond, VA

Company
MCI - Contract
Job Classification
Full Time
Company Ref #
28754320
AJE Ref #
575867041
Location
Richmond, VA
Job Type
Regular

JOB DESCRIPTION

APPLY
MCI - Contract position in Richmond, VA

Candidate must be available for ONSITE interview. This is an onsite only role in Richmond, VA.

Only qualified US CITIZENS and GREEN CARD HOLDERS are welcome to apply. Sorry NO H1 SPONSORSHIP is available for this position. NO THIRD PARTY SPONSORED H1 APPLICANTS will be considered. THIRD PARTY AGENCIES NEED NOT APPLY.

The primary role of this position is to provide data architecture support to Governor's development project teams. ITPM is currently seeking a hands-on data architect to assist with the re-architecting effort of a critical Governor's websites, CRM/Dynamics and other web system which includes multiple data feeds/load processes and data synchronizations. As the data architect assigned to the project, the person in this role will be responsible for the data architecture, data migrations and integrations, and ensuring all data and reporting requirements are met while maintaining the integrity of the data.

* 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, data 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.

Essential Skills/Competencies:
* Extensive experience with Data Modeling and Database Design
* Extensive experience mapping data and building out data integrations between disparate database systems
* Ability to engage in detailed analysis of data discrepancies to determine the source and resolution of errors
* 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)
* Ability to understand the business data needs and translate into data models (DFDs, DSDs and/or ERDs)
* Experience with ETL tools
* Experience with integration between COTS package databases and relational databases
* Data Validation, Cleansing, Mapping, Extraction and Migration
* SQL (PL/SQL is a plus)
* Create and manage Data Dictionaries
* Strong analytical skills, attention to detail and logical thinking
* 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
* 5 yrs. Microsoft CRM 2011 is required (additional experience in more current versions is also a plus).
* Experience Updating data in CRM 2011 with an ETL tool is required (Scribe Insight experience for managing data manipulations/integrations is a plus).

* Data Warehousing is a plus
* Business Intelligence skills are a plus

Experience:
* 5+ years of normalized Data Modeling and Database Design (dimensional modeling a plus)
* 5+ years of experience in data-centric positions or roles
* 3+ years of data management experience
5 yrs. Microsoft CRM 2011 is required (additional experience in more current versions is also a plus).
* Experience Updating data in CRM 2011 with an ETL tool is required (Scribe Insight experience for managing data manipulations/integrations is a plus).

* 3+ years of SQL (PL/SQL is a plus)
* Hands-on experience with ETL Tools
* Public Sector background/experience is a plus

5 years Data Architect with Microsoft Dynamics CRM 2011 (additional experience in more current versions is also a plus)
5 years normalized Data Modeling and Database Design (dimensional modeling a plus)
3 years SQL (PL/SQL is a plus)
3 years Hands-on experience with ETL Tools
5 years Excellent presentation, communication and customer service skills while maintaining a professional manner. Will be working with the Governor's Office
3years Experience Updating data in CRM 2011 with an ETL tool is required (Scribe Insight experience for managing data manipulations/integrations is a plus)