Business Intelligence Analyst at Intelfort Nigeria Limited

Job Summary

• A business intelligence analyst’s analyzes data with the purpose of identifying areas where an organization can improve. They also gather and analyze data with the purpose of providing solutions to potential organizational obstacles.

Responsibilities

• Creating models, reports, and dashboards on PowerBI, SSRS, SQL, Excel.
• Designing services and scripts on SSIS, SSAS, and SSMS.
• Querying data and presenting results in easy-to-understand formats.
• Documenting deployment instructions in line with operating procedures.
• Creating ETL processes and database schemas that represent and support business processes.
• Performing ad-hoc analysis that generate valuable insights to drive strategy, product or other key decisions for the company and our clients.
• Collaborating with business analysts to understand client environments, organizational reporting requirements and propose configuration solutions that meet these.

Desired Skills and Experience

• Bachelor's Degree from a recognized university.
• 1 - 2 years work experience in related field.
• Resident within Lagos State environs.
• Experience working with databases (MSSQL SERVER).
• Knowledge of T-SQL, the ability to write complex inquiries and their optimization.
• Good Knowledge of MS SQL Reporting Services, PowerBI and MS Excel.
• Experience of developing technical documentation.
• Attention to details, the ability to provide the ideas both to technical and non-technical addressees, analytical thought, skill of working in team.
• Knowledge of R or Python programming would be an asset.
• Understanding of Mongo or any No-SQL database is an advantage.
• Good knowledge of operational Data Store / Data Warehouse.
• Strong SQL skills.
• Experience using Python or R for data preparation and analysis.
• Experience using ETL tools to integrate, disconnect data sets.
• Knowledge of Data visualization tools, preferably Microsoft Power BI.
• Experience using Cloud solution for Data analytics, preferably Data tools on Microsoft. Azure (example Azure Synapse analytics, Azure Data Factory, Azure Databricks, Azure Data Lake).
• Experience implementing a Data Warehouse Solution either on-premise or in the cloud (is a plus).
• Background in a highly quantitative field and knowledge of Statistics and Data modelling (is a plus).