Architect | Database Development
Location: Columbus, OH Sr.Consultant-IT Architect Complete Description: Day-to-day expectations of resource(s): 1. Develop CRUD matrix showing the data usage within major applications and for major business processes. 2. Work with clients, business analysts, technical staff, and project team members to plan, design, develop the data usage matrix. 3. Work with the business process and enterprise modeling/mapping artifacts to a data architecture framework. The Data Architect will create a map of enterprise-wide view of the data for multiple business units. This individual will participate in the establishment of an enterprise inventory of data usage and metadata. Major Position Responsibilities: •Develop CRUD matrix showing the data usage within major applications and for major business processes. •Work with clients, business analysts, technical staff, and project team members to plan, design, develop the data usage matrix. •Work with the business process and enterprise modeling/mapping artifacts to a data architecture framework. Experience: •At least five years of enterprise data modeling experience. •At least eight years of enterprise data architecture experience. •At least eight years of data warehouse modeling experience. •At least eight years of experience with Erwin. •Proven ability to distinguish data and architectural requirements at system level, project level, department level and enterprise level. •Able to perform requirements definition, analysis, data pattern analysis and design in support of enterprise data integration efforts. •Have the ability to create/maintain multi-subject area enterprise and canonical models that will support company's Enterprise Data Architecture strategy. •Experience in business process frameworks and business process modeling. •Excellent communication and technical writing skills. •Familiar with object modeling concepts and object relational mapping. •Familiar with metadata management tool. •Familiar with business intelligence tools such as MicroStrategy or Business Objects. •Familiar with Teradata data warehouse. •Familiar with financial services, insurance industry domain and terminologies. •Capable of working independently and managing multiple client demands. •Knowledge of IBM Insurance (IAA) data models a plus. REQUIREMENTS: Data Architecture Required 5- Expert Knowledge Enterprise Data Modelling Required 5- Expert Knowledge The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.