Financial Data Analyst

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. Responsibilities 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