Business Systems Analyst

Zohorecruit; Kentucky; On-site; USD 60,000 - 90,000; Full time

Job summary

Zohorecruit seeks a skilled Business Analyst to translate business requirements into technical specs and to partner with IT and business teams to deliver data-driven solutions.

The role focuses on requirements gathering, process mapping, data analysis, and creating detailed specifications, reports, and UAT plans. A strong SQL foundation and BI tooling experience are essential.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics or a related field.
• 2-5+ years of experience in business analysis, systems analysis, data analysis, or a related role.

Responsibilities

• 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.

Skills

SQL

Requirements gathering

Stakeholder interviews

Business process modeling

User-story development

Data analysis

Communication skills

SDLC/Agile/Scrum

Python (basic)

Education

Bachelor's degree in Information Systems, Computer Science, Business, Data Analytics

Tools

Power BI

Tableau

Jira

Confluence

Azure DevOps

Job description

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.

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.