Business Analyst

Job description

A business analyst must have the analytical capabilities to work with data. They must first be able to extract data from a database. Business analysts use SQL reports to track and analyze key performance metrics.

Skills : Integrations, SQL, Business Analysis

Responsibilities:

Use statistical methods to analyze data and generate useful business reports

BA with SQL hands on plus integrations knowledge.

Work with management team to create a prioritized list of needs for each business segment

Identify and recommend new ways to save money by streamlining business processes

Use data to create models that depict trends in the customer base and the consumer population as a whole

Work with departmental managers to outline the specific data needs for each business method analysis project

Sql, Python and Power BI skill is Preferred

Good Knowledge of Excel

Data collection for generating MIS reports

Knowledge on Power BI and preparing Dashboards

Excellent oral and written communication skills with ability to develop and deliver high quality presentations

Perform data analysis to identify process improvements

Experience in Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.

Creating & Modifying of tables, fields, constraints in MS SQL Server

Creating / modifying stored procedures in MS SQL Server.

Scheduling / modifying Jobs to automate in MS SQL Server.

Knowledge on creating Views / Triggers / Functions

Good / Basic knowledge on handling MS Access Database.

Knowledge of SQL Server Analysis Services (SSAS), Integration Services (SSIS) and Reporting Service (SSRS).

Requirements:

BA with SQL hands on plus integrations knowledge.

Strong programming knowledge in SQL and integrations.

Ability to collaborate effectively and work as part of a team.

Good communication skills