Senior BI Analyst
JMR Software (Pty) Ltd
Gauteng, Western Cape, South Africa
1d ago
source : PNet

Guided by a BI Technical Lead and Business Analyst, this role will be responsible for sourcing and transforming a wide range of data across our business into formats that can be used by analysts and end users to develop differentiating business insights.

They will assist in specifying analytical modules using the specified toolsets to enable the analytical teams and business to create and analyse complex analytical models.

Hence, they need to understand and continuously seek to build knowledge of data and information. In addition, they should be able to use the technology and seek to make use of the features therein to deliver value to the business.

The person fulfilling this role will not only analyse and design data models, but also required to investigate data issues, troubleshoot data issues and devise solutions in line with best practice.

A high competency in problem solving capabilities is thus essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to project and operational leadership.

Duties : Analyse business requirements from documents and end-user discussions Analyse business requirements from documents and end-

user discussions. Identify and define the data requirements necessary to support business requirements or integrated application and subject areas.

  • Identify and define the security requirements necessary to protect the data items. Identify and define the business rules associated with the data;
  • these should include all data integrity / constraint requirements. Identify and perform detailed analysis of all data sources for each application and subject area.

    Perform data profiling of data contained in source systems. Provide detailed analysis of all data implemented into the database.

    Provide the data mapping and associated transformation rules for each data items. Ensure that the business requirements and subsequent development activities are supported by accurate information.

    Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-

    level, integrated, etc.). Assist Data Modelers to draw up detailed data models. Assist ETL Analysts to draw up data cleansing specifications.

    Present data quality anomalies and problem areas to business users and source system owners. Validate data models against the business-

    and data requirements. Ensure the quality, accuracy, integrity and conformity to standards of all models. Provide accurate metadata, which allows full understanding of the project data components.

    Identify data and data model inconsistencies and conflicts and assist the users in their resolution. Transition information and assist developers with the data mapping and transformation and provide additional data analysis as required during the development phase.

    Communicate project data-related information to Architects, DBA’s, Developers and Users. Knowledge : You have a strong data modelling background with the ability to interpret business requirements and analyse source system data and then to document transformation rules for developers to interpret to build the required data models.

    A solid background in SQL, information architecture and ETL procedures is required. Experience working on SAP Hana is preferred and highly advantageous.

    Data warehousing principles based on Kimball and Vault patterns Analysis experience in BI Agile Development Knowledge of data profiling and data profiling tools.

    Experience with data quality management strategies and life cycles. Experience : + years' experience as a data analyst in a BI environment.

    Ability to comply to and manage reusable assets under the governance framework of the DSUA and MOU Solid SQL skills Ability to work with data profiling, data quality and reference data toolsets.

    Ability to do cost estimations for new workloads Preferred qualification : - Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field.

    Minimum qualification : - National Diploma in an Information Technology related discipline. Experience : + years' experience as a data analyst in a BI environment.

    Ability to comply to and manage reusable assets under the governance framework of the DSUA and MOU Solid SQL skills Ability to work with data profiling, data quality and reference data toolsets.

    Ability to do cost estimations for new workloads Preferred qualification : - Bachelor’s degree in Computer Science, Statistics, Informatics, Information Systems, Engineering or another quantitative field.

    Minimum qualification : - National Diploma in an Information Technology related discipline.

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form