Financial Analyst

Job ID: FL-765961

Onsite/Local Govt Financial Analyst with Pivot Tables, VLOOKUP/XLOOKUP, GAAP accounting

Location: Ocoee, FL(Dept of Transportation DOT Turnpike Chief Financial Officer 850)
Duration: 12 Months
Position: 1(2)

Skills:
Ability to read, speak and understand English Required
Ability to communicate effectively through verbal and written communications. Required
Immediate/Advance Excel skill with formulas, sorting, and filtering data Required 5 Years
Immediate/Advance level Excel Required 5 Years
Experience with financial reporting and preparing financial statements. Required 3 Years
Experience using statistical data, including debits/credits. Required 3 Years
Ability to utilize problem-solving techniques Required
Tracking other general consultant charges to provide for accurate project cost reporting Highly desired 1 Years
Research capital project expenses and reclassify them as fixed assets Highly desired 1 Years
Experience with state government accounting Highly desired 1 Years
Immediate/Advance level Pivot Table Required 5 Years
Immediate/Advance level XLOOK UP, or V LOOKUP Required 5 Years
Associate s or Bachelor s degree in Accounting from an accredited College or University. Required

JOB DESCRIPTION:
DOT Ocoee Turnpike -Accountant-Preparation of financial reconciliations, analysis, construction work-in-progress ledger, mid-year and year-end closing entries and process.
WORK ENVIRONMENT: Professional office environment. A successful candidate must be able to multi-task and take initiative to trouble shoot issues that may arise. Ability to accept constructive criticism with a "team player" attitude and excellent work ethic for the success of the department. Proficient in Excel and government accounting.
JOB DESCRIPTION:
** Preparation of financial reconciliations, analysis, construction work-in-progress ledger, mid-year and year-end closing entries and process.
** Preparation and presentation of the Turnpike System s financial information as required by GAAP, the Department of Transportation (Department) and the Department of Financial Services (DFS) requirements.
** Assist with the Turnpike s year-end and mid-year financial reporting closing processes.
** These processes include, but are not limited to, the preparation of necessary accrual, adjusting and/or correcting entries, analyzing pre-closing trial balances for accuracy and appropriateness, and ensuring all Department closing requirements are met in a timely manner.
** Research capital project expenses and reclassify them as fixed assets.
** Review and evaluate current processes relating to financial reporting and reconciliations.
** Recommend improvements as deemed appropriate and develop action plans for their implementation.
** Document policies and procedures.
KNOWLEDGE, SKILLS, AND ABILITIES:
** Knowledge of accounting principles, practices, and procedures.
** Ability to review fiscal data for accuracy and completeness.
** Ability to analyze and interpret accounting data.
** Ability to understand and apply applicable rules, regulations, policies, and procedures.
Work Sample project attachment found on the reference tab of this requisition, must be completed by the candidate and upload at the time of submission to be considered for this opportunity.
Please have the candidate complete the 5 questions on the worksheet, show the steps how he/she came to these answers and upload in the same section as their resumes & RTR
Only those candidate s that have submitted the completed work sample at the time of submission will be shortlist for further review and consideration.
This Work Sample project will determine if the manager would like to move forward with an In-Person interview.