Shire Jobs

Reference #: F9D1A148-12E5-4 Division: Coating Solutions Location: Cary, NC; Exton, PA; King of Prussia, PA

SITUATION IN ORGANIZATION 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 (50%) - 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 (50%) - 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, for cast, KPI, NBD, Operational Excellence, CapEx Reporting. Develop new consolidation and reporting, forecasting, and budget process using OneStream, 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 dashboards for management.

CONTEXT AND ENVIRONMENT The Sr. Financial Analyst must be objective at all times and is in a unique position to identify any financial issues that may not be consistent with Segment goals and / or that are not consistent with Financial Policy. The Sr. Financial Analyst is expected to bring this to the attention of the Finance Manager and help lead efforts to fix the situation and prevent re-occurrences. The Sr. Financial Analyst works directly with multiple levels in the organization as well as across multiple business units. The job requires that the Analyst be flexible and able to negotiate priorities. Many components of this job are time critical, particularly during the first 8-10 business days of the month to meet all reporting needs. Special project requests occur routinely that impact how the Business is run and must be carried out with complete neutrality and with sufficient detail to ensure the best decision for the company. Up to 5% travel may be required.

REQUIRED EDUCATION / QUALIFICATIONS / WORK EXPERIENCE BA / BS Degree in Finance, Data Analytics, Mathematics / Statistics or IT field; MBA a plus. Seven or more years' finance / data management experience required. Expert in Microsoft Office Suite: Excel, Power Query, Access, PowerPoint. Expert in PowerBI. Strong analytical skills with ability to develop and maintain extensive and complex spreadsheets. SAP experience preferred. Structured approach to analysis methodology to ensure consistency of information. Team player, with ability to pull together necessary resources and resolve systematic problems. Experience documenting work processes to ensure consistency and repeatability of analyses and resulting output.

DEMONSTRATED COMPETENCIES Shows accountability in managing self and partnering with others to drive towards team goals. Shows capability and experience to mentor others in / outside of projects. Demonstrates ability to lead by influence. Structured approach to analysis methodology to ensure consistency of information. Data driven and technology oriented. Attention to detail and accuracy. Ability to operate with strict deadlines. Demonstrated competency for prioritizing and balancing demands from multiple stakeholders. Arkema Inc. is a Chemical company and as such, all employees are expected