BI Specialist
Ad Talent Africa
Johannesburg, Gauteng, ZA
1d ago

A well-established pharmaceutical industry has an exciting opportunity for a BI Specialist to join the company.

Main Purpose of Job :

To offer interactive visualisation and advanced analytics capabilities that empower the business to make smarter and real-time decisions.

Key Performance Areas :

Summary

  • PowerBI development : data processing, modelling, transformation and building visualisations
  • ETL development using ETL tools and techniques
  • Developing stored procedures, views, joins, aggregates, temp tables, etc
  • Understanding and implementing data processing techniques
  • Understanding and implementing data transformation techniques
  • Data trouble-shooting (source files, source systems, databases, etc)
  • Thorough testing of unit and data set groupings is required
  • Analyse, design and trouble shoot data, visualisations and ETL packages
  • Building reports, dashboards and other visualisations
  • Verbally communicate with team members and other stakeholders and present to small groups
  • Elicit requirements verbally without the benefit of documentation
  • Detail :

  • Understand business requirements in BI context and design data models to transform raw data into meaningful insights
  • Create dashboards and interactive visual reports using Power BI
  • Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
  • Analysing data and present data through reports that aid decision-making
  • Convert business requirements into technical specifications and decide timeline to accomplish
  • Create relationships between data and develop tabular and other multi-dimensional data models
  • Chart creation and data documentation explaining algorithms, parameters, models and relations
  • Design, develop, test and deploy Power BI scripts and perform detailed analytics
  • Perform DAX queries and functions in Power BI
  • Analyse current ETL process, define and design new systems
  • Data warehouse development and work with SSAS, SSIS, and SSRS
  • Redefine and make technical / strategic changes to enhance existing business Intelligence systems
  • Create customised charts and custom calculations as per requirements
  • Design, develop and deploy business intelligence solutions as per needs
  • Work with users and team members at all levels for performance improvement and suggestions
  • EDUCATION

    Bachelor’s degree in Data Analytics,

    Bachelor’s degree with Mathematics and / or Applied Mathematics

    EXPERIENCE .

    Minimum experience of 2 or 3 years working with BI tools or any data-specific roles.

    Must have experience in BI tools, have a sound knowledge of database management, SQL querying, data modelling, data warehousing, business intelligence.

    Experience working ERP solutions would be advantageous.

    SKILLS AND COMPETENCIES :

    Essential

  • Analytical mindset with a problem-solving approach
  • MS SQL
  • Data Processing
  • Data Transformation
  • Data Analysis
  • Testing
  • BI Support and Analysis
  • Visualisations
  • Presentation and Communication
  • Verbal Requirements Elicitation
  • Database Management
  • Advantageous

  • Documentation
  • Research and Implementation
  • C# or similar
  • Excel
  • Dimensional Modelling
  • Stay updated with advancements and best practices in design and development
  • BEHAVIOURAL QUALITIES :

  • Attention to detail,
  • Precise, analytical approach to work tasks.
  • Working without close supervision.
  • Meeting deadlines.
  • Ability to interact with business as well as technical teams
  • Strong communication and management skills
  • Ability to learn and respond quickly to the fast-changing business environment
  • Ability to multitask and excellent interpersonal skills
  • Ability to work in an agile environment with a focus on continuous improvement
  • Self-motivated and eager to learn
  • A team player and able to lead and initiate
  • DESIRABLE SKILLS AND EXPERIENCE :

    Data Analytics :

  • Be able to see the big picture and communicate insights in layman’s terms to everyone in the organisation
  • Able to drill-down data and visualise data in the best possible way through charts / reports / dashboards
  • Software Development Skills :

  • You don't have to be an expert in software development, but to meet diversified needs, know how to develop a custom BI solution.
  • It is essential to understand technical aspects as well as software development architecture to transform requirements into technical presence.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    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