Financial Data Analyst
Treasury, Departmental Offices - Department of the Treasury
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.
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.