Sr. Financial Analyst; Data Analytics

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.

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

• 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.

• 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, Cap Ex Reporting.
• Develop new consolidation and reporting, forecasting, and budget process using One Stream, the new consolidations and reporting software being rolled out by Arkema Group.
• Become subject matter expert in current ERP system (SAP-PRD) in anticipation of implementation of new ERP (SAP-Ambition); represent the Coating Solutions Segment during the implementation of the new ERP system.
• Develop automation tools leveraging PowerBI.
• Explore wDesk with Colombes FP&A to push for automation in Coating Solution Reporting.
• Learn and implement
  - Upstream and downstream integrated sales and margin in PowerBI Group managed tool.
• Develop onboarding FP&A training material for new employees.
• Develop new reports on credit and collection utilizing Group new tool
  - Highradius Credit Cloud application.
• Automate and Optimize - FP&A existing reporting & analysis tools leveraging advance Excel, Power Query, Access, and PowerBI.
• Search and analyze large batches of data in Sales and Margin BI to identify trends and patterns. Extract useful information from data. Develop and implement financial models and…