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