Data Architect (Permanent /Full Time)Relevant Experience (Yrs): 8+ yearsTechnical/Functional Skills:Minimum 8-10 years of industry experience in Data Architecture and Data Modeling using ER Studio or Erwin.Must have full lifecycle project experience as a Data Architect in designing and developing Enterprise Data models.Must have multiple full lifecycle project experience as a Data modeler in modeling for Operational Data Stores, Data Warehouses and Data Marts.Strong understanding of DW conceptsHand on experience in implementing Dimensional and 3NF data models.Understanding of DW appliances, Hadoop, SQL and PL/SQL concepts, standards and best practicesDatabase development, physical database design and data modeling experienceRoles & Responsibilities:Capture new requirements or changed requirements for modeling for new data marts, ODS, data warehouse.Logical and Physical modeling and design for 3NF/dimensional model for ODS/Data Warehouse,Develop/Modify data models as per requirementsStrong experience of data modeling in the Insurance industry, preferably life business, is a must.DDL for database creation on appliances and manage database creation activities from inception to completion including interdependencies with other teamsConversant with designing data structures for Hadoop staging and DW and Data marts hosted in DW appliancesTake an active role in the cross-functional design and coordinate with ETL and reporting teamsWork closely and foster strong relationships with ETL architecture team, database administration and data consumers (e.g., reporting and interfaces teams) to design warehouse/BI data structuresManage the build phase and quality-assure the code to ensure that it meets requirements and adheres to standards; resolve difficult design and build issues; troubleshoot bugsPlan and execute Quality Assurance testing with the QA team and resolve QA defectsPlan and manage QA and Production releases and ensure they are deployed smoothlyGeneric Managerial Skills:Ability to prioritize and work on multiple tasks simultaneouslyStrong communication and organizational skillsAbility to multi-task, prioritize and execute on assigned deliverablesAbility to quickly learn new systems and business processesEducation: Bachelor's DegreeQualifications: please share your profile to Information:Job Status: Full Time / PermanentEligibility: EAD GC/GC/US CitizenShare the Profiles to : Keep the subject line with Job Title and Location