Business Systems Analyst

IT Services and IT Consulting · 201-500 employees

Sep 28

Remote Mid (2-5 yrs) Full-time

Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The Business Systems Analyst will gather and document business requirements while analyzing processes to identify improvement opportunities. They will also translate these requirements into technical specifications and support data integration, validation, and quality checks.

What they look for

SQL Business Analysis Data Analysis Requirements Gathering Process Mapping Power BI Tableau Excel ETL Data Modeling Jira Confluence Agile Scrum Python UAT

Requirements

Candidates must have a bachelor's degree in a related field and 2-5+ years of experience in business or systems analysis. Proficiency in SQL, relational databases, and business intelligence tools is required, along with strong communication and documentation skills.

Full description

This is a remote position.

• Gather and document business requirements from stakeholders.

• Analyze business processes and identify opportunities for improvement.

• Translate business requirements into functional and technical specifications.

• Analyze data from databases, applications, and business systems.

• Write and optimize SQL queries to extract and validate data.

• Create data mappings, data dictionaries, and process documentation.

• Work with developers, data engineers, and database teams to implement solutions.

• Perform data validation, reconciliation, and quality checks.

• Support data integration, migration, and transformation projects.

• Create reports, dashboards, and data visualizations when needed.

• Investigate data/system issues and perform root-cause analysis.

• Develop test cases and participate in system, integration, and user acceptance testing (UAT).

• Document workflows, business rules, system requirements, and system changes.

• Communicate findings and recommendations to business and technical stakeholders.

• Support production systems and troubleshoot issues after implementation.

Requirements

Technical skills

• SQL — usually one of the most important skills.

• Relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL.

• Excel, including PivotTables, XLOOKUP/VLOOKUP, formulas, and data analysis.

• Business intelligence tools such as Power BI or Tableau.

• Understanding of data warehouses, ETL/ELT, APIs, and data integration.

• Familiarity with data modeling and database concepts.

• Experience with Jira, Confluence, Azure DevOps, or similar tools.

• Understanding of SDLC and Agile/Scrum methodologies.

• Basic knowledge of programming or scripting such as Python can be beneficial.

Business-analysis skills

• Requirements gathering and analysis.

• Stakeholder interviews and communication.

• Business process modeling.

• Functional requirements and user-story development.

• Process mapping and workflow analysis.

• Gap analysis.

• UAT planning and execution.

• Documentation and presentation skills.

Education:

Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics, or a related field.

• Approximately 2–5+ years of experience in business analysis, systems analysis, data analysis, or a related role, depending on the position.

• Experience working with both business users and technical teams.