Duties

Serves as a Senior Financial Systems Analyst performing professional analyst work relating to the financial activities of the Financial Systems Division within the Financial Services Directorate (FSD). The work requires the design and adaptation of automated financial reporting systems.

The incumbent also serves as an expert advisor and assistant to the Financial Systems Director for administering a business intelligence tool and data warehouse for a central financial management system with nine complex modules.

Creates complex, multi-faceted financial reports through SQL and other business intelligence technologies, such as Crystal Reports, Business Objects Enterprise server, Web Intelligence, Tableau, Toad, and Wiiisdom (formerly 360 Suite). Updates and modifies existing reports, designs new applications, and has continuing responsibility for maintenance of reporting programs. Recommends needed redesign studies. Participates in the design and development stages of reports developed internally and/or under contract. Reviews proposed policy, regulations, and procedural changes to determine impact on area of responsibility. Recommends priority areas of emphasis for improvement of current systems. Supports and maintains the agency reporting systems, including performing daily quality assurance of the data. Applies knowledge of key financial principles and concepts and knowledge of federal budgeting. Employs mastery of financial data and reporting concepts and practices, including application of IT principles and standards. Provides expert advice, guidance, and recommendations to management and other financial system analysts on critical financial data reporting issues.

Provides a team of financial systems analysts with day-to-day guidance in work projects and reviews team members' work products; distributes and balances the workload among employees in accordance with established work flow or job specialization, and assures timely accomplishment of the assigned workload.

As a technical expert, drafts policy and guidelines for the development of data structures and access strategies that conform to business and mission requirements. Supports projects to develop and implement new data management schema. Develops logical data models to be translated into workable physical database schema and structures in the database development process. Selects modeling methodologies and tools. Generates models that are capable of accommodating new business requirements and processes. Updates and tests ETL scripts using PL/SQL to load data from the financial management system (Momentum) into the Oracle-based financial reporting data warehouse, sitting on a Linux operating system.

Provides both professional expertise and systems support in the development and operation of automated financial management and/or reporting applications as well as the Library's budget system. Provides all FSD, Library, and legislative branch partner agency functional areas with application assistance during all phases of the development, establishment and maintenance of integrated financial systems and reporting systems.

Requirements

Conditions of Employment

Library of Congress employees are prohibited from using illegal drugs, including marijuana. The Library is part of the Federal Government and abides by federal law, so regardless of individual state or District of Columbia laws, marijuana use is illegal, considered criminal activity, and can affect your employment at the Library. In addition, past or current drug use and activities (e.g., selling or distributing) may deem you ineligible for employment.

Qualifications

Applicants must have had progressively responsible experience and training sufficient in scope and quality to furnish them with an acceptable level of the following knowledge, skills, and abilities to perform the duties of the position without more than normal supervision.

Ability to apply analytical methods and techniques to identify and/or resolve complex financial issues.**

Ability to use financial computer systems, business intelligence software applications, and data warehouses for financial analysis work.**

Ability to interact collaboratively with others and provide consultation on financial matters, reports, and data.**

Ability to communicate in writing.

Knowledge of the Federal budget process and financial management practices and procedures.

Knowledge of research and analysis used to assess program financial performance reporting.

Ability to communicate effectively other than in writing.

Education

This job does not have an education qualification requirement.

Additional information

The appointee must be able to obtain and maintain a Secret Security Clearance.

Although it is the Library's policy to afford the maximum pay benefit to employees when setting rates of pay, a new appointee who has had no previous Federal service will generally be paid at step one of the grade.

The Library of Congress is an equal opportunity employer. Women, minorities, and persons with disabilities who meet eligibility requirements are strongly encouraged to apply.

Applicants must submit a complete application package that is received by the closing date of this announcement.

Appointment/retention is subject to a favorable evaluation of an appropriate personnel security/suitability investigation. For more information, please see: Vetting Process

This agency provides reasonable accommodation to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please email ADA@loc.gov. The decision on granting reasonable accommodation will be determined on a case-by-case basis.

Applicants with disabilities may be considered under special hiring procedures and must submit an appropriate certificate of eligibility when applying for this position. The proof or disability/certification may be issued by the State Vocational Rehabilitation Office, Disability Services or Career Services office of the applicant's college or university, or the Department of Veterans Affairs. The letter must verify that the applicant has a severe disability and must be dated within three years of the date of the application. Certification from health care providers are not accepted. For more information contact the Library's Office of EEO/Diversity Programs at 202-707-6024 or email spp@loc.gov. FAILURE TO SUBMIT YOUR CERTIFICATION WILL CAUSE YOUR APPLICATION TO NOT BE CONSIDERED UNDER THE SELECTIVE PLACEMENT PROGRAM.

The Library of Congress is the national library of the United States and is part of the Legislative Branch of the Federal government. As such, all positions are in the excepted service.

The Library reserves the right to fill a lesser or greater number of vacancies indicated during the life of this vacancy announcement.

Initial permanent appointments to the Library of Congress require completion of a one-year probationary period. Probationary periods served at other Federal agencies do not count toward this requirement.

The Library of Congress may offer repayment for all or part of federally insured student loans. However, not all service units within the Library of Congress participates in the repayment of federally insured student loans. Therefore, determination to repay a federally insured student loan is subject to approval by the appropriate service unit.

Are you a veteran? Please indicate the type of veterans' preference you are claiming in your application materials and/or applicant profile and provide the appropriate supporting documentation to validate your claim. Those applying for 5-point preference must submit Member Copy 4 of your DD 214. Those applying for 10-point preference must fill out an SF-15 (click here for the form) and provide the required documentation listed on the back of the form. If required supporting documentation is not attached, Veterans' Preference will not be considered in the application process.