Financial Database Specialist
- Employer
- USAJobs
- Location
- Washington, D.C
- Posted
- Mar 30, 2023
- Closes
- Apr 06, 2023
- Function
- IT, Database Administrator
- Industry
- Government and Public Services, Federal
- Career Level
- Experienced (Non-Manager)
- Hours
- Full Time
Duties
The Office of Supervision Technology and Analytics (OSTA or Office) is responsible for the data, databases, analytics, and Information Technology (IT) used by DBR for its supervision processes. Its primary role is to provide reporting, analytics, data management, and data tool support to DBR with respect to economic, financial, mortgage, and FHLBank membership data and to act as a bridge between DBR business offices and FHFA IT staff. The Office is charged with driving innovation in the use of technology for the DBR business mission and assists other DBR business units with the specification and management of dashboards, reports and databases that capture and provide information needed to support DBR analyses and decisions.
In addition to providing analytics and data oversight expertise to DBR, OSTA also maintains the DBR regulatory reporting program under which FHLBank reporting requirements are identified and formalized and provides as-needed assistance to examiners during the course of FHLBank evaluations. Such assistance may include the preparation of ad-hoc analytics or reports or on-site visits to FHLBanks under examination.
Acts as a liaison between DBR and the Agency Office of Technology and Information Management, ensuring and coordinating the implementation of supervision IT solutions. The Financial Database Specialist will be required to obtain and demonstrate experience in IT and FHLBank supervision and, as needed, support examination and supervision processes by taking part in onsite or offsite examinations of FHLBank reporting and data processes.
As a Financial Database Specialist, the incumbent serves as a technical resource for DBR database, business intelligence and reporting projects. The incumbent will support data users by participating in requirements-gathering, database development and implementation, standardized and ad hoc report development, and the evaluation and use of data query, reporting and visualization tools and analytical applications.
The incumbent will develop and demonstrate experience in DBR's technology and information assets and FHLBank business lines and, occasionally, to support examination staff by taking part in onsite or offsite examinations of FHLBank reporting and data processes within their area of expertise.
The Financial Database Specialist will evaluate and/or assist in the adoption of innovative tools and methods to advance OSTA program areas and will have responsibilities supporting the implementation of certain data or data tools.
For less complex projects, the incumbent may be responsible for coordinating resources associated with IT efforts to develop, implement, document, and/or modify information systems and databases. The incumbent may evaluate the effectiveness of the Agency information architecture with respect to Division needs, including the appropriateness of data and applications, and participates in efforts to assure and maintain data quality, develop Division or Agency information and data policies, and develop documentation related to those duties.
The incumbent will be required to, in conjunction with Agency IT staff and/or other OSTA staff, analyze Division or office requirements to determine the type of information that will address business needs and provide advice and guidance on IT standards, strategies, policies, and processes and the alternative ways of meeting DBR's overall information technology requirements; maintain and apply knowledge in database technologies and business intelligence tools to resolve problems and evaluate new methods of enhancing existing system(s) to better meet reporting and analysis needs.
To accomplish this, the incumbent will have and maintain proficiency in basic programming, query languages and tools, reporting, analysis, and data validation/reconciliation, visualization, and administration tools to support recurring or ad hoc Division or Agency work. The incumbent must also possess knowledge of the FHFA business mission and processes.
On an as-needed basis, the incumbent will also assist the examination function with the review of FHLBank regulatory reporting and data management processes before, during or between examinations. The incumbent will also perform other duties as assigned, some of which may require travel.
Requirements
Conditions of Employment
Qualifications
RECENT GRADUATES: To be eligible, applicants must have received their degree within two years or be graduating by May of 2023, except for veterans precluded from doing so due to their military service obligation, who will have up to six years after degree or certificate completion to apply. For more information about Federal employment information for veterans, go to OPM's Feds Hire Vets .
To qualify for the Recent Graduate Program at the EL/GS- 7 or 9 grade level, you must meet the following requirements:
Qualifying experience for the EL/GS 07 level includes one year of specialized experience at least equivalent to EL/GS-05 which is in or directly related to the line of work of the position to be filled and which has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position.
Examples of specialized experience include the following:Maintains and modifies financial databases and data collections. Applies Accounting and financial principles to the design of data systems and collections. Maintains business meta data, data dictionaries and documentation for data systems or collections. Participates in requirements-gathering for data and business intelligence projects and analytic tools. Builds and maintains system or ad-hoc reports, dashboards and visualizations. Analyzes Division and office requirements to determine the type of information or analytics that will support supervision business processes and needs. Uses a variety of programming, query, reporting, analysis, and data validation, visualization, and administration tools to support business decision making and risk evaluation.
OR Education:
Bachelor's degree with a GPA of 2.95 or higher (or one year of completed graduate school experience) in in Business, Accounting or Information Systems with a concentration in business information systems, management information systems, or accounting systems or closely related fields.
Qualifying experience for the EL/GS 09 level includes one year of specialized experience at least equivalent to EL/GS-07 which is in or directly related to the line of work of the position to be filled and which has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position.Maintains and modifies financial databases and data collections. Applies Accounting and financial principles to the design of data systems and collections. Maintains business meta data, data dictionaries and documentation for data systems or collections. Participates in requirements-gathering for data and business intelligence projects and analytic tools. Builds and maintains system or ad-hoc reports, dashboards and visualizations. Analyzes Division and office requirements to determine the type of information or analytics that will support supervision business processes and needs. Uses a variety of programming, query, reporting, analysis, and data validation, visualization, and administration tools to support business decision making and risk evaluation. OR Education:
Master's degree in Business, Accounting or Information Systems with a concentration in business information systems, management information systems, or accounting systems or closely related fields.
To preview the assessment questionnaire: https://apply.usastaffing.gov/ViewQuestionnaire/11842113
Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Education
ARE YOU USING YOUR EDUCATION TO QUALIFY? You MUST provide transcripts or other documentation to support your educational claims. Unless otherwise stated: (1) official or unofficial transcripts are acceptable, or (2) you may submit a list with all of your courses, grades, semester, year, and credit for the course. All materials must be submitted by the closing date of the announcement.
GRADUATE EDUCATION: One academic year of graduate education is considered to be the number of credits hours your graduate school has determined to represent one academic year of full-time study. Such study may have been performed on a full-time or part-time basis. If you cannot obtain your graduate school's definition of one year of graduate study, 18 semester hours (or 27 quarter hours) should be considered as satisfying the requirement for one year of full-time graduate study.
FOREIGN EDUCATION: If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: http://www.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html
Additional information
If you are a veteran with preference eligibility and are claiming 5-points veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility. If you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference visit: https://www.usajobs.gov/Veterans .
Males born after 12-31-59 must be registered or exempt from Selective Service (see https://www.sss.gov/RegVer/wfRegistration.aspx ).
Veterans who, due to a military service obligation, were precluded from applying to a Recent Graduates Program during any portion of the 2 year eligibility period may have their eligibility period extended so that they receive the full 2 years of eligibility. The remaining 2-year eligibility period will begin upon his or her release or discharge from active duty. The veteran's eligibility period may not extend beyond 6 years from the date of completion of all requirements of an academic course of study.
As a participant in the Pathways Recent Graduates Program, you will receive both formal and on-the-job training to develop the required knowledge and skill to successfully perform the responsibilities of the position.
FHFA is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment regardless of race, color, religion, gender (including pregnancy, sexual orientation, and gender identity), national origin, disability (physical or mental), age (40 years of age or over), genetic information, parental status, marital status, prior protected EEO activity, political affiliation, or other non-merit factors.
REASONABLE ACCOMMODATION
FHFA provides reasonable accommodations to applicants with disabilities, except when doing so would pose an undue hardship on the Agency. If you need a reasonable accommodation for any part of the application and hiring process, please notify FHFA. The Agency's decision on granting a reasonable accommodation will be made on a case-by-case basis.
Ethics: FHFA employees are subject to government-wide ethical standards of conduct, financial disclosure requirements, and post-employment prohibitions. In addition, certain FHFA employees are prohibited from accepting compensation from Fannie Mae and Freddie Mac for a two-year period after terminating employment with FHFA. Furthermore, to avoid financial conflicts-of interest or the appearance of conflicts-of-interest, FHFA employees may need to divest or sell certain assets they, their spouse, or minor children own or control, including securities issued by Fannie Mae, Freddie Mac, or the Federal Home Loan Banks. Employees who work on Federal Home Loan Bank issues may need to sell or divest financial interests with any of the Federal Home Loan Bank members, which may include stock in bank holding companies, insurance companies, and other financial services firms. Questions regarding these requirements and prohibitions should be directed to the Office of General Counsel at (202) 649-3088.
The Office of Supervision Technology and Analytics (OSTA or Office) is responsible for the data, databases, analytics, and Information Technology (IT) used by DBR for its supervision processes. Its primary role is to provide reporting, analytics, data management, and data tool support to DBR with respect to economic, financial, mortgage, and FHLBank membership data and to act as a bridge between DBR business offices and FHFA IT staff. The Office is charged with driving innovation in the use of technology for the DBR business mission and assists other DBR business units with the specification and management of dashboards, reports and databases that capture and provide information needed to support DBR analyses and decisions.
In addition to providing analytics and data oversight expertise to DBR, OSTA also maintains the DBR regulatory reporting program under which FHLBank reporting requirements are identified and formalized and provides as-needed assistance to examiners during the course of FHLBank evaluations. Such assistance may include the preparation of ad-hoc analytics or reports or on-site visits to FHLBanks under examination.
Acts as a liaison between DBR and the Agency Office of Technology and Information Management, ensuring and coordinating the implementation of supervision IT solutions. The Financial Database Specialist will be required to obtain and demonstrate experience in IT and FHLBank supervision and, as needed, support examination and supervision processes by taking part in onsite or offsite examinations of FHLBank reporting and data processes.
As a Financial Database Specialist, the incumbent serves as a technical resource for DBR database, business intelligence and reporting projects. The incumbent will support data users by participating in requirements-gathering, database development and implementation, standardized and ad hoc report development, and the evaluation and use of data query, reporting and visualization tools and analytical applications.
The incumbent will develop and demonstrate experience in DBR's technology and information assets and FHLBank business lines and, occasionally, to support examination staff by taking part in onsite or offsite examinations of FHLBank reporting and data processes within their area of expertise.
The Financial Database Specialist will evaluate and/or assist in the adoption of innovative tools and methods to advance OSTA program areas and will have responsibilities supporting the implementation of certain data or data tools.
For less complex projects, the incumbent may be responsible for coordinating resources associated with IT efforts to develop, implement, document, and/or modify information systems and databases. The incumbent may evaluate the effectiveness of the Agency information architecture with respect to Division needs, including the appropriateness of data and applications, and participates in efforts to assure and maintain data quality, develop Division or Agency information and data policies, and develop documentation related to those duties.
The incumbent will be required to, in conjunction with Agency IT staff and/or other OSTA staff, analyze Division or office requirements to determine the type of information that will address business needs and provide advice and guidance on IT standards, strategies, policies, and processes and the alternative ways of meeting DBR's overall information technology requirements; maintain and apply knowledge in database technologies and business intelligence tools to resolve problems and evaluate new methods of enhancing existing system(s) to better meet reporting and analysis needs.
To accomplish this, the incumbent will have and maintain proficiency in basic programming, query languages and tools, reporting, analysis, and data validation/reconciliation, visualization, and administration tools to support recurring or ad hoc Division or Agency work. The incumbent must also possess knowledge of the FHFA business mission and processes.
On an as-needed basis, the incumbent will also assist the examination function with the review of FHLBank regulatory reporting and data management processes before, during or between examinations. The incumbent will also perform other duties as assigned, some of which may require travel.
Requirements
Conditions of Employment
- Open to U.S. Citizens and Nationals who are Recent Graduates and have completed a qualifying degree from a qualifying education institution within the previous 2 yrs. Note: Students who will graduate by May 2023 may apply.
- Transcripts are required- Must show graduation date.
- Resume and supporting documents (See How To Apply)
- Suitable for Federal employment, as determined by background investigation
- May be required to successfully complete a probationary period
- Only experience and education obtained by the closing date of this announcement will be considered.
- Males born after 12-31-59 must be registered for Selective Service
Qualifications
RECENT GRADUATES: To be eligible, applicants must have received their degree within two years or be graduating by May of 2023, except for veterans precluded from doing so due to their military service obligation, who will have up to six years after degree or certificate completion to apply. For more information about Federal employment information for veterans, go to OPM's Feds Hire Vets .
To qualify for the Recent Graduate Program at the EL/GS- 7 or 9 grade level, you must meet the following requirements:
Qualifying experience for the EL/GS 07 level includes one year of specialized experience at least equivalent to EL/GS-05 which is in or directly related to the line of work of the position to be filled and which has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position.
Examples of specialized experience include the following:
OR Education:
Bachelor's degree with a GPA of 2.95 or higher (or one year of completed graduate school experience) in in Business, Accounting or Information Systems with a concentration in business information systems, management information systems, or accounting systems or closely related fields.
Qualifying experience for the EL/GS 09 level includes one year of specialized experience at least equivalent to EL/GS-07 which is in or directly related to the line of work of the position to be filled and which has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position.
Master's degree in Business, Accounting or Information Systems with a concentration in business information systems, management information systems, or accounting systems or closely related fields.
To preview the assessment questionnaire: https://apply.usastaffing.gov/ViewQuestionnaire/11842113
Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment. You will receive credit for all qualifying experience, including volunteer experience.
Education
ARE YOU USING YOUR EDUCATION TO QUALIFY? You MUST provide transcripts or other documentation to support your educational claims. Unless otherwise stated: (1) official or unofficial transcripts are acceptable, or (2) you may submit a list with all of your courses, grades, semester, year, and credit for the course. All materials must be submitted by the closing date of the announcement.
GRADUATE EDUCATION: One academic year of graduate education is considered to be the number of credits hours your graduate school has determined to represent one academic year of full-time study. Such study may have been performed on a full-time or part-time basis. If you cannot obtain your graduate school's definition of one year of graduate study, 18 semester hours (or 27 quarter hours) should be considered as satisfying the requirement for one year of full-time graduate study.
FOREIGN EDUCATION: If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: http://www.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html
Additional information
If you are a veteran with preference eligibility and are claiming 5-points veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility. If you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference visit: https://www.usajobs.gov/Veterans .
Males born after 12-31-59 must be registered or exempt from Selective Service (see https://www.sss.gov/RegVer/wfRegistration.aspx ).
Veterans who, due to a military service obligation, were precluded from applying to a Recent Graduates Program during any portion of the 2 year eligibility period may have their eligibility period extended so that they receive the full 2 years of eligibility. The remaining 2-year eligibility period will begin upon his or her release or discharge from active duty. The veteran's eligibility period may not extend beyond 6 years from the date of completion of all requirements of an academic course of study.
As a participant in the Pathways Recent Graduates Program, you will receive both formal and on-the-job training to develop the required knowledge and skill to successfully perform the responsibilities of the position.
FHFA is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment regardless of race, color, religion, gender (including pregnancy, sexual orientation, and gender identity), national origin, disability (physical or mental), age (40 years of age or over), genetic information, parental status, marital status, prior protected EEO activity, political affiliation, or other non-merit factors.
REASONABLE ACCOMMODATION
FHFA provides reasonable accommodations to applicants with disabilities, except when doing so would pose an undue hardship on the Agency. If you need a reasonable accommodation for any part of the application and hiring process, please notify FHFA. The Agency's decision on granting a reasonable accommodation will be made on a case-by-case basis.
- (202) 649-3963
- 711 TTY
- reasonableaccommodations@fhfa.gov
Ethics: FHFA employees are subject to government-wide ethical standards of conduct, financial disclosure requirements, and post-employment prohibitions. In addition, certain FHFA employees are prohibited from accepting compensation from Fannie Mae and Freddie Mac for a two-year period after terminating employment with FHFA. Furthermore, to avoid financial conflicts-of interest or the appearance of conflicts-of-interest, FHFA employees may need to divest or sell certain assets they, their spouse, or minor children own or control, including securities issued by Fannie Mae, Freddie Mac, or the Federal Home Loan Banks. Employees who work on Federal Home Loan Bank issues may need to sell or divest financial interests with any of the Federal Home Loan Bank members, which may include stock in bank holding companies, insurance companies, and other financial services firms. Questions regarding these requirements and prohibitions should be directed to the Office of General Counsel at (202) 649-3088.