Data Architect – Washington, DC
- Minimum of nine (9) years experience in data analysis or as a programmer/developer
- Minimum of two (2) years experience using ERwin Data Modeling Tool
- Minimum of seven (7) years developing Conceptual, Logical and Physical Data Models
- Minimum of seven (7) years developing Data Flow Diagrams
- Minimum of seven (7) years developing CRUD models
- Minimum of three (3) years experience in Database Design with Oracle 10G+, to include:
- Converted Logical Data Models into Physical Oracle Data Models
- Ability to design performance indexes
- Experience with Data Design Standards
- Experience with Object Oriented Design Methodologies
- Leadership Skills
- Able to facilitate workshops and Data Requirements meetings
- Able to resolve data issues without supervision
- Able to support multiple customers
- Strong Communication Skills: Oral and Written
- Other experience
- Immigration Data
- IDMS Database
- NIEM Information Exchange
- Agile development methodology
- Master Data Management
- Must be a U.S. Citizen
- Must be able to obtain/maintain a USCIS 6C clearance (a level of Public Trust clearance)
- All work must be conducted at work location - No remote work
Essential Job Functions
- Translates business requirements and models into feasible and acceptable data warehouse designs; designs and builds appropriate data repositories and data movements (dimensional databases) to ensure that business needs are met. Creates database models which serve as blue prints for project engagements of all complexities.
- Designs and oversees the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalized and updated and then published to multiple target environments.
- Interacts with clients while designing internal and external data interfaces to ensure that database development needs are according to client specifications; coordinates with clients, external data providers, and business team to ensure that business model is accurately represented and understood by all relevant parties.
- Establishes data standards and policies, data modeling, systems architecture design, and migration system architectures to ensure access to and integrity of data assets.
- Analyzes changes in online transactional processing, business processes, and external information sources and recommends modifications, to improve quality of applications and meet additional requirements.
- Coordinates activities of database analysts and other database personnel to determine appropriate database deployment strategies and parameters, to ensure cost effectiveness and system efficiency.
- Evaluates reusability of current data for additional analysis, while maintaining integrity and confidentiality of information; conducts data cleaning to rid the system of old, unused, or duplicate data for better management or quicker access.
- Develops data warehousing blueprints, evaluates hardware and software platforms, and integrates systems to ensure that integration is effective and meets client specifications.
Qualifications
Basic Qualifications
- Bachelor's degree or equivalent combination of education and experience
- Bachelor's degree in information science, data management, computer science or related field preferred
- Nine or more years of experience in data analysis or computer programming
- Experience working with domain structures, user authentication, and digital signatures
- Experience working with company hardware and software products to make sound financial recommendations
- Experience working with programming design and coding languages
- Experience working with industry standards, regulations and guidelines in database warehousing and other relevant systems
- Experience working with information security practices and available security software packages
- Experience working with relational databases
Other Qualifications
- Strong personal computer and business solutions software skills
- Strong skills in data administration, design and architecture
- Leadership skills to guide and mentor the work of less experienced personnel
- Strong communication skills to communicate with customers, team members, external data providers and management
- Ability to deal with and resolve ambiguity
- Ability to anticipate problems and take decisive action
- Willingness to travel
November 27, 2011
• Tags: Data Architect, Dc, District Of Columbia Us, US Citizenship Required Job in Washington, Washington • Posted in: General