Perform regular analysis on all industry trends and standards according to data warehouse technologies.
Develop all guidelines to design an effective database.
Prepare plans and ensure implementation of EDW as per business requirements.
Assist various departments to manage all activities and ensure adherence to EDW database.
Evaluate all hardware and software according to required standards and assist to configure as per standards.
Manage and identify organizational impact of EDW on processes.
Prepare design requirements to provide support to all MOLAP and ROLAP.
Design financial estimates for all projects and assignments.
Document all project and system requirements.
Plan and develop various database schemas.
Analyze all data from sources and develop logical models for various business intelligence sources.
Monitor all data integrity performance and adopt appropriate tools.
Coordinate with analytical team and collect all technical requirements.
Maintain and develop all physical data models for EDW.
Design and maintain integrity of metadata and recommend appropriate processes for same.