Senior Product Analyst: SQL, Process Flows & Agile

System One; Knoxville (TN); On-site; USD 90,000 - 130,000; Full time

Job summary

System One seeks a Senior Product Analyst/System Analyst to join our Knoxville area team. You will analyze complex business processes, translate needs into detailed requirements, and leverage SQL for data investigations within a financial services environment.

The role emphasizes collaboration in Agile squads, developing test cases, and supporting SIT/UAT and end-to-end testing. A Bachelor’s degree in a related field is required.

Qualifications

• 8+ years of experience supporting complex business or technology initiatives as a Product Analyst, Business Analyst, or Systems Analyst.
• Hands-on SQL experience for data analysis, troubleshooting, and production issue investigation.
• Experience developing detailed business requirements, functional specifications, user stories, acceptance criteria, and test cases.
• Experience creating process flows and workflow diagrams with Visio or similar tools.
• Experience in testing, including test case development, defect management, and supporting SIT, UAT, and end-to-end testing.
• Excellent communication skills to articulate complex requirements to stakeholders.
• Knowledge of Jira, Apptio TargetProcess, or comparable Agile/product management tools.
• Understanding of AWS-based application environments and cloud systems is beneficial.

Responsibilities

• Analyze complex business processes, system interactions, and data flows within a financial services and loan servicing environment.
• Translate business needs into detailed requirements and user stories, ensuring clarity for technical teams.
• Utilize SQL for data investigation, validation, troubleshooting, and resolving production issues.
• Support testing phases including SIT, UAT, and end-to-end testing by developing test cases and managing defect resolution.
• Investigate production issues through root cause analysis using system logs, SQL, and scenario reconstruction.
• Collaborate with cross-functional teams, including product, business, technology, QA, and vendor partners, in an Agile environment.
• Coordinate requirements clarification, testing, implementation readiness, and issue resolution with third-party vendors.
• Create process flows and workflow diagrams using Visio or similar tools.
• Support application enhancements and production support, ensuring smooth operations and system performance.

Skills

SQL

Business Analysis

Agile Methodologies

User Stories

Requirements Gathering

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Jira

Apptio TargetProcess

Visio

Job description

System One seeks a Senior Product Analyst/System Analyst to join our Knoxville area team. You will analyze complex business processes, translate needs into detailed requirements, and leverage SQL for data investigations within a financial services environment.

The role emphasizes collaboration in Agile squads, developing test cases, and supporting SIT/UAT and end-to-end testing. A Bachelor’s degree in a related field is required.