Bi Analyst

Somerset West, Cape Town, South Africa

Job Description


Fruitways is an agri-business, specialising in growing, packing and marketing of fresh apples and pears to retailers, traders and wholesalers around the globe.BI ANALYSTThis role requires a motivated, energetic, inquisitive, and highly numerate person who has a solid technical base but also possesses an appreciation for numbers. The successful individual will transform data into insights that drive business value.Responsibilities

  • Conceptualisation, definition, and delivery of new reports
  • Continuous improvement of existing reports
  • Continual search for new and useful ways to obtain, integrate and analyse data that is relevant to the companyxe2x80x99s business model
  • Education of report end-users to ensure a maximum spread of expertise around the company
  • Support report end-users
  • Liaison with the business and IT to:
  • accommodate the customerxe2x80x99s business needs,
  • resolve conflicting user demands,
  • maintain positive customer relations through strong communication and coordination.
  • Identify information requirements through interviews, workshops, business processes and workflow description analysis for identified projects.
  • Model user and information requirements by making use of applicable tools and given scope.
  • Transform data into business intelligence that support business stakeholders in making informed decisions. Must be able to:
  • Extract, transform and load (ETL) data from different data sources such as Datawarehouse, SSAS, production databases, excel files, text files and web data sources into applicable destinations.
  • Develop and build Tabular data models in PowerBI and SSAS making use of the applicable development environments
  • Apply correct mathematical and/or statistical operations in measures given business requirements
  • Make use of Excel, PowerPivot or PowerBI to present information contained in Data Model
Qualifications
  • Undergraduate degree with majors in IS/Maths /Stats/Engineering or similar
  • A minimum of at least 3 years' work experience in a business intelligence role
  • Must have expert experience in Structured Query Language (SQL) and Transact structured Query language (T-SQL)
  • Must have advanced Microsoft Excel skills
  • Solid working knowledge of:
  • Data Modelling
  • Data Analysis Expressions (DAX)
  • MS SQL and MySQL in General
  • Power BI Stack (Desktop, Service, Gateway, Query, Datasets, Dataflows)
  • SSAS
  • Good graphical presentation skills of data
  • Knowledge of data warehouse architecture and methodologies
  • Good interpersonal and communication skills
  • Highly self-motivated, able to work under pressure, and proactive
  • Logical thinking skills
Please note that the position will be filled in alignment with the Groupxe2x80x99s Employment Equity objectives.By submitting your application, you are giving The Fruitways Group implicit consent to the storage and processing of your personal information.Powered by JazzHR

Fruitways

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1341440
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Somerset West, Cape Town, South Africa
  • Education
    Not mentioned