Business Analyst

Business AnalystAustin, Texas, United StatesJob DescriptionA 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.SkillsIntegrations, SQL, Business AnalysisResponsibilitiesUse statistical methods to analyze data and generate useful business reportsBA with SQL hands on plus integrations knowledge.Work with management team to create a prioritized list of needs for each business segmentIdentify and recommend new ways to save money by streamlining business processesUse data to create models that depict trends in the customer base and the consumer population as a wholeWork with departmental managers to outline the specific data needs for each business method analysis projectSql, Python and Power BI skill is preferredGood knowledge of ExcelData collection for generating MIS reportsKnowledge on Power BI and preparing DashboardsExcellent oral and written communication skills with ability to develop and deliver high quality presentationsPerform data analysis to identify process improvementsExperience in Extracting, Transforming and Loading (ETL) data from MS ACCESS Database to MS SQL Server.Creating & Modifying of tables, fields, constraints in MS SQL ServerCreating / modifying stored procedures in MS SQL Server.Scheduling / modifying Jobs to automate in MS SQL Server.Knowledge on creating Views / Triggers / FunctionsGood / Basic knowledge on handling MS Access Database.Knowledge of SQL Server Analysis Services (SSAS), Integration Services (SSIS) and Reporting Service (SSRS).RequirementsBA 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