{bc}
workable

Business Systems Analyst Intern

Weekday
Bengaluru, IND
Full-time
Intern · 3–4 years experience
Onsite
INR 4 - 10
Discovered 2 days ago
excelsql

Full Job Posting

A. Business Requirements Analysis

Interact with business stakeholders to understand existing workflows, operational challenges, and system improvement requirements.

Ask relevant questions to clarify requirements, identify missing information, and understand business expectations.

Translate business needs into structured requirement documents, functional specifications, user stories, and actionable tasks under guidance.

Identify process gaps, dependencies, exceptions, and opportunities for automation.

Assist in defining acceptance criteria and expected system behavior.

B. Business Process Mapping and Documentation

Document existing business processes and recommend potential improvements.

Prepare workflow diagrams, process flowcharts, Standard Operating Procedures (SOPs), and functional documentation.

Maintain clear records of business rules, system validations, dependencies, and exception scenarios.

Incorporate stakeholder feedback and update documentation as requirements evolve.

Ensure that requirements are clearly communicated to both business users and technical teams.

C. Functional Testing and System Validation

Prepare and execute test cases for ERP enhancements, internal tools, and business applications.

Validate standard workflows, invalid inputs, boundary conditions, and exceptional scenarios.

Identify defects, document reproduction steps, and coordinate with developers for resolution.

Verify bug fixes and conduct regression testing when required.

Support User Acceptance Testing (UAT) and help business users validate system functionality.

D. Data Analysis and Reporting

Use Microsoft Excel or Google Sheets to analyze operational data, identify discrepancies, and prepare reports.

Apply basic SQL queries to retrieve, validate, and investigate data from databases.

Assist in identifying data inconsistencies and investigating their potential root causes.

Support operational reporting, KPI tracking, and data-driven decision-making.

Ensure data accuracy and consistency across business systems.

E. Business Systems and Automation Support

Assist with ERP enhancements, workflow automation, and system integration initiatives.

Coordinate with developers and business stakeholders to clarify requirements and track deliverables.

Research tools and technology solutions that can improve operational efficiency.

Use AI tools to support research, documentation, and test-case creation while independently validating generated outputs.

Track assigned tasks, communicate blockers proactively, incorporate feedback, and ensure timely completion.

Educational Background

Bachelor's degree in Engineering, Computer Applications, Information Technology, or a related discipline; final-year students and recent graduates may apply.

An MBA from a reputed institution is mandatory.

Must-Have Skills

Logical Reasoning: Ability to break down unfamiliar problems, recognize patterns, and arrive at logical conclusions.

Analytical Reasoning: Ability to interpret information, analyze data, identify relationships, and evaluate possible solutions.

Critical Thinking: Ability to question assumptions, identify inconsistencies, evaluate alternatives, and assess whether a proposed solution is practical.

Strong attention to detail and a structured approach to problem-solving.

Clear written and verbal communication skills in English.

Basic computer proficiency, including spreadsheets, documents, and presentation tools.

Learning agility, adaptability, and the ability to understand new systems and business processes.

Ownership of assigned tasks, openness to feedback, and the ability to communicate progress independently.

Prior experience with SQL, Excel, ERP systems, APIs, or software testing is beneficial but not mandatory. Candidates with strong analytical fundamentals and a willingness to learn will be considered.

Good-to-Have Skills

SQL: Basic understanding of queries, filtering, and data retrieval.

Excel / Google Sheets: Familiarity with formulas, sorting, filtering, lookups, and data validation.

ERP Systems: Awareness of enterprise applications and how they support business operations.

Familiarity with process mapping, flowcharts, structured documentation, and workflow analysis.

Basic understanding of software applications, databases, and system integrations.

Exposure to AI tools and the ability to verify AI-generated information.

Academic projects, internships, or practical examples demonstrating analytical thinking and problem-solving.

Advanced technical proficiency is not expected at the time of joining.

Selection Process

Round 1: Analytical and Critical Thinking Assessment A timed assessment covering logical reasoning, numerical reasoning, data interpretation, identification of inconsistencies, and business problem-solving.

Round 2: Business Case Study Candidates will analyze a practical business scenario, identify missing information, map the workflow, evaluate exceptions, and propose a structured solution.

Round 3: Basic Technical Assessment A practical evaluation of spreadsheet skills and, where applicable, introductory SQL and data validation.

Round 4: Interview and Discussion An assessment of communication skills, learning agility, response to feedback, attention to detail, and willingness to take ownership.

What We Expect From the Candidate

We do not expect candidates to master every tool or business process from day one. We are looking for someone who thinks logically, asks relevant questions, challenges inconsistencies, documents information clearly, and learns from feedback.

