Business Systems Analyst II

Jobtailor; San Ramon (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

Jobtailor is seeking a Business Systems Analyst to analyze business problems and translate them into effective system solutions. You will gather requirements, document processes, and collaborate with stakeholders, QA, and development to deliver end-to-end ERP enhancements.

The role requires 4+ years in business systems analysis, strong SQL skills, and experience with ERP platforms such as PeopleSoft. You will work in a fast-paced environment, coordinating testing and documentation across teams.

Qualifications

• Bachelor’s degree or equivalent experience.
• 4+ years in business systems analysis or related area.
• Proven experience supporting enterprise applications and ERP systems.
• Strong understanding of the Software Development Lifecycle (SDLC).
• Advanced SQL skills and ability to build complex queries and reports.
• Experience with ERP platforms such as PeopleSoft or similar.
• Proficiency with Microsoft Office tools.
• Familiarity with system integrations and data flows across applications.
• Strong analytical thinking and problem-solving capabilities.
• Ability to translate business needs into technical requirements and vice versa.
• Effective communication with both technical and non-technical stakeholders.
• Experience creating detailed documentation, process flows, and test plans.
• Ability to manage priorities and meet deadlines in a fast-paced environment.
• Demonstrated customer service mindset and adaptability.

Responsibilities

• Analyze business problems and identify system-based solutions aligned with goals.
• Gather, document, and validate requirements with stakeholders.
• Evaluate options and recommend optimal approaches.
• Ensure processes supported by system capabilities.
• Develop functional and system requirements for enhancements and integrations.
• Assess impacts of changes for end-to-end solution integrity.
• Create process flows, documentation, and design artifacts.
• Design and execute integration and user acceptance testing.
• Develop test plans and validate system behavior against requirements.
• Collaborate with QA and development teams to ensure quality releases.
• Provide day-to-day support for ERP production systems and troubleshoot issues.
• Create complex ad hoc reports and queries.
• Lead or support system enhancements and process improvements.
• Collaborate with stakeholders, developers, and QA to deliver solutions.
• Provide guidance to junior analysts on requirements, testing, issue resolution.
• Participate in special projects and strategic initiatives.

Skills

Analytical thinking

Problem solving

Customer service mindset

Adaptability

Time management

Education

Bachelor’s degree in related field

Tools

SQL

PeopleSoft

ERP systems

Microsoft Office

Job description

Responsibilities

• Analyze business problems and identify system-based solutions that align with organizational goals.
• Gather, document, and validate business and functional requirements with stakeholders.
• Evaluate multiple solution options and recommend optimal approaches.
• Ensure business processes, policies, and procedures are effectively supported by system capabilities.
• Develop detailed functional and system requirements for medium-scale enhancements and integrations.
• Assess upstream and downstream impacts of system changes to ensure end-to-end solution integrity.
• Create process flows, system documentation, and design artifacts to support development efforts.
• Design and execute integration and user acceptance testing for new systems and enhancements.
• Develop test plans and validate system behavior against business requirements.
• Partner with QA and development teams to ensure quality delivery and successful releases.
• Provide day-to-day support for ERP production systems, troubleshooting and resolving complex user issues.
• Create complex ad hoc reports and queries to support business needs.
• Lead or support implementation of system enhancements, defect fixes, and process improvements.
• Collaborate with business stakeholders, developers, and QA teams to deliver end-to-end solutions.
• Provide guidance and support to junior analysts on requirements, testing, and issue resolution.
• Participate in or lead special projects and strategic initiatives.

Requirements

• Bachelor’s degree in a related field or equivalent experience.
• 4+ years of experience in business systems analysis or related functional area.
• Proven experience supporting enterprise applications and ERP systems.
• Strong understanding of the Software Development Lifecycle (SDLC).
• Advanced SQL skills and ability to build complex queries and reports.
• Experience with enterprise systems (e.g., ERP platforms such as PeopleSoft or similar).
• Proficiency with Microsoft Office tools.
• Familiarity with system integrations and data flows across applications.
• Strong analytical thinking and problem‑solving capabilities.
• Ability to translate business needs into technical requirements and vice versa.
• Effective communication with both technical and non‑technical stakeholders.
• Experience creating detailed documentation, process flows, and test plans.
• Ability to manage priorities, meet deadlines, and work in a fast‑paced environment.
• Demonstrated customer service mindset and adaptability.

Hard Skills

• Business Analysis
• Functional Requirements Gathering
• System Documentation
• Test Plan Development
• Process Flow Creation
• Integration Testing
• User Acceptance Testing
• Complex Query Building
• System Enhancements
• Data Flow Analysis

Soft Skills

• Analytical Thinking
• Problem Solving
• Customer Service Mindset
• Adaptability
• Time Management