Data Analyst (m/f/d) - Freelancer/B2B

EIT RawMaterials; Berlin; Vor Ort; EUR 60.000 - 90.000; Vollzeit

Zusammenfassung

EIT RawMaterials is seeking a Technical Senior Data Analyst to support the M2i Platform and related BI activities. You will transform raw materials data, develop dashboards with Power BI, and contribute to data integration and quality assurance.

The role focuses on delivering reliable, actionable insights for strategic decision making across commodities and value chains, while ensuring scalable analytics and clear documentation for handover.

Qualifikationen

• Senior data analyst with hands-on experience in Power BI.
• Experience with data modelling and data integration.
• Ability to deliver reliable dashboards for decision making.

Aufgaben

• Provide Technical Senior Data Analyst support for the M2i Platform and BI activities.
• Structure, transform and document raw materials market intelligence data.
• Develop and optimise Power BI dashboards and data models.
• Ensure data quality, validation and timely delivery of insights.

Kenntnisse

Power BI

Data analysis

Microsoft Fabric

Data modelling

Tools

Power BI

Microsoft Fabric

Jobbeschreibung

Overview Of EIT RawMaterials

EIT RawMaterials is a ‘Knowledge and Innovation Communities’ (KICs) created by the European Institute of Innovation and Technology (EIT), aimed at promoting innovation in the raw materials sector across Europe. Established in 2015, EIT RawMaterials works to secure the sustainable supply of raw materials to the European industry by driving innovation, education, and entrepreneurship along the entire raw materials value chain.

Overview Of EIT RawMaterials

EIT RawMaterials is a ‘Knowledge and Innovation Communities’ (KICs) created by the European Institute of Innovation and Technology (EIT), aimed at promoting innovation in the raw materials sector across Europe. Established in 2015, EIT RawMaterials works to secure the sustainable supply of raw materials to the European industry by driving innovation, education, and entrepreneurship along the entire raw materials value chain.

Overview Of EIT RawMaterials

EIT RawMaterials is a ‘Knowledge and Innovation Communities’ (KICs) created by the European Institute of Innovation and Technology (EIT), aimed at promoting innovation in the raw materials sector across Europe. Established in 2015, EIT RawMaterials works to secure the sustainable supply of raw materials to the European industry by driving innovation, education, and entrepreneurship along the entire raw materials value chain.
We are a knowledge-driven business and a catalyst for industrial progress. Our offerings leverage our expertise and that of our network – the world's largest network in the raw [and advanced] materials sector – which includes companies at every stage of evolution, from start-ups to market leaders, along with leading international universities, research organisations, and top experts and future talent from the sector.
Our activities span from mining and mineral processing to material recycling and substitution, focusing on increasing resource efficiency and fostering a circular economy.
We inform policy, apply knowledge, accelerate innovation, create opportunity, and unlock commercial value – for our partners and customers throughout the raw materials value chain to develop the raw materials sector as a strategic strength and foundation for a secure, sustainable future for Europe.
Our offerings are designed to help our partners and industry to be part of Europe’s strategic agenda to ensure supply chain security and make the ‘Green New Deal’ a reality that benefits the people of Europe and partner nations.

Scope of Work

The M2i Platform is EIT RawMaterials’ strategic Metals and Minerals Intelligence Platform, designed to consolidate, structure and visualise raw materials market intelligence in a technically robust business intelligence environment. It brings together data on commodities, value chains, technologies, projects, market trends, supply risks and strategic opportunities, and transforms this information into reliable dashboards, reports and analytical outputs. By combining raw materials expertise with Power BI-based visualisation, data modelling and integration across relevant internal and external sources, the platform supports evidence-based analysis and the monitoring of strategic priorities across the raw materials sector.

Detailed Scope of Work

The Contractor shall provide Technical Senior Data Analyst support for the M2i Platform and related Business Intelligence activities, ensuring that raw materials data is converted into reliable, maintainable and actionable analytical outputs. The Contractor will structure, transform, validate and document raw materials market intelligence data, develop and optimise Power BI dashboards, and contribute to data integration, quality assurance and technical delivery. The assignment will combine advanced Power BI expertise, data modelling, data transformation, analytical dataset design and raw materials market intelligence to ensure that the M2i Platform delivers accurate, maintainable and actionable insights on commodities, value chains, market trends, projects, supply risks and strategic opportunities.

