Business Analyst

RxCloud; Austin (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading data analytics firm in Austin seeks a Business Analyst to utilize data analysis and SQL to optimize business processes. The ideal candidate will have experience in integrations, data modeling, and developing comprehensive business reports. Responsibilities include statistical analysis, working with management to identify business needs, and enhancing operational efficiencies. Strong SQL skills and proficiency in tools like Power BI and MS SQL Server are essential for success in this role.

Qualifications

• BA with SQL hands-on experience and knowledge of integrations.
• Strong programming skills in SQL and integrations.
• Ability to collaborate effectively and work as part of a team.

Responsibilities

• Use statistical methods to analyze data and generate useful business reports.
• Work with management to create a prioritized list of needs for business segments.
• Identify new ways to save money by streamlining business processes.
• Create models depicting trends in customer base and consumer population.
• Work with managers to outline specific data needs for analysis projects.
• Perform data analysis to identify process improvements.

Skills

Integrations

SQL

Business Analysis

Tools

Power BI

Excel

MS SQL Server

MS ACCESS

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.