• Application Deadline:
• Position: Business Intelligence and Data Analyst



• Job Type Full Time



• Qualification BA/BSc/HND



• Experience 5 years



• Location Lagos




• Job Field Data, Business Analysis and AI 
  
  

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

Requirements

• 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