Business Analyst/Scrum Master

Halvik • Vienna, VA

3d

About The Position

Halvik is seeking a dynamic BA/Scrum Master to support agile delivery of the system that enhances how the Office of Airline Information (OAI) manages and delivers aviation data across the Bureau of Transportation Statistics (BTS). It focuses on modernizing data collection, validation, and access to consistent, accurate, and timely information. The initiative aims to create a centralized, reliable data platform that supports critical decision-making for the U.S. DOT and other stakeholders.

Requirements

• Bachelor's degree required.
• Minimum 5 years of Business Analyst and/or Scrum Master experience.
• Working knowledge of SQL for data analysis, validation, and troubleshooting
• Ability to produce detailed, comprehensive, testable, and traceable process and requirements documentation.
• Experience with Agile methodologies and tools such as Jira.
• Experience using visualization tools like Tableau or Power BI.

Nice To Haves

• Scrum Master certification preferred.
• Strong written and verbal communication skills with the ability to translate business needs into clear functional and technical requirements.
• Strong analytical and problem-solving capabilities.

Responsibilities

• Facilitate Agile ceremonies including daily standups, sprint planning, sprint reviews, retrospectives, backlog grooming, and iteration planning sessions.
• Act as Scrum Master and administrator for Agile delivery tools such as Jira, ensuring sprint boards, user stories, tasks, and workflows are current and accurately maintained.
• Guide teams in managing sprint commitments, preventing scope creep, supporting estimation activities, and breaking down work into manageable subtasks.
• Remove external blockers and address internal process or workflow challenges to improve team productivity and delivery effectiveness.
• Lead requirements gathering sessions with business and functional stakeholders to identify, analyze, prioritize, and document business and system requirements.
• Validate existing business processes and recommend process improvements to enhance operational efficiency and solution effectiveness.
• Create and maintain detailed, comprehensive, testable, and traceable requirements documentation understandable to both technical and business audiences.
• Monitor and manage incoming data submissions and resubmissions through dashboards, reports, and system notifications.
• Review, analyze, and validate complex datasets using Tableau reports and cross-reference multiple data sources to identify discrepancies, reporting issues, and data quality concerns.
• Analyze and verify operational and market data, including routes, passenger counts, carrier relationships, codeshare/interline relationships, and related reference datasets.
• Investigate underreporting and overreporting trends by comparing submitted data against supporting operational and market datasets.
• Reference and validate raw source data to support troubleshooting, issue resolution, and data quality initiatives.
• Maintain and update operational support tables and reference datasets, including carriers, routes, airports, and associated relationships.
• Reprocess data submissions and coordinate corrective actions, issue resolution, and resubmission activities with stakeholders and external partners.
• Write and execute beginner to intermediate SQL queries for data validation, analysis, troubleshooting, and reporting support.
• Collaborate with business users, external stakeholders, and carriers to resolve submission issues, communicate data corrections, and support ongoing operational processes.
• Release validated data products to internal teams, external stakeholders, buyers, and public-facing users in accordance with established processes and timelines.
• Support backlog prioritization and collaborate with cross-functional teams to align deliverables with business objectives and data quality goals.
• Assist in preparing and presenting routine and ad hoc project status reports, metrics, dashboards, and stakeholder updates.
• Coordinate project documentation activities, including maintaining templates, meeting agendas, meeting minutes, action items, and centralized document repositories.
• Ensure all project guidance, deliverables, work products, and supporting documentation are current, organized, and accessible within shared collaboration platforms.
• Support business analysis and data quality initiatives involving complex, highly dynamic datasets with continuously changing schedules, sampling methodologies, and carrier agreements.

Benefits

• Company-supported medical, dental, vision, life, STD, and LTD insurance
• 11 federal holidays and PTO
• Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
• 401(k) with company matching
• Flexible Spending Accounts for commuter, medical, and dependent care expenses
• Tuition Assistance
• Charitable Contribution matching

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level