The candidate will be responsible for the design, implementation, support and maintenance of relational database model systems,
Creation/maintenance of conceptual, logical and physical data models,
Database solution design. In this role the candidate will recommend and monitor overall standards and procedures,
Provide solution design guidance to other technical staff, and assist in integrating various systems.
Consult with users to determine requirements needed to guide development of the data models.
Data warehouse expertise in OLAP and relational modeling (3NF/OLTP) with a wide repertoire of domain experiences
Working with day to day Repository Management activities like Model Merging, User Role Creation, User Access Grants, Model Freezing and Model Version Management
Responsible for reverse engineering and synchronizing existing legacy data models
Requirements
5+ years of experience as an Architect or Data Modeler on data warehouse projects using relational and No-SQL technologies
5+ years logical and physical data modeling experience
5+ years with ERwin or other data modeling software
5+ years working with technical developers to strategize solutions to align with business requirements
5+ years working with end users/customers to understand requirements for technical solutions to meet business needs
5+ years identifying and initiating resolutions to customer problems and concerns associated with a data warehouse
5+ years analyzing project requirements and developing detailed specifications
5+ years defining standards and best practices and conducting code reviews
5+ years developing service and ad hoc oriented data models
Very good business knowledge Life Insurance & Annuities