Geforderte Skills
- Data Modeling
- OLAP
- Data Integration
- Financial KPI Design
- Data Architecture
- ERP Systems
- SAP
- Microsoft Dynamics 365
- Oracle
- MDM
- Business Intelligence
- Financial Reporting
Sprachen: French
Jobbeschreibung
The client, a major European B2B telecommunications provider, is seeking a Principal Finance Data Architect to lead the development and evolution of a financial DataCube (OLAP). This role involves critically evaluating the current DataCube, defining its future architecture, and ensuring its alignment with the CFO's strategic data initiatives.
Project overview
Client Context
Our client is a major European player in B2B telecommunications services, with a presence in Europe, Asia, and the Americas, generating nearly one billion euros in revenue. The Group operates through numerous legal entities that rely on multiple ERPs and heterogeneous information systems, making the production of consolidated and homogeneous financial information particularly complex.
In this context, the Group's Finance Department has launched a strategic program to establish a Golden Source of financial data. This program aims to harmonize repositories, ensure the reliability of data from different entities, and guarantee a unique, coherent, and reconciled view of financial information. Its implementation has been entrusted to a leading consulting firm (Big 4), acting as the integrator.
Mission Context
In parallel with the integrator's work, a financial DataCube (OLAP) exclusively for the CFO's office is under development. This DataCube will eventually leverage the Golden Source implemented by the integrator to enable multidimensional analysis of the Group's performance and provide the Finance Department with advanced financial data exploration capabilities.
The financial DataCube is being developed concurrently with the Golden Source program, without its initial production being dependent on the latter's completion. It initially relies on available financial data and repositories, particularly for products, customers, and sites, as well as on transitional reconciliation and mapping mechanisms. The architecture must allow for the progressive integration of harmonized repositories and data from the Golden Source as they become available and validated.
The consultant will therefore need to secure both the short-term functioning of the DataCube and the coherence of its evolution path.
An initial production of the DataCube is planned for December 2026, with reservations; its completeness, robustness, and compliance with the Finance Department's expectations remain to be assessed. The mission will precisely consist of carrying out this critical evaluation, identifying the remaining work, defining the conditions for continuing the program, and then ensuring the technical and functional leadership of the DataCube until its completion.
The consultant will be responsible for defining and implementing the analytical model: dimensions, hierarchies, measures, KPIs, aggregation rules, drill-down capabilities, calculations, and analysis axes, in direct alignment with the needs expressed by the Finance Department.
This next phase places central importance on dialogue with the integrator and involves close and continuous interaction with its teams, to ensure that the Golden Source progressively provides the data necessary for the DataCube's evolution and to represent the CFO's interests vis-à-vis the integrator, by constructively challenging modeling or integration choices that could limit the analytical capabilities expected by the CFO's office and by obtaining necessary decisions.
Mission Objectives
The mission pursues the following objectives:
Mission Scope, Consultant's Responsibility, and Expected Deliverables
Mission Scope
The consultant will act as the technical and functional project leader, by delegation from the Finance Program Manager and under the sponsorship of the CFO, to secure the takeover, consolidation, and evolution of the Finance DataCube. As such, they will be involved in:
Consultant's Responsibility
The consultant will act as the reference architect for the Finance Department, in direct liaison with the Finance Program Manager and under the CFO's sponsorship. They must become a true partner for reflection and decision-making for this manager, who can delegate the technical and functional leadership of the DataCube with full confidence in their judgment and ability to bring the project to fruition. They must also have the necessary seniority to engage in dialogue as equals with the integrator's management team. In this capacity, they will bear the following responsibilities:
This role is not primarily an administrative PMO function, nor is it exclusively focused on data governance. However, it includes an essential dimension of leadership, coordination, and operational management of the DataCube. The consultant must be able to define its technical and functional directions, structure the work, coordinate contributions from different teams, and drive decisions to effective implementation.
Their added value will be based on the trust the Finance Program Manager can place in them: the ability to exercise independent judgment on structuring choices, to personally design the analytical model, and to drive decisions without close supervision. They must therefore combine the operational expertise of a high-level architect with the leadership capacity needed to bring the project to fruition.
Expected Deliverables
The deliverables follow the logic of program takeover. The first two frame the start of the mission; the schedule for the subsequent ones will be agreed upon after reviewing the existing situation and formalized in the work plan. Expected deliverables include:
- Critically take over the ongoing program: evaluate the first version of the DataCube, scheduled for delivery at the end of 2026, and enable the Finance Department to decide what is usable, what needs correction, and what remains to be built;
- Ensure, by delegation from the Finance Program Manager, the technical and functional leadership of the CFO's office financial DataCube, to consolidate it, evolve it, and enable multidimensional analysis of the Group's performance (company, Business Unit, cost center, account, period, currency, customer, product);
- Secure the DataCube's data feed from available data and repositories, while preparing for the progressive integration of the Golden Source;
- Secure the design of the system by exercising, on behalf of the CFO, design authority over the integrator's architecture, modeling, and delivery choices;
- Prepare and drive the CFO's and CTO's decisions through objective recommendations on costs, timelines, data quality, and business value.
- Taking over the ongoing work, as part of a handover that can begin before December 31, 2026, and conducting a critical review of the first version of the DataCube (model, data, calculation rules, performance);
- Taking over, correcting if necessary, and evolving the target analytical model (DataCube) for the Finance Department: dimensions, hierarchies, measures, aggregation rules, granularity, KPIs, and drill-down capabilities;
- Understanding the CFO's steering needs and translating them into a robust, scalable, and usable data model;
- Analyzing the existing situation (Informatica, Databricks, data models, repositories, data feeds) and recommending the most relevant path: continuation, adaptation, or redesign of the solution;
- Designing the rules for integrating and harmonizing data from a multi-ERP environment (Microsoft Dynamics 365, SAP, Oracle, business ERPs) to ensure a coherent and consolidated financial view;
- Defining the principles for modeling repositories (MDM / Golden Source) when they directly contribute to the quality and coherence of the DataCube;
- Sourcing and understanding data in source systems when necessary, to validate business rules, mappings, and the coherence of transformations;
- Designing financial steering indicators in close collaboration with the Finance Department: Group reporting, management control, consolidation, performance analyses, and executive KPIs.
- Personally assume intellectual responsibility for the analytical model, its coherence, and the recommendations submitted to the CFO;
- Independently evaluate the program's organization and work methods, identify obstacles to its progress, and propose necessary adjustments in terms of governance, responsibilities, prioritization, and coordination with internal teams and the integrator;
- Play a driving role in managing the DataCube: define directions, propose priorities and implementation sequences, clarify everyone's responsibilities, and drive decisions to effective implementation;
- Constructively challenge the architecture, modeling, and delivery choices proposed by the integrator, on both technical and functional aspects, maintaining an argued position until a decision is made;
- Lead architecture and modeling workshops with Data, Finance, and integrator teams, even when discussions are difficult, bringing real design expertise and not just a coordination role;
- Produce, defend, and drive the technical and functional recommendations necessary for the CFO's and CTO's decisions, by objectifying the impacts on costs, timelines, data quality, and business value;
- Actively contribute to program governance and ensure technical and functional leadership of the DataCube, coordinating the relevant work of the Finance, IT, and integrator teams, under the CFO's sponsorship and in collaboration with the Finance Program Manager.
- Technical and functional diagnosis of the existing situation, delivered within the first two weeks of the mission: analysis of work already completed, identification of shortcomings and decisions still to be made, qualification of what is usable, what needs correction, and what remains to be built, and recommendation of a path (continuation, adaptation, or redesign of the solution);
- Work plan, validated with the CFO and CTO after the diagnosis: technical priorities, dependencies with the integrator, validation steps, and milestones;
- Operational roadmap for the first quarter of 2027: identification and prioritization of reservations from the initial production, securing revenue analyses, progressive improvement of cost and margin analyses, extension of scope to new entities, and preparation for the integration of harmonized repositories, according to priorities confirmed by the Finance Department;
- Target analytical architecture, formalized in the DataCube modeling documentation and the financial steering indicator repository: dimensions, facts, hierarchies, measures, calculation rules, and granularity;
- Gap analysis with the Golden Source: data or transformations needed for the Golden Source to progressively feed the DataCube, including integration, harmonization, and mapping rules for data from the Group's various ERPs;
- Recommendation and arbitration notes for the CFO and CTO, presenting for each decision the alternatives, their advantages, risks, and impacts;
- Consolidated and enriched financial DataCube, fed by available sources and repositories, designed to progressively integrate data from the Golden Source and made available to the CFO's office;
- Validation
Project details
- Start: flexible
- Remote: onsite
- Location: Paris, France, FR
- Languages: French
Indexiert von der 9am-Meta-Suche. Du bist Job-Anbieter? Listing beanspruchen oder verwalten
Gefunden auf collective.work