Sr. Financial Analyst (Data Analytics) Job

Based in Cary, NC.

 

Position reports directly to the Finance Manager, Coating Resins.  Works closely with VP Finance Coating Solutions; Monomer FP&A and business team, Coating Resins FP&A and Business team, Sartomer business FP&A and business team, and RSA FP&A and Business team. BU global presidents, Coating Solutions Marketing team, Coating Solutions R&D team, and Colombes Headquarter Finance team. No direct reports.

 

JOB DIMENSIONS

The Sr. Financial Analyst works across various parts of the Global Coating Solutions organization interfacing with people at all levels of the organization, up to and including the Senior Vice President, Coating Solutions, COMEX member. The majority of the work must be accomplished with influence skills. Weekly and monthly financial analysis with quick and efficient communication of results. Consolidation and analysis of monthly forecasts of full P&L (sales, margin, operating income) and key financial business indicators monthly and quarterly. Consolidation and analysis of output for budget and 5-year plans with necessary reconciliation analyses. Data mining and development and implementation of automated solutions to improve Finance processes and outputs. Ad hoc analysis requests as needed.

 

Scope of revenues and sites:

• Countries of support: Americas, EME, NE Asia, SE Asia.
• Manufacturing sites – 31  

 

KEY ACTIVITIES AND RESPONSIBILITIES

Reporting and Analysis (60%) – Scope: Global

• Conduct RPE per unit / productivity benchmarking across segment.
• Provide big Capital Project FP&A support.
• Collection and validation of data.
• Develop and prepare monthly reporting metrics for Coating Solutions Segment, including dashboards and analysis reports. Ensure that results accurately reflect operational activity. 
• Prepare the monthly Coating Solutions COMEX deck.
• Coordinate and optimize the process for collecting and presenting key financial and business indicators for monthly reporting and analysis, including the monthly preparation of the Coating Solution forecast and RCG Deck.
• Provide financial leadership to businesses; develop financial training as necessary for each aspect of the business.
• Lead effort to improve business processes, to allow for more value-added analysis versus reporting.
• Influence and Improve business decisions by providing financial analysis and new tools and techniques.
• Develop new automated tools to optimize reporting process, leverage One Stream, Power BI, etc.
• Liaison with cross BU businesses, functional and FP&A leaders to conduct financial analysis, identify area of variable cost or fixed cost improvement opportunity.
• Analyze data on working capital - AR and AP, payment terms as an example to drive AR ratio improvement.
• Ad hoc analysis when requested from VP Finance Coating Solutions.
• Prepare Coating Solutions integrated P&L monthly, quarterly, budget and 5-year plan.
• Delivered quality reporting and analysis in term of accuracy, on time and completeness.
• Delivered OPEX Coating Solutions reporting and deck - determine the drivers and report out in the form of presentation deck.

 

Data Mining and Automation (40%) – Scope: Global

• Business partner supporting new Coating Solutions Commercial, Marketing, and R&D organization.
• Data mining Coating Solutions cross BU Sales and Margin, isolate key raw materials that is common across BU and evaluate opportunity to source better leveraging our footprints across the world and size of purchases.
• Data mining Coating Solutions Mega trend.
• Collect data on Coating Solutions key competitors and key customers – 10K and 10Q and internal / external publication providing insights on competitive landscape and their financial performances.
• Develop new KPI reporting and analysis to support new organization of Coating Solutions Segment.
• Improve process efficiency: Standardize ways of working – RCG, budget, forecast, KPI, NBD, Operational Excellence, CapEx Reporting.
• Develop new consolidation and reporting, forecasting, and budget process using OneStream, the new consolidations and repo