Data / Business Intelligence Analyst at Intelfort Nigeria Limited

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.
• 3 years work experience (However, are considerations for very intelligent candidates with the potential to deliver value within a short time maximum 6 months).
• 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 Phyton 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).