Senior Business Analyst

Systems Planning and Analysis, Inc.; Falls Church (VA); Hybrid; USD 163,000 - 187,000; Full time

Job summary

Intrepid, an SPA Company, is seeking a Senior Business Analyst to join the Defense Health Agency data orchestration initiative. You will gather requirements from mission experts, translate them into technical specifications, and help validate data products across enterprise data pipelines.

You will collaborate with engineers to implement data quality, governance, and catalog artifacts, while supporting agile ceremonies and stakeholder communications. A Secret clearance is required.

Qualifications

• Active Secret clearance required.
• Master’s degree in Health Informatics or related field.
• 10+ years of BA/data analysis experience in analytics or data integration.

Responsibilities

• Elicit and document data requirements from SME across clinical, operational, financial, and readiness domains.
• Translate business questions into technical data requirements, including mappings and rules.
• Profile source systems using SQL to evaluate data availability and quality.
• Define data quality rules and validation criteria with engineering; validate datasets.
• Build and maintain data dictionaries, glossaries, and metadata artifacts for catalogs.
• Perform hands-on data analysis and validation; write transformation queries; support light Databricks pipelines.
• Support user acceptance testing and confirm data products meet needs with mission users.
• Write user stories, manage requirements backlog, and participate in agile ceremonies.
• Serve as the bridge between Government owners, data stewards, and delivery team.
• Escalate data gaps and governance questions with recommended paths.

Skills

SQL expertise

Translate business requirements

Data profiling

Requirements documentation

Agile ceremonies

Education

Master’s degree in Health Informatics

Tools

Databricks

Power BI

Python

Tableau

Jira/Confluence

Job description

Overview

Intrepid, an SPA Company, brings more than 20 years of experience supporting the Department of Defense and U.S. Government, consistently setting the standard for excellence in the federal marketplace. Committed to advancing the mission of the U.S. Warfighter, Intrepid leverages technological superiority to deliver innovative solutions across air, space, land, and sea domains. We are proud to foster a collaborative, dynamic work environment, offering competitive compensation and an industry-leading 401k contribution. Our team is built through merit and achievement, and we’re always looking for the best and brightest to join us in our growth. We treat our people like family, we are mission-focused, and we give back!

Our Financial Management & Business Analysis Portfolio supports the U.S. Army Space and Missile Defense Command (USASMDC); the Office of the Assistant Secretary of the Army (ASA) Financial Management and Comptroller (FM&C); the U.S. Army Financial Management Command (USAFMCOM); the Defense Health Agency (DHA); and many other DoD customers. We ensure the Army FM systems and processes are modernized and integrated to provide a complete range of financial and cost information needed for the Army to conduct business transactions, provide accountability to the public, and to support performance reporting and decision making. We provide effective functional systems support, user technical support, training support, and governance support of the Army's modernized and deployed FM domain ERP systems (GFEBS / GFEBS-SA / GCSS-A (Finance)), ensuring technological capabilities maturation and evolution aligns with Army and FM domain goals and objectives.

We are looking for a Senior Business Analyst to join our team to support the Defense Health Agency Chief Data and Analytics Office in building an enterprise data orchestration layer for the Military Health System. The team will be bringing together information from diverse defense and federal systems to build scalable data pipelines, APIs, and data products that improve how critical health data is integrated, accessed, and used. You will be expected to work with functional subject matter experts to elicit, clarify, translate, and document business requirements into technical requirements for engineers as well as helping to validate business requirements during development.

Responsibilities

• Elicit and document data requirements from functional subject matter experts across clinical, operational, financial, and readiness domains.
• Translate business questions into technical data requirements, including source-to-target mappings, business rules, transformation logic, and acceptance criteria.
• Profile source systems directly using SQL to assess data availability, completeness, and fitness for the intended use before requirements are finalized.
• Define data quality rules and validation criteria with the engineering team, and test delivered silver and gold datasets against them.
• Build and maintain data dictionaries, business glossaries, data product documentation, and the metadata artifacts required for enterprise catalog registration.
• Perform hands-on data analysis and technical validation, including writing transformation queries, building validation notebooks, and supporting light pipeline development in Databricks.
• Support user acceptance testing and work directly with mission users to confirm data products meet their needs before release.
• Write and refine user stories, maintain the requirements backlog, and participate in agile ceremonies with the pipeline and product teams.
• Serve as the day-to-day bridge between Government functional owners, data stewards, and the technical delivery team.
• Escalate data gaps, source system issues, and governance questions early, with a recommended path forward.

Qualifications

Required Qualifications

• Possess an active Secret clearance
• Master’s degree in Health Informatics, Information Systems, Business Analytics, Public Health, or a related field
• 10+ years of business analysis, data analysis, or data product experience supporting analytics, reporting, or data integration work
• Strong hands-on SQL skills. You must be able to independently write, debug, and optimize complex queries, including multi-table joins, aggregations, window functions, subqueries, and common table expressions.
• Demonstrated experience translating business or mission requirements into technical data requirements, including source-to-target mappings and documented business rules
• Experience profiling and validating data, identifying quality issues, and defining data quality and acceptance criteria
• Working familiarity with modern data platforms such as Databricks, and with how ETL and ELT pipelines are built and operated, sufficient to hold a credible conversation with engineers and to do independent analysis
• Experience producing clear written artifacts such as requirements documents, data dictionaries, mapping specifications, and process documentation
• Experience working in an agile delivery environment, including writing user stories and managing a requirements backlog
• Strong communication skills, with the ability to elicit requirements from non-technical mission experts, translate them for technical teams, and reconcile differences between business intent and technical implementation.
• Ability to manage multiple concurrent workstreams, navigate ambiguity, and drive assigned work to resolution without close supervision
• Working knowledge of relational and dimensional data modeling concepts, including keys, relationships, grain, normalization, and fact and dimension structures.

Desired Qualifications

• Experience with Python (Pandas or PySpark preferred) for data profiling, validation, or light transformation work
• Experience supporting DHA, the Military Health System, Defense Health Program, VA, or other federal healthcare data environments
• Familiarity with health data standards and domains such as HL7 or FHIR, ICD-10, CPT, or claims and encounter data
• Experience with Advana , the War Data Platform, Palantir Foundry, or similar DoW data environments
• Experience with data governance artifacts and roles such as data stewardship, authoritative data sources, data cards, or metadata catalogs
• Experience building or validating dashboards and reports in Power BI, Tableau, Qlik, or similar tools
• Familiarity with Jira, Confluence, GitLab, or comparable delivery and documentation tooling
• Experience handling PHI and PII under HIPAA in a regulated environment

Pay Range Information

At SPA, we strive to deliver a robust total compensation package that will attract and retain top talent. Elements of the compensation package include competitive base pay and variable compensation opportunities. SPA provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health insurance, flexible spending accounts, health savings accounts, retirement savings plans, life and disability insurance programs, and a number of programs that provide for both paid and unpaid time away from work. The specific programs and options available to any given employee may vary depending on eligibility factors such as geographic location, date of hire, etc. Please note that the salary information shown below is a general guideline only. Salaries are commensurate with experience and qualifications, as well as market and business considerations. Pay Transparency Salary range: USD $163,000.00/Yr. - USD $187,000.00/Yr.