Financial Data Analyst Job in Washington, DC

Vacancy No. 25-DO-86 Department Treasury, Departmental Offices
Salary $68,405.00 to $153,354.00 Grade 9 to 13
Perm/Temp Permanent FT/PT Full-time
Open Date 11/12/2024 Close Date 11/19/2024
Job Link Apply Online Who may apply Public
Locations:
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.

This job is open to

Clarification from the agency

All candidates who are: 1. Current or former federal employees qualifying as Status Candidates, Federal employees currently serving on a VRA, VEOA eligibles, CTAP/ICTAP eligibles, eligible for special hiring authorities (e.g., the Schedule A appointment for persons with disabilities, or covered by an Interchange Agreement), or VRA eligibles (GS-11 and below only) OR 2. Land Management employees eligible under Public Law 114-47.

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 any US citizen to apply under Announcement 25-DO-58-P. 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 Declaration for Federal Employment 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 Selective Service System or are exempt from having to do so.
  • Go through a Personal Identity Verification (PIV) process that requires two forms of identification from the Form I-9. 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 within 30 days of 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 the GS-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 volunteer service. 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é.

TIME-IN-GRADE: In addition to the above requirements, you must meet the following time-in-grade requirement, if applicable:

  • For the GS-13, you must have been at the GS-12 level for 52 weeks.
  • For the GS-12, you must have been at the GS-11 level for 52 weeks.
  • For the GS-11, you must have been at the GS-9 level for 52 weeks.
  • For the GS-9, you must have been at the GS-7 level for 52 weeks.


TIME AFTER COMPETITIVE APPOINTMENT: Candidates who are current Federal employees serving on a non-temporary competitive appointment must have served at least three months in that appointment.

Education

The education generally must be from an accredited (or pre-accredited) college or university recognized by the U.S. Department of Education. 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 OPM instructions.

Additional information

During the application process you will have an option to opt-in to make your resume available to hiring managers in the agency who have similar positions. Opting in does not impact on your application for this announcement, nor does it guarantee further consideration for additional positions. This job opportunity announcement may be used to fill additional vacancies.

OTHER INFORMATION:

  • We may select from this announcement or any other source to fill one or more vacancies.
  • This is a bargaining unit position.
  • Relocation expenses will not be paid.
  • We offer opportunities for telework.
  • We offer opportunities for flexible work schedules.
  • This position requires that the successful candidate undergo personnel vetting, which includes a background investigation and enrollment upon onboarding into "Continuous Vetting." Enrollment in Continuous Vetting will result in automated record checks being conducted throughout one's employment with Treasury. The successful candidate will also be enrolled into FBI's Rap Back service, which will allow Treasury to receive notification from the FBI of criminal matters (e.g., arrests, charges, convictions) involving enrolled individuals in near real-time. For more information about individual rights, Noncriminal Justice Applicant's Privacy Rights - FBI, FD-258 Privacy Act Statement - FBI, and SEAD-3-Reporting-U.pdf (dni.gov).
REASONABLE ACCOMMODATION REQUESTS: If you believe you have a disability (i.e., physical or mental), covered by the Rehabilitation Act of 1973 as amended and Americans with Disabilities Act 1990 as amended, that would interfere with completing the USA Hire Competency Based Assessments, you will be granted the opportunity to request a reasonable accommodation in your online application. Requests for Reasonable Accommodations for the USA Hire Competency Based Assessments and appropriate supporting documentation for Reasonable Accommodation must be received prior to starting the USA Hire Competency Based Assessments. Decisions on requests for Reasonable Accommodations are made on a case-by-case basis. If you meet the minimum qualifications of the position, after notification of the adjudication of your request, you will receive an email invitation to complete the USA Hire Competency Based Assessments. You must complete all assessments within 48 hours of receiving the URL to access the USA Hire Competency Based Assessments, if you received the link after the close of the announcement. To determine if you need a Reasonable Accommodation, please review the Procedures for Requesting a Reasonable Accommodation for Online Assessments here: https://help.usastaffing.gov/Apply/index.php?title=Reasonable_Accommodations_for_USA_Hire

