Data Warehouse/Business Intelligence Consultant
The Data Warehouse Business Intelligence (BI) Consultant will work with the BI team to deliver BI Solutions. This individual will help set the direction, strategy, and deployment of data that is critical to the success of the business. Incumbent will perform requirements analysis, data integration, data modeling, design, and BI development to deliver data solutions.
Main Duties:
This position serves as a technical Data Warehouse BI resource for Business Analysts, EDW Data Architects, as well as perform modeling, analysis, design and deployment of data delivery methodologies. Additionally, the candidate will assist with data governance, master data management and process documentation.
This position will be involved in selection, implementation and training of data tools and systems. Responsibilities include analysis of data requirements, resolution of data management and reporting related issues and participation in vendor and/or tool selection.
The incumbent will assist staff with data management and reporting system maintenance and troubleshooting as needed. This role requires strong technical ability as well as strong business acumen.
Skills and Qualifications:
-
Perform high level and detailed data requirements analyses, design and deploy complex data models
-
Maintain and assist in data model documentation, data dictionary, and other MDM\Data Governance documentation
-
Building innovative data management and real-time analytic capabilities needed by the business
-
Translate critical business requirements into actionable tasks
-
Identify ways that the data infrastructure can best support or optimize business growth
-
Recommend/set standards to improve quality of data and speed of analysis
-
Collaborate with Data Architects and Application Specialists on changes associated with systems and interfaces
-
Assist technical teams with data capture, ETL, validation, and test methods
-
Perform data validation tests, QA testing of developed solutions
-
Provide analysis, recommendations to overall strategy to build data warehouse environment and supporting toolsets
-
Thorough knowledge of physical database design and data structures (e.g. OLAP, Dimensional, Snowflake)
-
Knowledge of one or more client-side development environments (e.g. Visual Studio .NET, Eclipse)
-
Thorough knowledge of one or more database systems (e.g. SQL Server, Oracle, Hadoop ).
-
Experience with data management platforms (e.g. SSIS, SSAS, SSRS)
-
Proficiency in SQL.
Academic qualifications:
At minimum a Bachelor’s Degree in a related field of study
Experience:
At least three (3) years’ experiences as a Data Warehouse and Business Intelligence Consultant.
To Apply:
Please eMail (1) one-page cover letter; (2) CV -including 3 (three) relevant referees; Only qualified applicants shortlisted for interviews will be contacted.
Director, Finance and Administration
EITI Africa, P. O. Box 2983-00621
Nairobi, Kenya
Email: info@eiti.tech