• Scope of Work


• Provide Technical Senior Data Analyst support for the M2i Platform and related Business Intelligence activities, ensuring that raw materials data is converted into reliable, maintainable and actionable analytical outputs.


• Cover the full analytical data lifecycle required for the platform, from understanding source data and analytical needs through to data modelling, validation, reporting support and technical handover.


• Support the technical evolution of the platform so that dashboards, datasets and analytical outputs remain scalable, consistent and fit for decision-making across commodities, value chains, projects, supply risks and strategic opportunities.


• Technical Activities


• Analyse source data, reporting requirements and market intelligence use cases in order to define appropriate datasets, semantic models, indicators, measures and dashboard logic.


• Configure, test and optimise Power BI and Microsoft Fabric components, including data transformations, semantic models, calculations, reports, refresh processes and performance improvements.


• Perform technical checks on analytical outputs, including data consistency, reconciliation, refresh reliability, usability and maintainability before outputs are accepted as deliverables.


• Data Integration, Documentation and Handover


• Maintain coherent integration between source systems, Microsoft 365, Power BI, Microsoft Fabric and other relevant data environments, ensuring that technical dependencies are identified and managed.


• Maintain concise technical documentation covering source data, assumptions, transformation logic, data model design, quality checks, dashboard configuration and known limitations.


• Prepare handover material needed for continuity, maintenance and future development, without duplicating the deliverable-specific documentation listed below.


• Deliverables

• Platform Architecture, Data Model and Backend Improvements


• Implemented and documented improvements to the platform backend, lakehouse architecture or data model, including optimised layers, revised Gold layer structures or dedicated fact tables for key business domains such as trade, production, commodities or comparable datasets.


• Data Integration, Source Expansion and Quality Assurance


• Integrated and validated internal or external data sources, with evidence of ingestion, transformation, reconciliation and data quality checks supporting reliable analytical use.


• Microsoft Fabric and Power BI Optimisation


• Implemented migration of selected calculations, business logic or data transformations from Power BI into Microsoft Fabric where appropriate, with simplified report logic and documented impact on maintainability or performance.


• Optimised Fabric pipelines, semantic models, Power BI datasets, embedded reports, refresh processes or processing efficiency, supported by testing evidence or performance comparison where relevant.


• Security, Access Management and Platform Usage Monitoring


• Design and implement the required multi-tenant architecture to support separation of internal and external environments, including secure authentication, access management and simplified administration.


• Design and implement a solution for capturing user metrics and monitoring platform usage across the web platform.


• Data Governance, Standardisation and Documentation


• Documented governance, standardisation or quality-control improvements, including master data conventions, deployment checks, technical documentation updates or lakehouse maintainability measures.


• Platform Expansion and Future Releases


• Prepare the platform for future releases by onboarding additional commodities, sectors, dashboards, datasets and analytical capabilities.

The engagement shall begin immediately after contract signature. It shall end automatically after two years. EIT RawMaterials shall be entitled to terminate the contract with three months prior notice in the event it is not satisfied with the Contractor’s performance. The right to terminate for cause shall remain unaffected.

The overall hours of work is indicatively estimated to be a maximum of 2.000 person hours over the entire contract term.

The work of the Contractor for EIT RawMaterials shall, in average on an annual basis, not exceed 75% of the total working hours of the Contractor for all its customers, and the Contractor represents and warrants that the Contractor will use at least 25% of his working time for other customers.

Workload could vary depending on the monthly planning which shall be estimated and reasonably agreed between the parties in advance per month. The Contractor shall inform EIT RawMaterials of any reasonably expected deviations as soon as possible.

The provider is not entitled to a specific amount of person hours under this contract. The specific amount shall be subject to monthly planningand decision by EIT RawMaterials.

We need a contractor to support the Innovation Team in developing the M2i Platform over the next couple of years.