Share this Job

Business Intelligence Analyst

Date: 19-Jun-2019

Location: Dubai, AE

Company: Majid Al Futtaim

Role Purpose:

    This role would be required to develop and maintain interactive and operational reporting solutions for the enterprise. This role   

     will also be responsible for the development, enhancement and maintenance of objects/ artifacts in the existing enterprise data

    integration layer, data warehouse/ data lake that are shared across applications and reporting units.

 

Role Details – Key Responsibilities and Accountabilities:

  • Develop and maintain interactive and operational reporting solutions for the enterprise and prepare code for production deployment.
  • Develop and maintain enhancements to the data warehouse, master data services models, data integration layer, and enterprise data services (stored procedures, views, functions) shared across applications and reporting.
  • Provide evidence for the quality and accuracy of solutions by executing unit and integration test plans and present results for sign-off
  • Support intra-day, weekly, monthly and year-end reporting cycles
  • Comply with the data management principles, policies, standards and best practices as defined by the Data Governance policies.
  • Adhere to all documentation standards, development lifecycle tasks, and status reporting requirements
  • Design, develop, implement and maintain business intelligence data visualizations using Microsoft Power BI
  • Creating and maintaining reports from various sources of data like Oracle Data Warehouse, Oracle EBS, MS SQL, Cloud Solutions, Flat files.
  • Expertise in building data visualizations to highlight patterns in the data from unstructured and structured data sets
  • See/understand the end to end architecture of this project from source system to EDW to data model to Power BI
  • Provide input/guidance on how to improve/update EDW architecture to be scalable/flexible to accommodate additional metrics/requirements for future sprints
  • Hands-on experience, building/updating/extending EDW architecture and data

 

Educational Background Required;

  • Bachelor's degree in Computer Science, Information Systems, or related field, or the foreign equivalent

 

Experience Required for the Role';

  • 8 years of experience in the BI & Analytics domain, minimum 4 years developing and building visualizations using Power BI Desktop and Power BI Service.
  • Should be able to define a data model, create and customize visualizations, hierarchies and drill-down in Power BI.
  • Should have the knowledge of publishing, sharing and exploring data.
  • Should be able to define model with calculated columns, measures, calculated tables using DAX, clean and transform data with the Query Editor.
  • Should be able to customize and design advanced visualizations and optimize Power BI dashboards with a focus on usability and performance.
  • Should be able to configure and setup gateways, developing, maintaining, publishing and supporting dashboards
  • Should have excellent verbal and written communication skills, strong analytical and problem-solving skills. Should analyse functional/non-functional requirements and seek clarifications for better understanding of requirements.
  • Very strong on database concepts, data modelling, stored procedures, complex query writing, performance optimization of SQL queries.
  • Must have developed and deployed 15 code enhancements of reports and/or data integration solutions to production over a 12-month period
  • 5 years of experience with Microsoft Visual Studio & BI Development Studio
  • 3 years of experience troubleshooting existing SQL code to resolve accuracy and performance problems
  • 3 years of experience developing basic report table / database schemas using consistent naming standards and effective use of primary and foreign key constructs
  • Proven hands-on experience on the tools / technologies below is a must;

                Data Warehouse:   

                       * Oracle Data Warehouse

             * Microsoft SQL Server

             * Microsoft SQL Server Analysis Services

      ETL:

             * Oracle Data Integrator

             * Informatica

             * Microsoft SQL Server Integration Services

      Reporting:

             * Oracle Business Intelligence Enterprise Edition

             * Microsoft Power BI