Our comprehensive benefits are very generous. Our benefits package includes:

  • Challenging work, opportunities for advancement, competitive salaries, bonuses and incentive awards.
  • Eleven paid holidays, 13 days of sick leave, and 13 to 26 days of vacation time each year.
  • Access to insurance programs that may be continued after you retire.
  • A wide choice of health insurance plans, coverage for pre-existing conditions, and no waiting periods. We pay a substantial amount (up to 75%) of the health insurance premiums.
  • A retirement program which includes employer-matching contributions.
  • Learn more about Federal benefits programs at: https://help.usajobs.gov/index.php/Pay_and_Benefits

Benefits

A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.

Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

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


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 Career Transition Assistance Plan (CTAP)/Interagency Career Transition Assistance Plan (ICTAP)) 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 USAJOBS Resources Center.
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)
  • CURRENT AND FORMER FEDERAL EMPLOYEES: Documentation Relating to Your Federal Employment:
    • You must submit a copy of your SF-50 (Notification of Personnel Action) which shows your current (or most recent) grade and competitive service status. (The "position occupied" block on the SF-50 should show a "1" and your "tenure" block should show a "1" or "2".) Typically Award SF-50s do not provide the required documentation.
    • If you are currently on a Veterans Recruitment Appointment (VRA), you must submit a copy of an SF-50 showing that. Also, you must submit a copy of your DD214 or other documentation showing dates of service and type of discharge (Member 4) and any other applicable documents such as SF-15, VA letters, etc.
    • Indicate on your application the highest permanent grade you have held; if this grade is different from your current grade, you must submit a copy of an additional SF-50 showing this grade.
  • Land Management Eligibles must provide all required documentation to verify eligibility, prior performance, and qualifications for the target position. You can find information on the Land Management Workforce Flexibility Act and eligibility HERE. Land Management Eligibles must compete under competitive merit promotion procedures and meet all applicable requirements as such (time-in-grade restrictions do not apply).
  • CAREER TRANSITION ASSISTANCE PLAN (CTAP) OR INTERAGENCY CAREER TRANSITION ASSISTANCE PLAN (ICTAP) DOCUMENTATION: If you are a displaced or surplus Federal employee, click CTAP/ICTAP for eligibility and a detailed list of required documents you must submit in order to be eligible.
  • If you are applying under a special hiring authority (e.g. Military Spouses, Interchange Agreement, VEOA, VRA, Schedule A Disability, etc.), please see applicant guide for required documentation. In order to be eligible under one of these authorities, you must submit all required documentation as outlined in the applicant guide.
  • NON-COMPETITIVE REINSTATEMENT: If you are a former federal employee that has been separated for at least 1 year and wish to be non-competitively reinstated to a higher grade or full performance level than which you left federal employment, you MUST provide a copy of your separation SF50 (the "position occupied" block on the SF-50 should show a "1" and your "tenure" block should show a "1" or "2") AND you MUST submit a qualifying performance appraisal from your most recent career or career-conditional position of at least Fully Successful (or equivalent). You will NOT be given consideration for non-competitive reinstatement, under this option, if a performance appraisal document is not submitted.
  • 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 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 Department of Education Accreditation page. 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 OPM instructions.

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 schools accredited by accrediting institutions recognized by the U.S. Department of Education.

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.

How to Apply

DO has partnered with the Treasury's Bureau of the Fiscal Service to provide certain personnel services to its organization. Fiscal Service's responsibilities include advertising vacancies, accepting and handling applications, and extending job offers.

Please read the entire announcement and all the instructions before you begin an application.

To apply for this position, you must complete the initial online application, to include the initial online assessment and submission of the required documentation specified in the Required Documents section above. The complete application package must be submitted by 11:59 PM (ET) on the closing date of the announcement to receive consideration.

