Business Intelligence and Data Analyst

Multigate is a licensed treasury management and cross-border trade solutions provider across Africa. Founded in 2017, Multigate’s vision is to be Africa’s trusted trade infrastructure, unlocking potential and driving prosperity. With its headquarters in London, the organization has operational bases in the United Kingdom, Canada, and Nigeria. 

Multigate is looking to hire a highly motivated and skilled BI Engineer & Data Analyst to join our growing data team. This role will be instrumental in shaping our business intelligence strategy, from building and maintaining our data infrastructure to extracting actionable insights that drive business decisions.

The individual will work closely with stakeholders across various departments to understand their reporting needs, develop data solutions, and communicate findings effectively.

Duties/Responsibilities:

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse.  
• Build and maintain robust and scalable data models that support business needs.
• Ensure data quality and integrity through validation and monitoring.
• Optimize data warehouse performance and ensure data availability.
• Document data processes, data models, and ETL pipelines.
• Collaborate with IT and other teams to maintain and improve data infrastructure.
• Design, develop, and maintain interactive dashboards and reports using Power BI Desktop, Power BI Service, and related tools or other BI tools as may be agreed.
• Collaborate with stakeholders to gather requirements, understand their data needs, and translate them into analytical questions.
• Perform data analysis to identify trends, patterns, and insights that can inform business decisions.
• Develop interactive dashboards and reports using BI tools (e.g., Tableau, Power BI, Looker) to visualize data and communicate findings effectively.
• Conduct ad-hoc analysis to answer specific business questions.
• Present data insights and recommendations to stakeholders in a clear and concise manner.
• Proactively identify opportunities to improve data analysis processes and reporting.
• Implement data refresh strategies and ensure data accuracy and integrity.
• Perform testing and quality assurance of dashboards and reports.
• Troubleshoot and resolve issues related to Power BI reports and data.
• Collaborate with other IT teams and business users to deliver effective reporting solutions.
• Provide training and support to end-users on Power BI functionality and report usage.
• Stay up-to-date with the latest Power BI features and best practices.
• Document technical specifications, data dictionaries, and user guides for developed reports.
• Contribute to the overall improvement of the BI reporting environment.
• Develop and maintain SQL queries for data extraction and manipulation.

• Minimum of 5years experience in a similar role.
• Proven experience in designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.
• Analytical abilities to interpret data and provide meaningful recommendations.
• Strong knowledge of data modeling techniques and ability to build and maintain robust, scalable data models that align with business needs.
• Expertise in ensuring data quality and integrity through validation, monitoring, and troubleshooting processes.
• Experience in optimizing data warehouse performance and ensuring high data availability.
• Hands-on experience with BI tools (e.g., Power BI, Tableau, Looker) to develop interactive dashboards and reports..
• Experience in data analysis to identify trends, patterns, and actionable insights that support business decision-making.
• Ability to perform ad-hoc analysis and develop data visualizations that effectively communicate findings.

Required Skills

• Proficiency in developing SQL queries for data extraction, transformation, and manipulation.
• Ability to translate business needs into data-driven insights and actionable recommendations.
• Ability to work with business users to understand reporting needs and translate them into analytical solutions.
• Python or R for Data Analysis .
• Cloud Platforms (AWS, Azure, or GCP) for data storage and processing

• Career development/Opportunities
• Office perks
• Working with amazing talents
• Role Autonomy