Financial Systems Analyst - MacFadden

Financial Systems Analyst

MACFADDEN - Norfolk, Virginia Area

Job description
Financial Systems Analyst

MacFadden is seeking a Financial Systems Analyst to support the United States Coast Guard (USCG) Finance Center (FINCEN) in Chesapeake, VA. The Analyst will be part of a diverse and experienced team providing support within the FINCEN accounting systems branch. The ideal candidate will possess a combination of financial experience, functional and technical experience with Oracle Federal Financials, knowledge of USCG financial systems and business operations, and functional financial systems support experience.

The Analyst will work within the Reconciliations Section as part of a heavily integrated support team providing critical support throughout the FINCEN accounting systems operating environment, with a focus on supporting the Core Accounting System (CAS) and Checkfree. The Analyst will work and interact regularly with other FINCEN team members, personnel in various Divisions, and other personnel or stakeholders within the systems and accounting branches. Activities will center on:


•Routine support to the FINCEN Reconciliations Section to include support for Core Accounting System (CAS) with specific focus on technical support for the Checkfree accounting system.

•Data extraction support (e.g. monitoring, reconciliation, troubleshooting extract procedures) from or between for CAS and Treasury.

•Creation and/or maintenance of routine and ad-hoc Checkfree reports.

•General support for reconciliation, reporting, data extraction and functional and technical user support.

•Utilize a high degree of analytical, problem solving and troubleshooting abilities to research and resolve various problems.

•As part of support provide to stakeholders input and recommendations, ideas for process improvement, and ensure a high level of quality support.

•Ensure compliance with and assist in improvement or development of related policies, standards, and procedures..

Clearance Requirements

•Must be able to obtain a successful USCG Minimum Background Investigation (MBI).

Work Location

•Chesapeake, VA; minimal travel (<25%) may be required.

Desired Skills and Experience


Experience and Knowledge
•Bachelor’s degree in Accounting, Finance or a related discipline with a minimum of 5 years related experience

•Knowledge and/or experience with the USCG Core Accounting System (CAS), Financial Procurement Desktop (FPD), Checkfree and other CAS feeder and interfacing systems.

•Functional knowledge of Oracle Federal Financials (i.e. Oracle E-Business Suite) (release 11 or higher) including all relevant modules.

•Experience with Oracle RDBMS, PL/SQL, and technical aspects of Oracle Federal Financials database tables and strong experience using querying and analysis tools such as Microsoft Excel, Toad, SQL Navigator, and SQL*PLUS.

•Demonstrated experience providing functional financial systems and business operations support in a Federal government setting to include experience providing reconciliation support.

•Ability to operate effectively with and interface across all levels of management and skill, and to operate both in an independent and team member role.

•Possess professional writing skills with ability to author business or technical documents, synthesize and report data, and develop presentations.

•Solid interpersonal and communication skills and proficiency with Microsoft Office applications such as Excel and Word