BI Specialist

Main Purpose of Job

To offer interactive visualization and advanced analytics capabilities that empower the business to

make smarter and real-time decisions.

Key Performance Areas (Core, essential responsibilities -outputs of the position)

· PowerBI development: data processing, modelling, transformation and building visualizations

· 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, visualizations and ETL packages

· Building reports, dashboards and other visualizations

· Verbally communicate with team members and other stakeholders, 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 multidimensional 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 customized 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

Requirements:

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 & COMPETENCIES

· Analytical mindset with a problem-solving approach

· MS PowerBI

· ETL

· MS SQL

· Data Processing

· Data Transformation

· Data Analysis

· Testing

· BI Support and Analysis

· Visualizations

· Presentation and Communication

· Verbal Requirements Elicitation

· Database Management

· MS SSIS

· Dax

· C# or similar

· Excel

· Dimensional Modelling

Salt is acting as an Employment Agency in relation to this vacancy.

Job Information

Job Reference: JO-2206-256332
Salary:
Salary per: annum
Job Duration:
Job Start Date: 2022-08-01
Job Industries: Technology
Job Locations: Johannesburg
Job Types: Permanent

Here are some related jobs

×
UK

Upload your CV

Upload your CV to our database.

  • Max. file size: 5 MB.
  • Hidden
  • This field is for validation purposes and should be left unchanged.

Please let us know where you are, or where you would like to be in the world so we can point you in the right direction.

Contact us

  • Max. file size: 5 MB.
  • Click here to find out more about Salt's Privacy Policy
  • This field is for validation purposes and should be left unchanged.

Cookie Consent×

Salt uses cookies to improve the user experience of our site. Cookies allow you to have a more enhanced journey through the site when searching for a specific job or location. Cookies are also used to help us understand how our site is being used. You can find out more about how Salt uses cookies here. By continuing to use the Salt site you are consenting to use our cookies.

OK