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:

\n
• Use statistical methods to analyze data and generate useful business reports
\n
• BA with SQL hands on plus integrations knowledge.
\n
• Work with management team to create a prioritized list of needs for each business segment
\n
• Identify and recommend new ways to save money by streamlining business processes
\n
• Use data to create models that depict trends in the customer base and the consumer population as a whole
\n
• Work with departmental managers to outline the specific data needs for each business method analysis project
\n
• Sql, Python and Power BI skill is Preferred
\n
• Good Knowledge of Excel
\n
• Data collection for generating MIS reports
\n
• Knowledge on Power BI and preparing Dashboards
\n
• Excellent oral and written communication skills with ability to develop and deliver high quality presentations
\n
• Perform data analysis to identify process improvements
\n
• Experience in Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.
\n
• Creating & Modifying of tables, fields, constraints in MS SQL Server
\n
• Creating / modifying stored procedures in MS SQL Server.
\n
• Scheduling / modifying Jobs to automate in MS SQL Server.
\n
• Knowledge on creating Views / Triggers / Functions
\n
• Good / Basic knowledge on handling MS Access Database.
\n
• Knowledge of SQL Server Analysis Services (SSAS), Integration Services (SSIS) and Reporting Service (SSRS).
\n

Requirements:

\n
• BA with SQL hands on plus integrations knowledge.
\n
• Strong programming knowledge in SQL and integrations.
\n
• Ability to collaborate effectively and work as part of a team.
\n
• Good communication skills
\n