Vice President - Enterprise Data Architecture

  • Chennai
  • 25-40 lakh
  • 15-22 years
  • 08 Jun 2015

  • IT/ Information Technology

  • IT/ Technology - Software/ Services, IT/ Technology - Data Center/ Manage Infrastructure Services
Job Description

Enterprise Data Architect will lead efforts to define patterns, standards and data architecture concepts at the enterprise level. He/She will be responsible for standing up and maintaining the framework for Data Architecture and Data Integration.
Build Enterprise Data Model and Data Architecture Framework
Define core data architecture framework
Define standards and guidelines for Data Profiling
Define Data Patterns - Physical structure compares Data Gaps
Define framework for data migration
Define framework for operational data reporting
Define ETL framework
Define guidelines for database capacity planning
Define guidelines and standards for Database backup, archival, and recovery
Define data retention policies
Define Data Security and Accessibility standards and guidelines, Viewing Encryption, Roles, Privileges Blinding / Masking of PHI
Establish Model and Metadata Driven approach
Analyze database and business systems in order to perform data modeling (high level conceptual business/data models, entity-relationship logical data models, and detailed physical database design models).
Design data integration points and conformed dimensions
Oversee design and development of 3NF and Star Schemas, conformed, SCD dimensions
Oversee design and development of specifications for Source to target mapping, table/ column metadata, and transformation rules
Define Standards around data model management, Roles, Access, Model Publication
Definitions of the Entities, relationships
Security and NPI data elements categorization
Data Modeler related responsibilities:-
Create conceptual/logical/physical models for staging, data integration and reporting
Drive model management and version control of data models
Facilitate creation/migration of data objects (DDL) across Development /QA/Production
Drive metadata capture through data modeling application, maintain the repository and exchange of metadata through the various EDW based tools (Informatica, Business Objects, etc.)
Provide hands-on data modeling / development support for a variety of assignments and have a quick grasp of new business environments, Conduct Model reviews with project team members
Participate in requirements definition, analysis, and design of data related solutions
Develop data movement requirements/technical specifications into and across Enterprise layers
Collaborate with ETL team to create data structures that facilitate data integration
Collaborate with DBA team to perform volumetric and optimize data structures for data integration and reporting
In addition the role will involve being responsible for defining and managing governance models, policies and procedures, data cleansing, migration, retention and the strategy and tasks for the decommissioning of legacy systems
Educational Qualification - B.Tech
Experience 17 Years+
Experience in data warehouse design, development, and implementation concepts which include operational data stores, data marts (logical and physical), and metadata management
The ideal candidate must have a proven track record of building large scale data projects from the ground up.
Strong experience in Banking and Financial Services Domain
Strong experience in ETL Frameworks
Hands on experience in design and development of 3NF and Star Schemas
Hands on experience with EDW tools like Informatica, Business Objects etc

Job Posted By

About Organisation