Are you unsure how to write your federal resume? We are here to help. The Treasury Recruitment Service regularly offers Writing Your Federal Resume training sessions, and other career-related information sessions, to assist you in your career search journey. To register for a session, click here to go to our Career Information Sessions webpage.

The application process is as follows:

  1. To begin the application process, click the Apply Online button.
  2. Answer the questions presented in the application and attach all necessary supporting documentation.
  3. Click the Submit Application button prior to 11:59 PM (ET) on the announcement closing date.
  4. After submitting an online application, you will be notified whether or not you are required to take additional online assessments through the USA Hire Competency Based Assessment system. This message will be delivered to you via email notification. The email may be routed to your "Spam" or "Junk" folder.
  5. If you are asked to take the USA Hire Competency Based Assessments, you will be presented with a unique URL to access the USA Hire system. Access to USA Hire is granted through your USAJOBS login credentials. Be sure to review all instructions prior to beginning your USA Hire Assessments. Click here for Computer System Requirements: (https://help.usastaffing.gov/Apply/index.php?title=USA_Hire_System_Requirements)
  6. Note, set aside at least 3 hours to take these assessments; however, most applicants complete the assessments in less time. If you need to stop the assessments and continue at a later time, you can reuse the URL sent to you via email and also found in your USAJOBS account under the "Track my application" link for the corresponding application.
To update your application, including supporting documentation, at any time during the announcement open period, return to your USAJOBS account (https://usajobs.gov). There you will find a record of your application, the application status, and an option to Edit my application. This option will no longer be available once the announcement has closed.

To verify the status of your application both during and after the announcement open period, log into your USAJOBS account at https://www.usajobs.gov. On the Home page, scroll down and locate your job application. Once the job has been located, click the "Track this application" link on the right under the application date. The page will refresh to display the Agency's Application Information page where you can scroll down and review any notifications the agency has sent you. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.

Please notify us if your contact information changes after the closing date of the announcement. Also, note that if you provide an email address that is inaccurate or if your mailbox is full or blocked (e.g., spam-blocker), you may not receive important communication that could affect your consideration for this position.

For additional information on how to apply, please visit the Partnership for Public Service's Go Government website.

The Fair Chance to Compete for Jobs Act prohibits the Department of Treasury and its bureaus from requesting an applicant's criminal history record before that individual receives a conditional offer of employment. In accordance with 5 U.S. Code § 9202(c) and 5 C.F.R § 920.201 certain positions are exempt from the provisions of the Fair Chance to Compete Act. Applicants who believe they have been subjected to a violation of the Fair Chance to Compete for Jobs Act, may submit a written complaint to the Department of Treasury by email at, FairChanceAct@treasury.gov.

To learn more, please visit our page at: Treasury.gov/fairchanceact.

To preview the assessment questionnaire: https://apply.usastaffing.gov/ViewQuestionnaire/12604903

Agency contact information

Applicant Call Center
Address
Management Chief Financial Officer
Administrative Resource Center
Parkersburg, WV 26101
US
Learn more about this agency

Next steps

Based on your application and your responses to the application questionnaire, you may be presented with instructions on how to access the USA Hire system to complete the online assessments. The online assessments must be completed within 48 hours following the close of this announcement. You will have the opportunity to request a testing accommodation for the assessment should you have a disability covered under the Rehabilitation Act of 1973 as amended.

Your assessment results will be kept on record for one year and used toward future positions for which you might apply that require the same assessments.

To be considered for the position, you must meet all qualifications, including meeting or exceeding the cut score on the required assessments.

We will review your resumé and transcript(s) (if appropriate) to ensure you meet the basic qualification requirements. We will evaluate each applicant who meets the basic qualifications on the information provided and may interview the best-qualified applicants. After making a tentative job offer, we will conduct any required suitability and/or security background investigation.


Note: We cannot accept applications on behalf of Federal Agencies. Application instructions are listed within the Job Description.