BI & Data Lead

Date: Jun 25, 2024

Location: Cairo, Egypt

Company: Magrabi

Job Purpose

The BI & Data Analytics Lead create and maintain warehouse Data and ETL (Extraction, Transformation and Loading) jobs. As well as handling Enterprise to Enterprise implementations including backend/frontend tools. This Support in creating automated reports based on business requirements.

 

Qualifications and Education

  • Bachelor’s Degree in a related field
  • Advance SQL/PLSQL is a must.
  • Advanced at the use of BI Reporting and Analytical tools (SAP Analytics Cloud, SAP Business Objects, Power BI Tableau, MicroStrategy or any other) is a plus.
  • Deep understanding of data modeling and data schemas.
  • Knowledge in cloud data warehouse platforms such as (Snowflake, Databrics, SSIS & BigQuery ) is a plus.
  • Understanding of incremental data loading is a plus.
  • Scripting language (Python, Scala is a plus)
  • Supporting Process design, solution configuration, data architecture and solution testing.

 

Experience

  • 5 - 7 Years of experience in Data Analytics field.
  • Extensive experience in SQL is a must.
  • Experience in SAP Datasphere is a plus.
  • Creating interactive Dashboard Stories in Reporting/analytical tools (SAP Cloud analytics is a plus).
  • Participate in the discovery, definition phase of business metrics and KPIs.
  • Hands on experience in Data Science is a plus.
  • Ability to define test scenarios and test cases.

 

 

Job Responsibilities

  • Manage and handle the data warehouse implementation and monitoring
  • Develop E2E process integration concepts for seamless data flow.
  • Develop and implement front end part including dashboard creation.
  • Create complex Views-Procedures-Functions.
  • Manage ETL jobs.
  • Gather requirements and convey them to technical points.
  • Collaborate with stakeholders in the discovery, definition phase of business metrics and KPIs.
  • Design automated solutions for recurrent reporting (daily/weekly/monthly).
  • Develop new solutions as required based on business needs.
  • Champion data automation initiatives to streamline processes and improve efficiency.