Financial Data Analyst at U.S. Department of the Treasury in Washington, DC

Summary

This position is located at Departmental Offices,Office of Financial Management. As a Financial Data Analyst, you will be responsible for providing expert technical support in the Financial Systems line of business that provides customer support, analysis, and training services for a variety of financial systems (including feeder systems), programs and functions.

Duties

The following are the duties of this position at the GS-13. If you are selected at a lower grade level, you will have the opportunity to learn to perform all these duties and will receive training to help you grow in this position.

Conduct studies and manage special projects relating to OFM program operations and Financial Systems including systems that impact financial operations such as HR, Contracting, and InterAgency Agreement Systems.
Participate in the management, maintenance, and customer support of financial processes and data from a variety of Financial systems and Feeder Systems (e.g. the HR Connect suite of systems, webTA, OMB Max, Prism, Oracle suite of systems and G-Invoicing).
Lead and perform customer acceptance testing on behalf of all OFM customers. Coordinate assignment of testers, communicate with testers and the system owner, report of defects, and validation of defect fixes.
Develop and organize course content, job aids, and handouts for newly developed reports as well as new or existing system functionality.
Communicate with various levels of personnel throughout the bureau, department, other Federal agencies, and in the private sector on job-related matters, both orally and in writing.

Requirements

Conditions of Employment

This opportunity is also open to under Announcement 25-DO-86. Please refer to that announcement for details on open period, eligibility, and how to apply.

Key Requirements:

Must be U.S. Citizen or U.S. National.
A one-year probationary period may be required.
Must successfully complete a background investigation.
Public Trust - Background Investigation will be required.
All new hires will be required to comply with federal ethics laws. A review of financial or other interests may be conducted to determine if they create any real or apparent conflict of interests with official Treasury duties.
Complete a to determine your suitability for Federal employment, at the time requested by the agency.
Have your salary sent to a financial institution of your choice by Direct Deposit/Electronic Funds Transfer.
If you are a male applicant born after December 31, 1959, certify that you have registered with the or are exempt from having to do so.
Go through a Personal Identity Verification (PIV) process that requires two forms of identification from the . Federal law requires verification of the identity and employment eligibility of all new hires in the U.S.
Please refer to the "Additional Information" section for additional Conditions of Employment.

Qualifications

You must meet the following requirements by the closing date of this announcement.

SPECIALIZED EXPERIENCE:For the GS-13 grade level, you must have one year (52 full weeks) of specialized experience at a level of difficulty and responsibility equivalent to the GS-12 grade level in the Federal service. Specialized Experience for this position includes:

Using data science techniques on programmatic, accounting, financial, and/or administrative data to identify patterns and relationships in large data sets from multiple data sources for financial operations; AND
Creating or developing dashboards using data analytics software (e.g., PowerBI or Tableau) with automated validations to ensure accuracy for financial reporting purposes; AND
Independently performing financial data analysis, financial reconciliations, and financial reporting (e.g., budgetary reporting); AND
Gathering requirements to develop automated reports and dashboards from users.

SPECIALIZED EXPERIENCE:For the GS-12 grade level, you must have one year (52 full weeks) of specialized experience at a level of difficulty and responsibility equivalent to theGS-11 grade level in the Federal service. Specialized Experience for this position includes:

Using data science techniques on programmatic, accounting, financial, and/or administrative data to identify patterns and relationships in large data sets from multiple data sources for financial operations; AND
Creating or developing dashboards using data analytics software (e.g., PowerBI or Tableau) for financial reporting purposes; AND
Performing and/or assisting with financial data analysis, financial reconciliations, and financial reporting (e.g., budgetary reporting).

SPECIALIZED EXPERIENCE:For the GS-11 grade level, you must have one year (52 full weeks) of specialized experience at a level of difficulty and responsibility equivalent to the GS-9 grade level in the Federal service. Specialized Experience for this position includes:

Experience conducting financial data analysis in Microsoft Excel using pivot tables, charts, VLookups/Index match, or other advanced Microsoft Excel features; AND
Experience developing custom data visualizations for financial information using Excel or other data analytics software; AND
Experience developing presentations of financial information and analysis for leadership to make decisions.

OR EDUCATION: You may substitute education for specialized experience as follows:

a Ph.D. or equivalent doctoral degree; OR
3 full years of progressively higher-level graduate education leading to such a degree; OR
a LL.M., if related;

OR COMBINATION OF EXPERIENCE AND EDUCATION: You may qualify on a combination of education and experience. To combine education and experience, the total percentage of experience at the required grade level compared to the requirement, as well as the percentage of completed education compared to the requirement must equal at least 100 percent. Only graduate level education in excess of the first 36 semester hours (54 quarter hours) may be combined to be considered for qualifying education.

SPECIALIZED EXPERIENCE:For the GS-9 grade level, you must have one year (52 full weeks) of specialized experience at a level of difficulty and responsibility equivalent to the GS-7 grade level in the Federal service. Specialized Experience for this position includes:

Experience or training in conducting financial data analysis in Microsoft Excel using pivot tables, charts, VLookups/Index match, or other advanced Microsoft Excel features; AND
Experience or training in business analytics or accounting.

