Data Architect

Responsibilities
Proven experience in data architecture, integration, design and delivery;
• Proven experience in designing data architectures for scalability and performance;
• Proven experience with logical and physical data modeling and related tools (e.g., Erwin);
• Proven experience in the development of plans and management of data migration on large-scale implementation projects;
• ETL and data mapping experience (5+ years);
• Experience in middleware technologies (5+ years);
• Experience in creating dictionaries (5+ years);
• Experience of meeting facilitation skills (5+ years);
• Experience in data caching patterns and data access methodologies;
• Advanced-level experience with SQL;
• Experience with data integration methodologies;
• Experience with SQL Server technologies;
• Experience with Oracle technologies (9i, 10g, 11g, RAC)
• Demonstrable experience with data replication across database instances including standby and high availability databases;
• Experience designing/architecting databases;
• Experience working with Master Data Management tools
• Experience working with development teams
• Experience working with web services
Preferred:
• Knowledge and understanding of the basis EA concepts and EA theory
• Experience working for a governmental agency

Responsibilities include but are not limited to the following:
• Develop scalable, high-performance data architectures that meet organizational needs using proven experience in data architecture, integration, and design;
• Create and manage logical and physical data models with tools like Erwin;
• Oversee data migration plans for large-scale implementation projects;
• Lead ETL processes and data mapping activities, ensuring efficient data flow and transformation;
• Implement and manage middleware technologies to support seamless data integration and apply extensive experience in data integration methodologies;
• Design and manage SQL Server and Oracle databases for optimal performance and scalability, leveraging advanced SQL skills and experience with Oracle technologies;
• Develop and maintain data dictionaries and documentation, ensuring data consistency and quality through effective data access methodologies and caching patterns