Job Title: Financial Analyst/Accountant 3
Job Location: Lafayette, IN 47905
Expected Duration: 2 Years(24 Months)
The main function of an accountant is to analyze financial information and prepare financial reports to determine or maintain record of assets, liabilities, profit and loss, tax liability, or other financial activities within an organization. A typical accountant is responsible for analyzing and communicating financial information for clients.
Prepare, examine or analyze accounting records, financial statements or other financial reports to assess accuracy, completeness, and conformance to reporting and procedural standards. Develop, maintain, and analyze budgets, preparing periodic reports that compare budgeted costs to actual costs. Develop, implement, modify, and document recordkeeping and accounting systems. Compute taxes owed and prepare tax returns, ensuring compliance with payment, reporting or other tax requirements. Prepare forms and manuals for accounting and bookkeeping personnel and direct their work activities.
Skills: Verbal and written communication skills, attention to detail, and critical thinking. Ability to work independently and manage one’s time. Ability to apply accounting and mathematical principles to work as needed. Ability to analyze business trends and project future revenues and expenses. Knowledge of federal, state, and company policies, procedures and regulations as related to accounting. Previous experience with computer applications, such as Microsoft Word, Excel and PowerPoint, and any other related accounting software.
Education/Experience: Bachelor's degree in accounting or related financial discipline required. An advanced degree in a financial discipline is preferred. 5-7 years financial and/or accounting experience required.
Manage annual budget for 90+ engineering R&D programs. Determine overall financial health of Lafayette business unit and take corrective actions to align business plan with forecasts. Determine financial health at the program level and recommend actions to correct discrepancies between budgets and forecasts.
Compile and continuously update individual program targets. Forecast budget for labor, material, and testing within two Microsoft Excel- based spreadsheet tools. Facilitate budget negotiation among engineering managers. Create training documentation and hold training sessions with engineering managers on proper accounting, budgeting, and forecasting principles. Develop Microsoft Excel-based financial tools using raw Accounting data, Pivot tables, vlookups, and extensive formula integration to track monthly expenditures on programs. Use the Excel-based financial tracking tools to create simplified and organized expenditure reports for engineering managers. Forecast for planned monthly expenditures including labor, material purchases, testing charges, and indirect materials and expenses. Analyze monthly spend vs. forecasted spend to assist in program prioritization. Engage engineering managers and Accounting to resolve mis-charges or discrepancies as needed.
Bachelor’s degree in finance, management, or accounting is recommended.
Intermediate skills with Microsoft Excel: Vlookup; Index-Match; Filters, sorting; Pivot Tabels; Data Mining; and If statements / nested if-statements.
Good communication (written and verbal), Strong Initiative, Attention to Detail, and Enjoys working with numbers and spreadsheets.