Financial Reporting & Accounting Analyst (RR)

**Interested in Applying? I have a few preliminary questions** - Are you an expert at creating and maintaining excel formulas? - Do you love analysis and problem solving? - Are you really detailed oriented? - Are you looking for a job in the Department of State, located in Charleston, SC? If you answered yes to most of these, keep reading on. **Why is this Different from other Job Opportunities?** All contractors supporting this Department must be able to either possess or obtain a Security Clearance of “**Secret**”. ***Important note to consider*:** A Secret Clearance will open a lot of other doors for your career in the Government to include possibilities of being hired directly. **You Must Meet these Minimum Requirements** - A four-year degree from an accredited university or college (Accounting preferred) - 8 years of overall relevant professional experience (see “**Day-to-day Job Responsibilities”** below) - Experience and education or certifications may be substituted for education or degree type - A Master’s degree and/or CPA certification or Certified Government Financial Manager (CGFM) is highly desirable - Excellent verbal and written communication skills. - Analytical, detail orientated and a team-player. - General Ledger experience. - Proficient in Microsoft Excel and Access. **We are also Looking for** - Demonstrated technical, task leadership and communications skills. - Experience in analysis of automated financial management systems with preference for those systems supporting Department of State. Subject matter experience with Federal accounting and financial management policies, practices, reporting, and operations is desirable; demonstrated capability to analyze complex financial systems - requirements, problems, and issues; develop, communicate, and implement cost-effective solutions to the Department's requirements. - The Department prefers candidates who have experience with DoS financial systems and accounting practices, and Treasury reporting processes and requirements. **Our most Successful Employees in this Position Demonstrate** - Advanced excel skills (pivot tables, power query, advanced formulas, V-LOOKUPS) - Excellent analytical skills - Experience reconciling financial accounts - Good Team Player - Detail Oriented - Active listening skills - Ability to work independently with little to no supervision - Initiative driven to conduct research and find more efficiencies in the business process **Day-to-day Job Responsibilities include** The employee will provide Business Process Analyst support to The Bureau of the Comptroller and Global Financial Services (CGFS), Department of State (DoS), Charleston, SC for the Office Reports and Reconciliations. The Office of Reports and Reconciliation is responsible for Coordinating and Submitting the monthly reports to treasury for Department of State Consolidated American Payroll for disbursements, collection, and reclassification activity. The Reports and Reconciliation section also processes the DoS confirmation of payment by Treasury, and the disbursement cancellations for erroneous, stale dated, and lost/stolen checks. Detailed job responsibilities include: - Perform Fund Balance with Treasury ([FBWT](https://www.fiscal.treasury.gov/reports-statements/fbwt/reconciliation-procedures.html)) and cash reconciliation while developing Subject Matter Expertise - Determine root cause, provide ongoing analysis and recommendation for approval of cash reconciliation processes - Reconcile FBWT differences due to Interfaces occurring outside of accounting system. Provide root cause analysis, and recommendations for corrective actions. - Reconcile Proprietary and Budgetary cash balances in compliance with Treasury and Office of Management and Bud - get guidelines as applicable and critical to financial reporting by appropriation fund symbol. - Support business process improvement and special project initiatives. - Attend meetings as requested and assist all department s…