Job Seekers, Please send resumes to resumes@hireitpeople.comShort Description: *****Microsoft Dynamics CRM 2011 is required ******
Complete Description: 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
Skill | Required / Desired | Amount | of Experience |
Data Architect with Microsoft Dynamics CRM 2011 (additional experience in more current versions is also a plus). | Required | 5 | Years |
normalized Data Modeling and Database Design (dimensional modeling a plus) | Required | 5 | Years |
SQL (PL/SQL is a plus) | Required | 3 | Years |
Hands-on experience with ETL Tools | Required | 3 | Years |
Excellent presentation, communication and customer service skills while maintaining a professional manner. Will be working with the Governor's Office | Required | 5 | Years |
Experience Updating data in CRM 2011 with an ETL tool is required (Scribe Insight experience for managing data manipulations/integrations is a plus) | Required | 3 | Years |
