Crystal Functional analyst

Crystal Functional analyst

Location:

Department:

Reports To: Head of Applications

1. FUNCTION CONTEXT
2. POSITIONING

Position

Crystal Functional analyst

Supervisory role - No

1. PURPOSE OF THE ROLE

Within 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 perspective
• Ensure data accuracy and reconciliation / mapping to sources or other systems / financials
• Maintain Crystal business guide procedure
• Ensure allocation rules compliance across clusters / application of PMP procedure
• Act as subject matter expert on Business logic / allocation rules / measures etc
• Support business users with queries / reports and insights on the tool functionality

1. KEY RESPONSIBILITIES

Technical and Process Understanding

As 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 Integration

Translate 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 Management

Implement, update, and maintain multiple cost allocation and differentiation rules expressed in formulas, coefficients, and decision tables.

Support and Issue Resolution

Offer continuous support and solve calculation issues.

Reporting and Insights

Design 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 Management

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

1. COMPETENCIES
2. MUST HAVE BEHAVIORAL COMPETENCIES

Stakeholder orientation

• Advanced

Results orientation

• Advanced

Courage to challenge

• Advanced

Inspire trust

• Proficient

Learning and development

• Proficient

Teamwork

• Proficient

1. NICE TO HAVE BEHAVIORAL COMPETENCIES

Strategic thinking

• Intermediate

Innovation

• Intermediate

Change management

• Intermediate

Decision making

Intermediate

1. REQUIRED TECHNICAL COMPETENCIES

• Experience with SAP BI/SAC
• Detailed knowledge of steel production steps is a must, or eagger to learn rapidly
• Fluent knowledge of English
• Being stress resilient to deal with monthly strict reporting deadlines
• Being a team player to build good contracts with all plants in scope
• Communicate clearly and convinced to Board of Managers
• Project Management skills: Ability to drive Crystal harmonization across clusters

1. REQUIREMENTS

Degree

Bachelors / Masters degree in Industrial engineer

Experience

68 years of total professional experience in a relevant field, such as manufacturing, cost accounting, financial analysis, or business intelligence