LOCATION: Lagos,NG
JOB SUMMARY
Work with the Manager-Enterprise Data Warehousing and Analytics Solutions in the design and implementation and integration of all Enterprise Data
Warehouse and Business Intelligence Solutions, including selecting, blue-printing, gathering requirements, designing and rolling out DW and BI solutions to end usersWork with the Manager-Enterprise Data Warehousing and Analytics Solutions in the design and implementation and integration of all Enterprise Data
Ensure high levels of BI availability through support functions and in-depth testing
PRINCIPAL FUNCTIONS
Assess and cultivate long-term strategic goals for EDW and BI development in conjunction with end users, managers, clients and other stakeholders
Direct, organize and lead projects in the implementation and use of new BI software tools and systems
Lead the integration efforts for merging BI platforms with enterprise systems and applications
Design, code, est and document all new or modified BI systems, applications and programmes
Develop the semantic layer, metadata, reports and report definitions.
Assist in the design of databases and data warehouses to ensure interoperability with EDW and BI solutions
Analyze user requirements and, based on findings, design functional specifications for BI front-end applications
Produce ETL design guidelines to ensure a manageable ETL infrastructure for all BI Solutions
Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion
Conduct job duties and responsibilities according to the organizations business systems development methodology and/ or its Systems Development Life Cycle (SDLC) methodology
Design and deliver end-user training and training materials; provide technical support as necessary
Troubleshoot BI tools, systems and software; performance-tune these applications as necessary
Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
Evaluate and select database/ data warehouse components including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions
Conduct research and make recommendations on BI products, services and standards in support of procurement and development efforts.
Assess and cultivate long-term strategic goals for EDW and BI development in conjunction with end users, managers, clients and other stakeholders
Direct, organize and lead projects in the implementation and use of new BI software tools and systems
Lead the integration efforts for merging BI platforms with enterprise systems and applications
Design, code, est and document all new or modified BI systems, applications and programmes
Develop the semantic layer, metadata, reports and report definitions.
Assist in the design of databases and data warehouses to ensure interoperability with EDW and BI solutions
Analyze user requirements and, based on findings, design functional specifications for BI front-end applications
Produce ETL design guidelines to ensure a manageable ETL infrastructure for all BI Solutions
Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion
Conduct job duties and responsibilities according to the organizations business systems development methodology and/ or its Systems Development Life Cycle (SDLC) methodology
Design and deliver end-user training and training materials; provide technical support as necessary
Troubleshoot BI tools, systems and software; performance-tune these applications as necessary
Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
Evaluate and select database/ data warehouse components including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions
Conduct research and make recommendations on BI products, services and standards in support of procurement and development efforts.
EDUCATIONAL REQUIREMENTS
First degree or equivalent in a relevant discipline preferably Computer Science, Information Systems, or Computer Engineering
First degree or equivalent in a relevant discipline preferably Computer Science, Information Systems, or Computer Engineering
EXPERIENCE,SKILLS & COMPETENCIES
Between three (3) and five (5) years directly relevant post-NYSC work experience
Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modelling
Experience with tier-one applications, databases , data warehouses, etc
Oracle 10g/11g, MS SQL Server 2005, Crystal, SAP, SCM, etc
Expertise in OBIEE 11g, Oracle Warehouse Builder and BO Universe design
Demonstrated ability with MS Windows, UNIX, AIX, and OEL operating systems
Demonstrated ability with Oracle and SQL ETL tools.
Strong understanding of relational database structures, theories, principles, and practices
Full project management and development life cycle experience
Experience with database design applications
Experience with data processing flowcharting techniques
Exceptional analytical, conceptual, and problem-solving abilities
Strong understanding of the organizations goals and objectives
Good knowledge of applicable data privacy practices and laws
Strong written and oral communication skills
Strong presentation and interpersonal skills
Able to prioritize and execute tasks in a high-pressure environment
Between three (3) and five (5) years directly relevant post-NYSC work experience
Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modelling
Experience with tier-one applications, databases , data warehouses, etc
Oracle 10g/11g, MS SQL Server 2005, Crystal, SAP, SCM, etc
Expertise in OBIEE 11g, Oracle Warehouse Builder and BO Universe design
Demonstrated ability with MS Windows, UNIX, AIX, and OEL operating systems
Demonstrated ability with Oracle and SQL ETL tools.
Strong understanding of relational database structures, theories, principles, and practices
Full project management and development life cycle experience
Experience with database design applications
Experience with data processing flowcharting techniques
Exceptional analytical, conceptual, and problem-solving abilities
Strong understanding of the organizations goals and objectives
Good knowledge of applicable data privacy practices and laws
Strong written and oral communication skills
Strong presentation and interpersonal skills
Able to prioritize and execute tasks in a high-pressure environment
