BI Developer

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

· 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

· 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

Education & Experience

Bachelor’s degree in Data Analytics,

Bachelor’s degree with Mathematics and/or Applied Mathematics

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

· 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

Advantageous

· Documentation

· Research and Implementation

· C# or similar

· Excel

· Dimensional Modelling

· Stay updated with advancements and best practices in design and development

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