Sr. Financial Analyst - Trade

Masco • Indianapolis, IN

2d • Hybrid

About The Position

This Sr. Financial Analyst position reports to the Director of Finance – Trade within Delta’s corporate FP&A team and serves a multitude of stakeholders within our corporate Finance function as well as the Trade channel and the leaders of that strategically important segment of our business. As demonstrated below, core responsibilities are grouped into three major areas of responsibility including: (1) Corporate FP&A, (2) Trade Partnership – Builder and (3) Trade Partnership – Non-Builder. We are looking for an individual to be a trusted business partner for our corporate Finance function and to our Trade channel stakeholders and leadership teams. This role is provided the opportunity for ongoing review and influence on meaningful business case opportunities and programs we offer to key customers and has a direct impact on service levels to our customers, the programs we offer them and the method and pace of our growth. This position provides creative independent work and includes significant involvement within dynamic cross-functional team settings. In order to be successful in this role, the candidate must be good at analysis, and prioritize a balance of risk mitigation and communication to Finance leadership while also building and helping to grow partnership levels between Finance and our Trade channel team members.

Requirements

• B.S. degree in Finance or Accounting from a 4-year college or university.
• 5+ years related experience in financial roles.
• Experience supporting the commercial side of the business from a Finance role will be a strategic advantage to a candidate.
• Ability to effectively communicate complex problems at all levels of an organization, a proactive nature to recommend and improve processes, and be self-motivated to find and propose solutions.
• Strong proficiency in Excel-based financial analysis and modeling is needed.
• A high degree of professional excellence characterized by sound independent judgment, initiative, and a high standard of ethics is needed.

Nice To Haves

• prior SAP and Power BI experiences is preferred.

Responsibilities

• Responsible for Trade GTN budgeting, forecasting, and analysis of costs that reduce net sales.
• Lead monthly financial meetings with the Sr. VP of Finance and Sr. Director of FP&A to report out on channel/customer sales and expenses with comparison YOY and to forecast.
• Provide commentary on changes to forecast, prior year, and sales results.
• Inform management of risks and opportunities to the Trade forecast.
• Prepare and analyze standard monthly financial reports for Finance and other departments and develop and improve financial reporting process.
• Prepare Net Sales flash forecast with FP&A team on mid-month, Day -1, and Day 1 of month end.
• Collaborate with FP&A team members to maintain and improve consistencies and align strategies for multiple business channels with other FP&A team members.
• Work closely with the Trade Accountant to review GTN month-end calculations including proper COPA mapping, calculate and provide assumptions for builder home closings, builder price protection claims, and WIP program reserves.
• Complete a New Construction report monthly and provide to the respective accounting team members.
• Maintain a continuous improvement mindset identify and implement process improvements in reporting, transacting, and analysis processes and tools.
• Be an agile business partner to both Finance and the Trade channel leaders where there can frequently be competing interests within the stakeholder groups.
• Support Builder team by reviewing and/or preparing financial statements, depending on the builder size and complexity of negotiations.
• Work with the Masco Legal team, as needed, to review standard contract verbiage, changes, and ad-hoc contracts to ensure the terms of the contract mitigate risk and can be processed by accounting as outlined.
• Work closely with the Sales Enablement CRM team to provide the assumptions, ensure accurate P&L calculations, and validate approval routing is correctly captured in Salesforce, after such details have been aligned to with the Sales Leaders (at a minimum, such details should be reviewed annually).
• Review and route builder P&Ls entered into Salesforce by the Regional Directors/Agencies, generate contracts, and submit contracts and corresponding data to the Delta Contract team.
• Assist in preparing and reviewing Business Case PowerPoint presentations for contract terms that meet the thresholds requiring ELT and/or Masco approvals.
• Process builder signing bonuses and account development funds within the required timeline as defined by the signed builder contract.
• Present Builder sales and expenses to Builder team each month.
• Obtain insights from the Builder team on significant contract performance, including but not limited to, potential upcoming renewals, significant spend increases, significant underperformance and under utilized reserves, etc.
• Inform and consult channel partners on financial analysis results and/or recommendations, as requested, including but not limited to reviewing and providing feedback on ETQ pricing, Buying Group promotions, and any other ad-hoc programming spend requested, and assess and communicate the impact to the Trade Budget/Forecast.
• Present Trade financials to Trade SLT each month during the monthly All Trade meeting.
• Keep leadership team in Finance informed of new or changing customer programs or incentives and financial impact.
• Analyze the Showroom Representative rewards programming by completing an IBNR and Spend Analysis, in addition to reviewing Showroom promotions that may impact results, and discussing in a monthly meeting.
• Complete and analyze the FEI inventory analysis report monthly.
• Support the Trade Commercial Tracker projects and Strategic Initiative through each phase; from discovery to review/approval, to identifying key metrics and measurements, to monitoring results.

Benefits

• Comprehensive benefit plans
• retirement
• savings
• tuition reimbursement
• employee incentive programs
• resources for mental, physical, and financial wellbeing
• LinkedIn Learning access
• internal opportunities to work on projects cross-company
• Four employee-led and self-directed Business Resource Groups
• Paid volunteer day annually
• Employees share their time, skills and talent with charities and nonprofit organizations across the U.S. and around the globe.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior