12+ Months..
 
The Data Architect is a leadership role requiring the ability to develop an in-depth understanding of a clients business, and the ability to look across an entire organization to develop and promote a strategic vision of the data environment, as well as provide guidance on decisions that could affect current or future direction.
This includes: performing data analysis, data modeling, and platform data architecture activities to capture data requirements clearly; organizing the patterns inherent in data; making the complex clear, complete and correct; representing them in a formal and visual way through the conceptual, logical, and physical data models throughout the whole software development and/or implementation lifecycle; and advising development teams and technology management on a wide range of topics, including ecommerce, security, web services, database design and service-oriented architecture SOA..
 
COMPENTENCIES.
Ability to set Data Policy and the technical solution for the management, storage, security, navigation, propagation, and transformation of data.
Specifies recommended DBMS and ETL tools and technologies for structured and unstructured content.
Translate business requirements and functional requirements into technical solutions for both custom and commercial off-the-shelf COTS components.
Creates and maintains a Metadata Repository.
Creates a semantically rich business model of the enterprise problem domain that:
Is independent of any technology solution.
Defines the Content of the business.
Compiles and maintains the Enterprise Schema across all applications.
Enforces principles of good canonical data design.
Produces UML Models using top-down and bottom-up analysis.
Examines and enforces opportunities to provide data reuse, balancing the issues of centralization and replication.
Ensures the preservation of strategic data assets as applications and technologies evolve.
Defines the visual data architecture roadmap seen by key business customers with emphasis on making it easy for users to find the needed data.
Assist with the database development, implementation, and oversight of application design and coding standards.
Develop and maintain database architecture artifacts.
Proactively identify opportunities for database improvements and work with Technology leadership and/or Project Management to introduce improvements into projects.
Work to encourage the adoption of and responsibility for data architectural choices made.
Support process initiatives by advising technical feasibility and long term alignment with EPIs internal architectural road map.
Perform data architecture and code reviews.
Work with development managers to define metrics that can be used as tools to measure the effectiveness of Data Architecture standard.
Work with database administrators to develop solutions that meet or exceed performance requirements for high-volume transaction processing and reporting.
Assist with the root cause analysis RCA of database and data related issues.
Provide timely status updates to project managers and business process owners for assigned deliverables.
Prepare written and verbal reports and briefings.
Resolve complex data problems as needed, including hands-on Data Warehouse solutions, BI, ODS design.
Assist individual development projects as required by deadlines or technological challenges..
 
Must Have:.
Minimum of 5 years of successful data architecture experience.
Strong experience with Requirement Analysis.
Use of object oriented modeling, design, and programming.
Expert Conceptual, Logical, and Physical Data Modeling experience.
Extensive Process Modeling, Flowcharts, Forward Engineering, and Reverse-Engineering techniques.
Hands-on ETL tools and techniques.
Experience in Designing RDBMS for both Transactional OLTP and Dimensional OLAP databases.
Excellent communication and presentation skills..
 
Nice to have:.
BA/BS or equivalent experience preferred.
Experience in a retail environment.
Experience working with heavily custom as well as packaged software systems.