Crystal Functional analystLocation:Department:Reports To: Head of ApplicationsFUNCTION CONTEXTPOSITIONINGPositionCrystal Functional analystSupervisory role - NoPURPOSE OF THE ROLEWithin IT Flat Europe organization, the Digital & IT Finance and Procurement perimeter i responsible for the IT Strategy of the Finance and Procurement functions, including efficiency, process and system exploitation and optimization.The Crystal Functional analyst will join an IT department focused on the differentiated cost calculation for Flat steel business. These figures are crucial for monthly cost reporting, calculation of sales margins, the ArcelorMittal Operating Statement and benchmarking costs across different Flat plants. Furthermore this data serves as an input for the CMO dynamic price calculation (NINA).The stakeholders of this application are local and central Finance department, Commercial department and Supply chain teams.The Crystal functional analyst acts as a liaison between business users and the IT team, translating business needs into detailed functional specifications for software and IT systems. They are responsible for defining how a system should work to meet business goals, which includes gathering requirements, designing user stories, assisting with testing, and ensuring the final product aligns with business needs. This role often requires strong communication, business knowledge, and analytical skills. Responsibilities includes :Ownership of data consistency during closing process from a business / accounting perspectiveEnsure data accuracy and reconciliation / mapping to sources or other systems / financialsMaintain Crystal business guide procedureEnsure allocation rules compliance across clusters / application of PMP procedureAct as subject matter expert on Business logic / allocation rules / measures etcSupport business users with queries / reports and insights on the tool functionalityKEY RESPONSIBILITIESTechnical and Process UnderstandingAs you will have to report the cost over the different production steps, it is important to understand the different steps in the steel-producing processes, being familiar with technical material specifications in the ArcelorMittal Flat product range.Data Translation and Financial IntegrationTranslate manufacturing and technical data of the orders and production process, coming from different data sources structured in templates, into financial and accounting data.Cost Allocation and Rule ManagementImplement, update, and maintain multiple cost allocation and differentiation rules expressed in formulas, coefficients, and decision tables.Support and Issue ResolutionOffer continuous support and solve calculation issues.Reporting and InsightsDesign ad-hoc requested business reports in SAP BI using SAC (SAP Analytical Cloud).Present and provide insights into the cost differentiation figures on a monthly basis to the Board of Managers (Chief Financial Officer & Chief Marketing Officer).Technology and Tools ManagementWork with MS SQL Server as the database and calculation engine.Use a user front-end application in HTML5/Angular and backend in C#.Leverage SAP BI data warehouse and SAC dashboard reporting tools for reporting.COMPETENCIESMUST HAVE BEHAVIORAL COMPETENCIESStakeholder orientationAdvancedResults orientationAdvancedCourage to challengeAdvancedInspire trustProficientLearning and developmentProficientTeamworkProficientNICE TO HAVE BEHAVIORAL COMPETENCIESStrategic thinkingIntermediateInnovationIntermediateChange managementIntermediateDecision makingIntermediateREQUIRED TECHNICAL COMPETENCIESExperience with SAP BI/SACDetailed knowledge of steel production steps is a must, or eagger to learn rapidlyFluent knowledge of EnglishBeing stress resilient to deal with monthly strict reporting deadlinesBeing a team player to build good contracts with all plants in scopeCommunicate clearly and convinced to Board of ManagersProject Management skills: Ability to drive Crystal harmonization across clustersREQUIREMENTSDegreeBachelor’s / Master’s degree in Industrial engineerExperience6–8 years of total professional experience in a relevant field, such as manufacturing, cost accounting, financial analysis, or business intelligence
Job Title
Crystal Functional analyst