Call for Consultancy - Data Architect & Power BI Analyst at Medecins Sans Frontieres (MSF)

Call for consultancy - Data Architect & Power BI Analyst  
Type of Contract 

• Framework Agreement 

Duration 

• 1 Year 

     
Objectives: 

• Design and implement a robust data architecture to support data storage, retrieval, and analytics. 
• Develop data management strategies, including data governance, data quality assurance, and data integration. 
• Implement appropriate data security measures and data backup and recovery procedures. 

     
Consultant profile requirements 

• Data Modeling and Database Design: Strong expertise in data modeling techniques and database design principles. Proficiency in creating logical and physical data models to represent complex business requirements. 
• Data Integration and ETL: Experience in designing and implementing data integration processes, including extraction, transformation, and loading (ETL) workflows. Knowledge of ETL tools and methodologies for data consolidation and data quality management. 
• Data Warehouse and Data Lake: In-depth understanding of data warehousing concepts and architecture. Familiarity with building and managing data lakes, including schema design, data partitioning, and data governance. 
• Data Governance and Compliance: Knowledge of data governance practices, policies, and frameworks. Understanding of data privacy regulations and compliance requirements, such as GDPR or CCPA. 
• Data Analytics and Business Intelligence: Strong understanding of data analytics and business intelligence concepts. Experience in defining data analytics requirements, designing analytics solutions, and implementing reporting and dashboarding capabilities. 
• Data Architecture and Cloud Technologies: Proficiency in data architecture principles and familiarity with cloud data platforms, such as Microsoft Azure or Amazon Web Services (AWS). Knowledge of cloud-based data services, data lakes, and data warehouses. 
• Data Security and Data Protection: Understanding of data security practices, encryption methods, and data protection mechanisms. Ability to implement security controls and ensure data privacy and confidentiality. 
• Data Migration and Integration: Experience in data migration projects, including data mapping, data transformation, and data validation. Familiarity with integration patterns and technologies for integrating disparate data sources. 
• Data Quality Management: Knowledge of data quality assessment and management techniques. Ability to define and implement data quality rules, data profiling, and data cleansing processes. 
• Communication and Collaboration: Excellent communication skills to interact with stakeholders, gather requirements, and effectively communicate data architecture designs and recommendations. Ability to collaborate with cross-functional teams and present complex technical concepts to non-technical stakeholders. 
• A minimum of 3 organizations worked for with proof indicating the sectors (attach contracts first page and the signature page 
• Proof of Tax Compliance 

3.0 Proposal Format 
The proposal should include the following information: 

• Executive Summary: A brief summary of your proposal demonstrating a clear understanding of the scope of work and how the consultant intends to meet the deliverables with timelines. 
• Consultant profile & certificates – experience details should be sufficiently provided including reference letters where possible. MSF EA shall conduct a due diligence on all the information provided. 
• Consultant Rate Card 

4.0 Evaluation of Proposal and Evaluation Criteria  
Responses will be evaluated based on the following criteria: 

Criteria 
Score(%)

• Suitability of the consultant profile requirements     40%
• Experience in Similar Assignments     40%
• Rate Card    20%

5.0 Terms and Conditions  

• This document contains proprietary and confidential information. Recipients may use or reproduce the information detailed within this document and any other supporting information only to provide a response to this RFP. No commitment will be made to any agency/consultant unless a contract has been awarded and signed by both parties. We reserve the right to cease this exercise at any time. During the period of this activity, no contact should occur between any members of the supplier's staff and organizational staff in relation to this exercise other than through the designated contact points as detailed within this RFP    

6.0 Ethics  

• Applicants are required to observe our procurement ethical code of conduct which includes but is not limited to observing the highest standard of ethics regarding corruption, collusion, conflict of interest and fraud. If the agency does not observe confidentiality or ethical practices, they shall be disqualified from any future work. 

7.0 Non-Disclosure and Confidentiality  

• The information contained within this document or subsequently made available to the consultant is deemed confidential and must not be disclosed without the prior written consent unless required by law. 

8.0 Independent Proposal 

• By submitting a financial proposal, the consultant warrants that the prices in the proposal have been arrived at independently, without consultation, communication, agreement or understanding for the purpose of restricting competition, as to any matter relating to such prices, with any other potential consultant or with any competitor. 

9.0 Proposal Submission Process  

• It should be noted that this document relates to RFP only and not a firm commitment to enter into a contractual agreement. In addition, MSF EA will not be held responsible for any costs associated with the production of a response to this RFP 

Submission of the Proposal 

• The proposal should be no more than 15 pages in length, including all appendices and attachments. 
• The proposal should be submitted to procurement@nairobi.msf.org  on or before 18th July 2023 at 1700hrs (East African Time) and marked as follows on the subject line: 

CALL FOR CONSULTANCY- DATA ARCHITECT & POWER BI ANALYST 
All quotes should be in USD