OR EDUCATION: You may substitute education for specialized experience as follows:

a master's or equivalent graduate degree; OR
2 full years of progressively higher-level graduate education leading to such a degree or LL.B. or J.D., if related;

OR COMBINATION OF EXPERIENCE AND EDUCATION: You may qualify on a combination of education and experience. To combine education and experience, the total percentage of experience at the required grade level compared to the requirement, as well as the percentage of completed education compared to the requirement must equal at least 100 percent. Only graduate level education in excess of the first 18 semester hours (27 quarter hours) may be combined to be considered for qualifying education.

The experience may have been gained in either the public, private sector or . One year of experience refers to full-time work; part-time work is considered on a prorated basis. To ensure full credit for your work experience, please indicate dates of employment by month/day/year, and indicate number of hours worked per week on your resumé.

How You Will Be Evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

You will be evaluated based on how well you meet the qualifications listed in this vacancy announcement. Your qualifications will be evaluated based on your application materials (e.g., resumé, supporting documents), the responses you provide on the application questionnaire, and the result of the online assessments required for this position. Please be sure that your resumé includes detailed information to support your qualifications for this position; failure to provide sufficient evidence in your resumé may result in a "not qualified" determination.

In order to be considered for this position, you must complete all required steps in the process. In addition to the application and application questionnaire, this position requires an online assessment. The online assessment measures critical general competencies required to perform the job.

The assessment includes a cut score based on the minimum level of required proficiency in these critical general competencies. You must meet or exceed the cut score to be considered. You will not be considered for the position if you score below the cut score or fail to complete the assessment.

Overstating your qualifications and/or experience in your application materials or application questionnaire may result in your removal from consideration. Cheating on the online assessment may also result in your removal from consideration.

Rating: You will be assessed on the following competencies (knowledge, skills, abilities, and other characteristics):

Accountability
Analytical
Arithmetic/Mathematical Reasoning
Attention to Detail
Communication
Customer Service
Decision Making
Flexibility
Integrity/Honesty
Interpersonal Skills
Learning
Reasoning
Self-Management
Stress Tolerance
Teamwork
Technical

Category rating will be used to rank and select eligible candidates. If qualified, you will be assigned to one of three quality level categories: Category A (highest quality category), Category B (middle quality category), or Category C (minimally qualified category), depending on your responses to the online questions, regarding your experience, education, and training related to this position. Your rating may be lowered if your responses to the online questions are not supported by the education and/or experience described in your application. Your application may be reviewed by a Subject Matter Expert.

Veterans' preference is applied after applicants are assessed. Preference-eligibles will be listed at the top of their assigned category and considered before non-preference-eligibles in that category.

Referral: If you are among the top qualified candidates, your application may be referred to a selecting official for consideration. You may be required to participate in a selection interview.

If you are a displaced or surplus Federal employee (eligible for the ) you must be assigned the middle category or better to be rated as "well qualified" to receive special selection priority.

Required Documents

A complete application includes:

1. All applicants are required to submit a resumé, either by creating one in USAJOBS, or uploading one of their own choosing. (Cover letters are optional.)

Please limit your resume to 5 pages. If more than 5 pages are submitted, your resume will still be accepted, however only the first 5 pages will be reviewed and considered for qualifications and eligibility determination in whether or not the minimum qualifications for the position have been met.
To receive full credit for relevant experience, please list the month/date/year and number of hours worked for experience listed on your resumé.
It is suggested that you preview the entire announcement and online assessment questionnaire, to ensure that your resumé thoroughly describes how your skills and experience align to the criteria defined in the "Qualifications" section of this announcement and support your responses to the online assessment questionnaire.
For resumé writing guidance, please visit .

2. Vacancy assessment question responses: All applicants are required to complete vacancy question responses by clicking the apply online button of this vacancy announcement.

3. Submission of any required documents identified below, if applicable: Please note that if you do not provide all required information, as specified in this announcement, you may not be considered for this position (or may not receive the special consideration for which you may be eligible).

VETERANS' PREFERENCE DOCUMENTATION: If you are claiming veterans preference, please see . In order to be considered for veterans preference, you must submit all required documentation as outlined in the applicant guide.
CAREER TRANSITION ASSISTANCE PLAN (CTAP) OR INTERAGENCY CAREER TRANSITION ASSISTANCE PLAN (ICTAP) DOCUMENTATION: If you are a displaced or surplus Federal employee, click for eligibility and a detailed list of required documents you must submit in order to be eligible.
EDUCATION DOCUMENTATION:
- You are not required to submit transcripts for this initial phase of the application process. Candidates will be referred for consideration based on their self-certification. If you are selected for a position which has a positive education requirement (as described in the vacancy announcement) and/or you are qualifying solely on your education, you will be required to submit official transcripts verifying your qualifications prior to a job offer being issued.
- A college or university degree generally must be from an accredited (or pre-accredited) college or university recognized by the U.S. Department of Education. For a list of schools which meet these criteria, please refer to . If you are qualifying based on foreign education, you must submit proof of creditability of education as evaluated by a credentialing agency. Refer to the .

If you are relying on your education to meet qualification requirements:

Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from .

Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.