Management Analyst

Immediate Office of the Assistant Secretary for Management; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

Office of Finance (OF), Revenue Operations (RO) is seeking a Business Analyst to support data governance and analytical reporting for the National Consolidated Patient Account Center (CPAC). The role requires coordinating with field and program offices to deliver BI solutions using Microsoft BI tools.

Candidates should demonstrate expertise in SQL Server, SSMS, SSIS, SSRS, and Power BI, as well as experience with data retrieval and information systems.

Qualifications

• Specialized experience equivalent to GS-12 in the Federal system.
• Experience implementing and governing data in revenue/financial operations.

Responsibilities

• Manage data governance ensuring integrity and security of revenue operations.
• Provide data analysis, product development and reporting needs.
• Apply analytical methods to operational performance and financial management systems.
• Initiate and collaborate with field and program office stakeholders on BI products.
• Develop and maintain BI infrastructure using Microsoft BI stack (SSMS/SSIS/SSRS).
• Review processes, policies, and workflows to improve efficiency.
• Collaborate with field users to design and implement analytical tools.

Skills

Data governance

Data analysis

Analytical methods

Stakeholder collaboration

Problem solving

Tools

SQL Server

SSMS

SSIS

SSRS

Power BI

Summit Data Platform

Job description

This position is located in the Office of Finance (OF), Revenue Operations (RO), with the incumbent serving as a Business Analyst. RO is the oversight office for the National Consolidated Patient Account Center (CPAC), where there are 7 CPACs located regionally to consolidate business activities that enhance RO throughout the VHA network by standardization and consolidation of functions, and the integration of VHA and industry best practices.

To qualify for this position, applicants must meet all requirements by the closing date of this announcement, 11/16/2026. Selective Placement Factors (SPF). Selective placement factors are knowledge, skills, abilities, or special qualifications that are in addition to the minimum requirements in a qualification standard, but are determined to be essential to perform the duties and responsibilities of a particular position. Candidates must possess SPFs to be considered for this position.

The Selective Placement Factor (SPF) for this position is: Knowledge of both computer accounting and information retrieval systems is required. i.e., Microsoft SQL Server, Microsoft SQL Server Management Studio (SSMS), Microsoft SQL Server Integrations Services. Note: To be Highly Qualified, you will be required to provide documentation and live presentation of Structured Query Language (SQL) code from CDW personally written and implemented. Highly qualified will also include Summit Data Platform (SDP) and PowerBI development and implementation experience.

Time-In-Grade Requirement: Applicants who are current Federal employees and have held a GS grade any time in the past 52 weeks must also meet time-in-grade requirements by the closing date of this announcement. For a GS-13 position you must have served 52 weeks at the GS-12. The grade may have been in any occupation, but must have been held in the Federal service. An SF-50 that shows your time-in-grade eligibility must be submitted with your application materials. If the most recent SF-50 has an effective date within the past year, it may not clearly demonstrate you possess one-year time-in-grade, as required by the announcement. In this instance, you must provide an additional SF-50 that clearly demonstrates one-year time-in-grade. Note: Time-In-Grade requirements also apply to former Federal employees applying for reinstatement as well as current employees applying for Veterans Employment Opportunities Act of 1998 (VEOA) appointment.

You may qualify based on your experience as described below: Specialized Experience: You must have one year of specialized experience equivalent to at least the next lower grade GS-12 in the normal line of progression for the occupation in the organization. Examples of specialized experience would typically include, but are not limited to:

• 1) Managing data governance ensuring the integrity and security of revenue operations is consistent, based on internal data standards.
• 2) Provides data analysis, product development and reporting needs.
• 3) Provides analytical and evaluative methods with understanding of operational performance and complies with financial management systems, legislative and performance expectations.
• 4) Proactively and independently works to identify needs, coordinating and executing analytical reporting tools, analyzes data, and collaborates in design and development of tools.
• 5) Performs analysis, design, development, testing, and maintenance of products built using Microsoft Business Intelligence (BI) suite including Microsoft SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and/or other tools associated with the extract/transfer/load of data.
• 6) Conducting systematic and ad-hoc reviews of business processes, policies and procedures, workflow and workload.
• 7) Initiate and collaborate effectively with field and program office stakeholders as well as field users of products developed by the Revenue Operations.

For more information on these qualification standards, please visit the United States Office of Personnel Management's website at https://www.opm.gov/policy-data-oversight/classification-qualifications/general-schedule-qualification-standards/.