Business Intelligence Specialist

Mission Overview:

We are seeking a skilled Business Intelligence Specialist for a consultancy mission at a client site, representing Keystone Solutions. The primary objective is to enhance the analytical capabilities of the client's platform by implementing business intelligence solutions.

Key Responsibilities:

• Connect to various data sources and retrieve useful data.
• Transform the retrieved data to meet the requirements of the destination database (filtering, merging, aggregation, format changes, etc.).
• Inject transformed data into a decision-making database.
• Utilize a BI tool to analyze data, produce reports, and create dashboards.
• Conduct meetings and brainstorming sessions to understand concepts and rationalize them.
• Analyze available sources and existing reports (Excel and SAP BO).
• Model the decision-making database (conceptual model/star model) integrating various data sources.
• Finalize a Proof of Concept (POC) using Power BI Desktop to extract, transform, and load data.
• Collaborate closely with stakeholders throughout the project.
• Document the work performed and develop loading procedures and consultation tools.

Requirements:

• Proven experience in Business Intelligence and data analysis.
• Strong understanding of data sources and database schemas.
• Ability to analyze and consolidate data needs.
• Experience in developing data warehouses and associated structures.
• Excellent communication skills in French, both oral and written.
• Strong strategic vision and critical thinking abilities.
• Ability to work autonomously and as part of a team.
• Proven problem-solving skills and a pragmatic approach to challenges.
• Ability to plan work effectively, considering deadlines and priorities.
• Resilience under stress.

Why Join Keystone Solutions:

• Consultancy Nature: Engage in on‑site work and embrace your consultant identity.
• Dynamic Projects: Tackle diverse challenges across various client environments.
• Turbo‑Charged Learning: Experience professional development and broad learning opportunities.
• Skyrocketing Ambition: Commit to your career growth within our framework.
• Values: As a

Duration:

01/11/2026 - 31/10/2027 12 months (part time 2/5)

Skills required:

• Base de données: Oracle ET MySQL/MariaDB ET SQL Server ET PostgreSQL
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Business Intelligence (BI)
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Capturer/formaliser la connaissance métier et la mettre en œuvre dans univers et rapports
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Créer des couches sémantiques et des rapports sur les bases de données
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Créer des datawarehouses sur les analyses réalisées et réalisation de la couche ETL
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Créer des tableaux de bord
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Développement et programmation: Python ET SAS ET SOAPUI - Level: T1 - Junior - Most recent: Any time
• Intégration et architecture de données
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time
• Outils Business Intelligence (BI): SQL Server Management Et SSIS Et PowerBI Et Azure
• (mandatory) - Level: T2 - Confirmed - Most recent: Any time

Language requirements:

• French
  (mandatory)
  Level Proficiency (C2)