Senior Product Analyst - Financial Services, Data & SQL

System One; Plano (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

System One is seeking a Senior Product Analyst/System Analyst for Plano, TX (and listed locations). You will analyze complex business processes, translate requirements, and support testing in a financial services context.

Requirements include 8+ years of analyst experience, strong SQL, and expertise in creating detailed requirements, user stories, and test cases. Collaboration across product, business, technology, QA, and vendors is essential for success.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 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 requirements, functional specifications, user stories, acceptance criteria, and test cases.
• Experience creating process flows and workflow diagrams with Visio or similar tools.
• Experience testing including test case development, defect management, and supporting SIT, UAT, and end-to-end testing.
• Ability to analyze application behavior, system logic, and data relationships without requiring software development skills.
• Experience working within Agile delivery environments and collaborating across teams.
• Excellent communication skills to articulate complex requirements to technical and non-technical stakeholders.
• Familiarity with Jira, Apptio TargetProcess, or comparable Agile/product management tools.
• Knowledge of multifamily loan servicing, mortgage servicing, or financial services operations is preferred.
• Understanding of AWS-based application environments and cloud systems is beneficial.
• Comfortable using generative AI tools such as Microsoft Copilot or ChatGPT for analysis and documentation support.

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 for data analysis

Business/process analysis

Agile delivery

Cross-functional collaboration

Documentation and requirements

Test case development

Visio workflow diagrams

Communication skills

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Jira

Apptio TargetProcess

AWS

Job description

System One is seeking a Senior Product Analyst/System Analyst for Plano, TX (and listed locations). You will analyze complex business processes, translate requirements, and support testing in a financial services context.

Requirements include 8+ years of analyst experience, strong SQL, and expertise in creating detailed requirements, user stories, and test cases. Collaboration across product, business, technology, QA, and vendors is essential for success.