Accounting/Fiscal Manager I - Financial Planning Analyst (61035225)

Doc PersonalBeratung GmbH; Columbia (SC); On-site; USD 65,000 - 90,000; Full time

Job summary

The South Carolina Department of Transportation is seeking a finance professional to manage project funding within the Office of Intermodal and Freight Programs. You will oversee compliance, reporting, and accounting processes for federal, state, and local transportation initiatives.

You will review invoices, prepare journal entries in SCEIS, and generate monthly drawdown and ECHO reports. A bachelor’s degree in accounting, finance, or a related field and 3.5 years of experience are required.

Qualifications

• Bachelor's degree in accounting, finance, business, or a related field.
• Experience in finance, auditing, budgeting, or banking.
• Familiarity with government accounting standards and FMIS/SCEIS is a plus.

Responsibilities

• Interpret federal, state, and local regulations to represent directives in transportation project authorizations.
• Assist Project Fund Management with transportation project invoice review and distribution duties.
• Review transit, freight, and rail financial transactions, funding transfers, grant applications and closeouts for compliance.
• Review subrecipient reimbursement documentation for proper federal share and activity lines; ensure invoices are coded in SCEIS.
• Prepare journal entries to reconcile TrAMS disbursements to the general ledger in SCEIS; submit monthly drawdown and FTA ECHO reports.
• Authorize state/local projects per Consolidated Plan via P2S; perform QC of authorization packages.
• Monitor federal projects in final voucher; resolve issues; issue ten-day notices; transfer to lapsing funds; update closure spreadsheets.
• Ensure projects are closed timely; report monthly on federal funds obligated and released.
• Authorize federal project funding per FHWA standards and FMIS; update project information and generate authorization forms.
• Maintain budget and grant master data in SCEIS; process state/local final vouchers and funding utilization reviews.
• Assist in preparation of periodic financial and statistical reports and budget planning presentations; distribute funding allocation letters to sub-recipients.
• Reconcile Office of Intermodal and Freight Programs apportionments, cash balances, budgets and expenditures; notify of financial issues; prepare budget transfer forms.
• Other related duties as assigned.
• A bachelor's degree and 3.5 years of professional experience in accounting, finance, or related area; valid driver's license.

Skills

Financial management

Budgeting

Accounting

Regulatory compliance

Education

Bachelor's degree in accounting, finance, business or a related field

Job description

Interprets federal, state, and local regulations, and financial agreements to accurately represent their directives in transportation project authorizations. Assists Project Fund Management (PFM) with transportation project invoice review and distribution duties. Assists in financial management, reporting, and oversight of the Office of lntermodal and Freight Programs in compliance with federal, state, and local regulations.

Reviews transit, freight, and rail financial transactions, funding transfers, grant award applications, and grant award closeouts to ensure compliance with agency budget and federal eligibility requirements. Reviews Office of Public Transit's subrecipient reimbursement documentation to ensure proper federal share, grant performance dates, and activity line items (Alls) are applied. Ensures that invoices use proper SCEIS coding prior to distribution to appropriate Accounts Payable personnel for processing. Prepares journal entries as needed to reconcile TrAMS disbursements to the general ledger in SCEIS. Submits monthly drawdown reports for management review and prepares monthly Federal Transit Administration (FTA) ECHO drawdown reports to Accounting Department processing.

Authorizes state and local projects based on the Consolidated Plan as approved by Deputy Secretaries or Letting and Award process in the agency's project management software platform (P2S). Performs quality control of project authorization packages prior to archival in the agency's ProjectWise database system and distributes packages to end-users.

Monitors and tracks federal projects in final voucher with pending issues which must be resolved prior to closure utilizing and maintaining tracking spreadsheets. Identifies and resolves current bill issues prior to sending ten (10) day notices to PFM analysts. Completes departmental transfers to shift expenditures to lapsing and older funds prior to sending ten (10) day notices. Updates closure spreadsheets with current project statuses and dates. Ensures all projects are closed in a timely manner and ensures any outstanding issues preventing closure are documented and tracked closely. Reports monthly on federal funds obligated and released in order to monitor the utilization of federal obligation limitation.

Authorizes federal project funding in accordance with departmental/ Federal Highway Administration (FHWA) standards, the Consolidated Plan, and procedures in Financial Management Information Systems (FMIS) upon approval by Deputy Secretaries or Letting and Award process. Ensures FHWA standards and procedures are met prior to requesting federal funding. Confirms correct fund sources and federal share values are applied, authorization forms are generated, and systems are updated. Proactively contacts appropriate personnel to request necessary information required to complete requests. Performs complex federal appropriation selection to efficiently and effectively utilize all eligible federal funding. Ensures fund sources utilized on projects are program specific based on programmed funding categories. Updates project information and generate project authorization forms using P2S, FMIS, and other necessary systems. Appropriately applies all applicable guidelines and contract language. Proactively identifies and utilizes lapsing federal funds.

Maintains budget and grant master data in SCEIS and notifies Office of lntermodal and Freight Programs personnel of proper coding.

Processes state and local project final vouchers. Reviews authorized funding to ensure appropriate utilization of state and local funds. Proactively completes departmental transfer requests to align expenditures with authorized funding.

Assists in the preparation of Office of lntermodal and Freight Program periodic financial and statistical data reports. Assists in the preparation of Office of lntermodal and Freight Program budget planning presentations for management review. Prepares and distributes financial notice of funding allocation letters for sub-recipients.

Assists in reconciliation of Office of lntermodal and Freight Programs federal apportionments, state cash balances, and project budgets and expenditures. Proactively notifies Office of lntermodal and Freight Programs of financial issues requiring action. Prepares South Carolina Enterprise Information System (SCEIS) budget transfer forms to request action by the Budget Office. Performs other related duties as assigned.

A bachelor's degree in accounting, finance, business or a related field and three and one-half (3.5) years of professional experience in a related area, such as accounting, auditing, finance, or banking; or an approved acceptable equivalence. A valid motor vehicle operator's license is required.

The physical demands for the essential functions includes sitting or standing at a desk for an extended periods and working on a computer. May be required to lift up to 30 lbs. May be required to work outside normal business hours.

The South Carolina Department of Transportation is committed to a diverse workforce and does not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age (40 or older), disability or genetic information.