Business System Analyst

Jobtailor; Pittsburgh (Allegheny County); On-site; USD 85,000 - 120,000; Full time

Job summary

Jobtailor in Pittsburgh is seeking a skilled Business Analyst to translate complex business needs into actionable technical requirements and data solutions. You will map data sources, drive SQL analysis across databases, and document through JIRA and Confluence.

The role requires 3+ years of BA/BS Analyst experience, knowledge of ETL and Tableau, and comfort working in Agile/Scrum and Waterfall environments. Mortgage industry knowledge is a plus.

Qualifications

• Bachelor’s degree required.
• 3+ years in Business Analyst or Business Systems Analyst role.
• Experience writing SQL queries across SQL Server and Oracle.
• Able to translate business requirements into technical specs.
• Proficient with JIRA and Confluence for PM and docs.
• Experience in Agile/Scrum and Waterfall.
• Excellent written and verbal communication with customers and sales.
• Adaptable to changing priorities and proactive.
• Familiar with AI-powered tools for work optimization.
• Mortgage industry knowledge strongly preferred.
• Familiar with ETL tools (Alteryx) or Tableau.
• Basic Python knowledge.
• Familiarity with data source mapping or system integration docs.

Responsibilities

• Partner with stakeholders to gather, analyze, and document requirements.
• Research system functionality, DB structures, and data flows.
• Own and maintain the data source inventory and mapping.
• Lead solution design translating business requests to tech requirements.
• Create detailed, system-specific functional requirements and docs.
• Lead requirement walkthroughs with IT teams.
• Serve as liaison between sales, customers, and technical teams.
• Write and run SQL queries across multiple databases.
• Identify potential issues and suggest prevention actions.
• Maintain project documentation throughout the SDLC.
• Other duties as assigned.

Skills

SQL Query Writing

Business Analysis

Agile/Scrum Methodologies

Communication Skills

Problem-Solving

Adaptability

Mortgage Industry Knowledge

Cross-Functional Collaboration

Education

Bachelor’s degree

Tools

JIRA

Confluence

Alteryx

Tableau

Data Source Mapping

Basic Python

Job description

• 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

Requirements

• 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
• 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

Core Competencies

Demonstrates expertise in gathering and analyzing business requirements, translating complex concepts between technical and non‑technical stakeholders, and maintaining accurate project documentation throughout the SDLC. Proficient in SQL query writing and familiar with Agile/Scrum and Waterfall methodologies, with a strong focus on problem‑solving and adaptability.

Highest‑signal resume keywords

• SQL Query Writing
• Business Analysis
• Agile/Scrum Methodologies
• JIRA and Confluence Proficiency
• Mortgage Industry Knowledge

ATS Optimization Keywords

Hard Skills

• SQL Server
• Oracle
• Data Source Mapping
• ETL Tools
• Data Visualization Tools
• Basic Python Knowledge

Soft Skills

• Analytical Skills
• Problem‑Solving
• Communication Skills
• Adaptability
• Proactive Mindset

Industry Keywords

• Mortgage Industry
• SDLC
• System Integration Documentation
• AI‑Powered Tools

Tools & Technologies

• JIRA
• Confluence
• Alteryx
• Tableau