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.