Job Seekers, Please send resumes to resumes@hireitpeople.comInt. type - Either Phone or In Person.
Complete Description: Position is eligible for partial telework. Not 100% telework. Must work onsite majority of time. Must have very strong communication skills. Must have very strong communication skills. Extension likely.
Job Description- The primary role of this position is to provide data architecture support to ITPM development project teams. ITPM is currently seeking a hands-on data architect to assist with the re-architecting effort of a critical Agency 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.
• This position is not eligible for over-time and will be capped at 40 hours a week.
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
• Experience manipulating databases within/through an enterprise COTS package (i.e. Microsoft CRM or Dynamics, PeopleSoft, eGRC RSA Archer, etc.) 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 is a plus
• 3+ years of SQL (PL/SQL is a plus)
• Hands-on experience with ETL Tools is a plus
• Public Sector background/experience is a plus
Preferred Education:
• Bachelor degree in related field is preferred, but not required.
Skill | Required / Desired | Amount | of Experience |
normalized data modeling and database design | Required | 5 | Years |
extensive experience mapping data and building out data integrations between disparate database systems | Required | 5 | Years |
understand the business data needs and translate into data models (DFDs, DSDs and/or ERDs) | Required | 5 | Years |
integration between COTS package databases and relational databases | Required | 4 | Years |
data validation, cleansing, mapping, extraction and migration | Required | 5 | Years |
SQL (PL SQL is a plus) | Required | 5 | Years |
manipulating databases within/through an enterprise COTS package (ie Microsoft CRM or Dynamics, Peoplesloft, eGRC RSA Archer, etc.) | Required | 4 | Years |
Data Warehousing | Desired | 2 | Years |
Business Intelligence | Desired | 2 | Years |
hands-on experience with ETL Tools | Required | 4 | Years |
