Data Products Business Analyst, Senior Consultant

Job Description

Job Description

This is Us:JS Perkins Consulting (JSPC) delivers value added management and technology consulting services. JSPC is committed to creating trusted partnerships to provide sustainable solutions to meet our client needs. We thrive on respect for the individual and host an open idea meritocracy.Here is the Role: J.S. Perkins Consulting is seeking a Business Analyst to sit between the mission and the pipeline on a major Defense Health Agency data modernization effort.J.S. Perkins Consulting (JSPC) is supporting the Defense Health Agency Chief Data and Analytics Office in building an enterprise data orchestration layer for the Military Health System. The work connects DHA clinical and operational source systems to the War Data Platform, then curates that raw data into governed, well-documented silver and gold data products that mission users can trust and reuse. The model is federated: data stays with its authoritative owners, and the orchestration layer makes it discoverable, interoperable, and consumable through catalogs, APIs, and a data product marketplace.This role owns the translation problem. You will work with functional subject matter experts to understand what a clinical, operational, or readiness question actually requires, turn that into precise source-to-target mappings and business rules the engineering team can build against, and then validate that the delivered data product answers the original question. This is not a pure requirements-gathering job. You will be in the data yourself, writing SQL to profile sources, test rules, and prove out results before and after the engineers build.What do we offer:  Medical/Dental/Vision 401K (up to 5% match)11 Paid Holidays4-5 weeks PTO (depending on level)Bonus IncentivesProfessional DevelopmentTeleworkContinuing Education CreditYour Responsibilities:  Elicit and document data requirements from functional subject matter experts across clinical, operational, financial, and readiness domainsTranslate business questions into technical data requirements, including source-to-target mappings, business rules, transformation logic, and acceptance criteriaProfile source systems directly using SQL to assess data availability, completeness, and fitness for the intended use before requirements are finalizedDefine data quality rules and validation criteria with the engineering team, and test delivered silver and gold datasets against themBuild and maintain data dictionaries, business glossaries, data product documentation, and the metadata artifacts required for enterprise catalog registrationPerform 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 releaseWrite and refine user stories, maintain the requirements backlog, and participate in agile ceremonies with the pipeline and product teamsServe as the day-to-day bridge between Government functional owners, data stewards, and the technical delivery teamEscalate data gaps, source system issues, and governance questions early, with a recommended path forwardWhat you bring:  3 or more years of business analysis, data analysis, or data product experience supporting analytics, reporting, or data integration work, with 5 or more years preferredStrong 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 rulesExperience profiling and validating data, identifying quality issues, and defining data quality and acceptance criteriaWorking 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 analysisExperience producing clear written artifacts such as requirements documents, data dictionaries, mapping specifications, and process documentationExperience working in an agile delivery environment, including writing user stories and managing a requirements backlogStrong 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 supervisionWorking knowledge of relational and dimensional data modeling concepts, including keys, relationships, grain, normalization, and fact and dimension structures.Bachelor 's degree in Health Informatics, Information Systems, Business, Analytics, Public Health, or a related fieldU.S. citizenship, and the ability to obtain and maintain a DoW Secret clearanceTravel Requirements:  Must be willing to travel for client business as needed.  Physical Requirements:  Work is performed in hybrid/remote office environment and requires operating standard office equipment and keyboards.  Must be able to lift small packages or other items up to 20 lbs and travel short or long distances in a car, airplane, or other vehicle of transportation to client destinations nationally and internationally if needed. Preferred Experience:Active DoW Secret clearance or higher at time of applicationExperience with Python (Pandas or PySpark preferred) for data profiling, validation, or light transformation workExperience supporting DHA, the Military Health System, Defense Health Program, VA, or other federal healthcare data environmentsFamiliarity with health data standards and domains such as HL7 or FHIR, ICD-10, CPT, or claims and encounter dataExperience with Advana, the War Data Platform, Palantir Foundry, or similar DoW data environmentsExperience with data governance artifacts and roles such as data stewardship, authoritative data sources, data cards, or metadata catalogsExperience building or validating dashboards and reports in Power BI, Tableau, Qlik, or similar toolsFamiliarity with Jira, Confluence, GitLab, or comparable delivery and documentation toolingExperience handling PHI and PII under HIPAA in a regulated environmentCulture Statement:At JS Perkins Consulting, we believe our people are the foundation of our success.  Because of this, we value talent and drive, celebrate individuality, embrace diversity, and inspire authenticity. We have a culture of mutual trust and respect and believe everyone has a voice. JSPC goes above and beyond for the client and each other.EEO Statement:JSPC is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization. JS Perkins Consulting makes hiring decisions based solely on qualifications, merit, and business needs at the time.