Hawthorne AdvertisingFairfield, IA
Full Time Job
We are seeking an entry level Financial Analyst with technical expertise that will be trained and assume responsibility for financial analysis, financial modeling, financial / operational reporting, accounting and finance systems, job costing and accounting and enjoys taking on new challenges. The successful candidate will analyze and model data from the ERP and other systems to identify trends, projected results, and produce pro forma financials utilizing Excel. The ideal candidate for this position will possess intermediate Excel skills, have excellent organization and communication skills as well as possess a strong attention to detail. You will support our Accounting team and CFO in the design and delivery of technology solutions which includes project management oversight for system integration and reporting efforts involving corporate financial data. Additionally you must have an understanding of accounting processes and how accounting systems work, either through experience or education.
Works with CFO to provide financial planning, analysis, reporting, KPI's, and ad hoc projects support, playing a vital role in collecting and providing information that drives the strategic direction of the Agency. Leads the implementation, integration, adaptation and utilization of financial analysis business intelligence software tools. Manage the development and implementation of Sage 100 functionality including Business Intelligence. Financial and operational reporting, utilizing Excel, collecting data from various sources. Job costing reporting and analysis. Enhancement of timesheet software to provide robust and timely reporting. Annual budgeting and monthly reforecasting support including variance analysis, updating of information, and refreshing of templates.
Qualifications / Requirements:
-BA/BS degree in Finance or Accounting is required.
-Financial and operational reporting experience or education.
-Familiar with financial statements.
-Excellent analytical skills.
-Strong working knowledge of Microsoft Excel including pivot tables, formulas, look-ups.
-Familiar with accounting systems.
-Financial planning understanding including budgeting, reforecasting, variance analysis of actual to budget.
-Financial analysis including ad hoc analysis, monitoring variances, identifying trends, providing recommending actions to management.
-Provide monthly and ad hoc financial analysis, Excel modeling development and maintenance.
-Update, review, and develop monthly KPI's.
-Gathering of internal and external data, analysis, and provide recommendations.
-Work closely with internal staff & 3rd party vendors to design, develop, test, and deploy complimentary solutions and integrations of systems with Sage 100.
-Design and develop Finance Technology solutions using Sage 100 and add-on applications.
-Utilize BI technology to provide reporting solutions supporting financial analysis.
-Provide solutions for process automation.
-Review and update system documentation and procedures.
-Create ad hoc reports and validate new and existing reports to ensure data integrity.
F-acilitate requirements gathering sessions with a team of accounting users.
-Monthly financial reporting, departmental financial statements, client, product, department profitability reports, variance reports.
-Tax and regulatory reporting support.
-Job costing and employee utilization reports.
-Annual budget data collection, template development and completion, presentation creation.
-Monthly reforecasting, analysis of actuals to budget, variance explanations.
-Revenue forecasting, working with Account Directors to develop revenue forecast by client.
-Data downloads from accounting system, timesheet software, and other applications.
-Development of reports in Excel, and eventual transition into BI reporting tool.
-Development of templates.
-Create advanced formulas, pivot tables, VLookups.
-Monitoring of costs and hours posted to jobs.
-Jobs analysis and reporting.
-Revamp employees hours collection process, both system and process, to provide robust reporting and dashboards.
Please note that EntertainmentCareers.Net uses 'disposable' email addresses in our postings. They change frequently so do not post the contact information outside of EntertainmentCareers.Net as it will likely be invalid.
Employer will allow resumes sent in the body of the email OR as an attachment. Apply Online