Business System Analyst
ABOUT THE ROLE:
The Business System Analyst serves as the critical bridge between business stakeholders and technical teams, translating high-level business requirements into detailed functional specifications. This role combines deep analytical and technical expertise with strong communication skills, enabling the analyst to engage confidently with both customers and technology teams. The BSA serves as a subject matter expert on data source architecture — understanding how data flows across systems, maintaining the data source inventory, and ensuring accurate mapping as the product portfolio evolves.
This is a remote position that is based in Pittsburgh, PA. This role may require occasional in-person attendance at work-related events at the discretion of management.
JOB RESPONSIBILITIES:
To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily, with or without reasonable accommodation:
Partner with business stakeholders to gather, analyze, and document comprehensive requirements
Research existing system functionality, database structures, and data flows to inform technical solutions and business decisions
Serve as the primary owner and maintainer of the data source inventory — mapping products to their underlying data sources, tracking changes, and ensuring accuracy as the product portfolio grows
Lead solution design and analysis by translating complex business requests into actionable technical requirements
Create detailed, system-specific functional requirements and technical documentation
Lead requirement walkthrough sessions with IT teams to ensure clear understanding and alignment
Serve as connection between sales, customers, business stakeholders, and technical teams throughout the development process — translating in both directions
Write and run SQL queries across multiple databases to investigate data behavior, validate requirements, and support QA efforts
Proactively identify potential issues and recommend solutions to prevent project delays
Maintain critical project documentation and ensure accuracy throughout the SDLC
Other duties as assigned
WHAT YOU'LL NEED:
Bachelor’s degree required
3+ years of experience in Business Analyst or Business Systems Analyst role
Proven experience writing SQL queries across multiple databases (SQL Server, Oracle)
Strong analytical and problem-solving capabilities with keen attention to detail
Demonstrated ability to translate complex technical concepts for non-technical audiences — and business requirements for technical teams
Proficiency with JIRA and Confluence for project management and documentation
Experience working effectively in both Agile/Scrum and Waterfall methodologies
Excellent written and verbal communication skills — comfortable engaging directly with customers and sales teams
Adaptable and flexible approach to changing project requirements and priorities
Proactive mindset with ability to anticipate challenges and drive solutions
Familiarity with AI-powered tools and platforms for work optimization
WHAT SETS YOU APART:
Mortgage industry knowledge strongly preferred
Experience with ETL tools (Alteryx) or data visualization tools (Tableau)
Basic Python knowledge
Familiarity with data source mapping or system integration documentation