Qualifications

  • Educational Background
  • Bachelor's degree in Engineering, Computer Applications, Information Technology, or a related discipline; final-year students and recent graduates may apply.
  • An MBA from a reputed institution is mandatory.
  • Must-Have Skills
  • Logical Reasoning: Ability to break down unfamiliar problems, recognize patterns, and arrive at logical conclusions.
  • Analytical Reasoning: Ability to interpret information, analyze data, identify relationships, and evaluate possible solutions.
  • Critical Thinking: Ability to question assumptions, identify inconsistencies, evaluate alternatives, and assess whether a proposed solution is practical.
  • Strong attention to detail and a structured approach to problem-solving.
  • Clear written and verbal communication skills in English.
  • Basic computer proficiency, including spreadsheets, documents, and presentation tools.
  • Learning agility, adaptability, and the ability to understand new systems and business processes.
  • Ownership of assigned tasks, openness to feedback, and the ability to communicate progress independently.
  • Prior experience with SQL, Excel, ERP systems, APIs, or software testing is beneficial but not mandatory. Candidates with strong analytical fundamentals and a willingness to learn will be considered.
  • Good-to-Have Skills
  • SQL: Basic understanding of queries, filtering, and data retrieval.
  • Excel / Google Sheets: Familiarity with formulas, sorting, filtering, lookups, and data validation.
  • ERP Systems: Awareness of enterprise applications and how they support business operations.
  • Familiarity with process mapping, flowcharts, structured documentation, and workflow analysis.
  • Basic understanding of software applications, databases, and system integrations.
  • Exposure to AI tools and the ability to verify AI-generated information.
  • Academic projects, internships, or practical examples demonstrating analytical thinking and problem-solving.
  • Advanced technical proficiency is not expected at the time of joining.
  • Selection Process
  • Round 1: Analytical and Critical Thinking Assessment
  • A timed assessment covering logical reasoning, numerical reasoning, data interpretation, identification of inconsistencies, and business problem-solving.
  • Round 2: Business Case Study
  • Candidates will analyze a practical business scenario, identify missing information, map the workflow, evaluate exceptions, and propose a structured solution.
  • Round 3: Basic Technical Assessment
  • A practical evaluation of spreadsheet skills and, where applicable, introductory SQL and data validation.
  • Round 4: Interview and Discussion
  • An assessment of communication skills, learning agility, response to feedback, attention to detail, and willingness to take ownership.
  • What We Expect From the Candidate
  • We do not expect candidates to master every tool or business process from day one. We are looking for someone who thinks logically, asks relevant questions, challenges inconsistencies, documents information clearly, and learns from feedback.
  • Roles and Responsibilities
  • A. Business Requirements Analysis
  • Interact with business stakeholders to understand existing workflows, operational challenges, and system improvement requirements.
  • Ask relevant questions to clarify requirements, identify missing information, and understand business expectations.
  • Translate business needs into structured requirement documents, functional specifications, user stories, and actionable tasks under guidance.
  • Identify process gaps, dependencies, exceptions, and opportunities for automation.
  • Assist in defining acceptance criteria and expected system behavior.
  • B. Business Process Mapping and Documentation
  • Document existing business processes and recommend potential improvements.
  • Prepare workflow diagrams, process flowcharts, Standard Operating Procedures (SOPs), and functional documentation.
  • Maintain clear records of business rules, system validations, dependencies, and exception scenarios.
  • Incorporate stakeholder feedback and update documentation as requirements evolve.
  • Ensure that requirements are clearly communicated to both business users and technical teams.
  • C. Functional Testing and System Validation
  • Prepare and execute test cases for ERP enhancements, internal tools, and business applications.
  • Validate standard workflows, invalid inputs, boundary conditions, and exceptional scenarios.
  • Identify defects, document reproduction steps, and coordinate with developers for resolution.
  • Verify bug fixes and conduct regression testing when required.
  • Support User Acceptance Testing (UAT) and help business users validate system functionality.
  • D. Data Analysis and Reporting
  • Use Microsoft Excel or Google Sheets to analyze operational data, identify discrepancies, and prepare reports.
  • Apply basic SQL queries to retrieve, validate, and investigate data from databases.
  • Assist in identifying data inconsistencies and investigating their potential root causes.
  • Support operational reporting, KPI tracking, and data-driven decision-making.
  • Ensure data accuracy and consistency across business systems.
  • E. Business Systems and Automation Support
  • Assist with ERP enhancements, workflow automation, and system integration initiatives.
  • Coordinate with developers and business stakeholders to clarify requirements and track deliverables.
  • Research tools and technology solutions that can improve operational efficiency.
  • Use AI tools to support research, documentation, and test-case creation while independently validating generated outputs.
  • Track assigned tasks, communicate blockers proactively, incorporate feedback, and ensure timely completion.

Responsibilities

  • Interact with business stakeholders to understand existing workflows, operational challenges, and system improvement requirements.
  • Ask relevant questions to clarify requirements, identify missing information, and understand business expectations.
  • Translate business needs into structured requirement documents, functional specifications, user stories, and actionable tasks under guidance.
  • Identify process gaps, dependencies, exceptions, and opportunities for automation.
  • Assist in defining acceptance criteria and expected system behavior.
  • Document existing business processes and recommend potential improvements.
  • Prepare workflow diagrams, process flowcharts, Standard Operating Procedures (SOPs), and functional documentation.
  • Maintain clear records of business rules, system validations, dependencies, and exception scenarios.
  • Incorporate stakeholder feedback and update documentation as requirements evolve.
  • Ensure that requirements are clearly communicated to both business users and technical teams.
  • Prepare and execute test cases for ERP enhancements, internal tools, and business applications.
  • Validate standard workflows, invalid inputs, boundary conditions, and exceptional scenarios.
  • Identify defects, document reproduction steps, and coordinate with developers for resolution.
  • Verify bug fixes and conduct regression testing when required.
  • Support User Acceptance Testing (UAT) and help business users validate system functionality.
  • Use Microsoft Excel or Google Sheets to analyze operational data, identify discrepancies, and prepare reports.
  • Apply basic SQL queries to retrieve, validate, and investigate data from databases.
  • Assist in identifying data inconsistencies and investigating their potential root causes.
  • Support operational reporting, KPI tracking, and data-driven decision-making.
  • Ensure data accuracy and consistency across business systems.
  • Assist with ERP enhancements, workflow automation, and system integration initiatives.
  • Coordinate with developers and business stakeholders to clarify requirements and track deliverables.
  • Research tools and technology solutions that can improve operational efficiency.
  • Use AI tools to support research, documentation, and test-case creation while independently validating generated outputs.
  • Track assigned tasks, communicate blockers proactively, incorporate feedback, and ensure timely completion.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Weekday