Financial Analyst
Hawthorne Advertising
Los Angeles, CAThis was removed by the employer on 4/17/2017 10:45:00 AM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the Accounting/Finance Category
Browse the Advertising Category
Search for Financial Analyst jobs in Los Angeles-CA
Search all Financial Analyst postings
Full Time Job
Hawthorne seeking a Financial Analyst with technical expertise that has a working understanding of 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.
Key Responsibilities:
Works with Director of Finance 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
- 1-4 years advertising agency or service industry experience preferred, not required
- Financial and operational reporting experience or education
- Experience analyzing financial statements
- Excellent analytical skills
- Strong working knowledge of Microsoft Excel including pivot tables, formulas, look-ups
- Strong working knowledge of database program for data manipulation and report writing
- Implementation / enhancement experience of Sage 100 or similar
- Experience with financial software programs implementation and integrations
- Service industry job costing familiarity
- Experience with timesheet applications and reporting
- Financial planning experience including budgeting, reforecasting, variance analysis of actual to budget
- Financial analysis including ad hoc analysis, monitoring variances, identifying trends, providing recommending actions to management
- Development and reporting of KPI's
- Accounting software experience preferred
- Experience in extraction and download of data
Responsibilities:
Financial Analysis
- 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
- Provide input for RFI/RFPs
Financial Systems
- 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
- Facilitate requirements gathering sessions with a team of accounting users
Financial Reporting
- Monthly financial reporting, departmental financial statements, client, product, department profitability reports, variance reports
- Tax and regulatory reporting support
- Job costing and employee utilization reports
Financial Planning
- 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
Job Costing
- 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
Production Accounting
- Responsibilities including managing production budgets for shoots, administering payments of production expenses, and performing analysis.