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.
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.
At minimum a Bachelor’s Degree in a related field of study
At least three (3) years’ experiences as a Data Warehouse and Business Intelligence Consultant.
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