Lucas Group is partnering with a growing manufacturing company located in the Galleria area in their search for a Financial Analyst. This is a contract engagement and is estimated to be 4-6 months in duration.
Responsibilities:
Identify the sales data-based where the information resides at and properly isolate the data needed to for the calculation
Calculates/validates pay variable earnings accurately and on time for assigned sales teams and in line with current comp plan rules
Responsible for the accuracy and proper reconciliation of the sales commission accrual ensuring that future payouts are properly reserved for.
Prepare and distribute reports that summarize business unit's activity per sales person and related commission paid out.
Act as a business unit point of contact for requests from the sales team regarding commission payouts and sales performance.
Understand the various rebates programs the company offers and the information necessary to estimate payouts
Identify the data-based where the information resides at and properly isolate the data needed to estimate payouts by program, customer and model number.
Prepare margin analysis per customer considering all programs in place to assess account profitability.
Responsible for the accuracy and proper reconciliation of the rebates and marketing funds accruals ensuring that future payouts are properly reserved for.
Prepare and distribute reports that summarize net customer profitability in a confidential manner for senior management review..
Participate in the OB preparation for the business unit in partnership with the Director of Finance and/or Finance Manager and members of the Leadership Team
Prepare the annual budget and subsequent forecasts for the rebates and commission expenses
On a monthly basis, prepare variation analysis for the rebates and commissions expenses versus budget and previous forecast.
Investigate and provide explanations for the variances calculated in the previous items. Identify root-causes for the discrepancies, and propose solutions if the causes are related to process deficiencies.
Requirements:
Bachelor degree required in Accounting or Finance
Prior experience is in an analytical role.
The ideal candidate has to have the energy and drive to develop the process and deliver on the responsibilities described above using strong analytical and problem solving skills.
Expert Excel, Access, MS Word and SQL Skills (huge plus)
Possess strong interpersonal skills to deal effectively with a wide variety of people assertively and confidently
