Expert Microsoft BI – SQL Server / SSIS / Oracle / Power BI @ Real Estate

Project overview

Levallois-Perret (92)

7 to 10 years of experience

BI / Studies Expert

Context and challenges of the mission

As part of the evolution of its decision-making information system, a major player in the insurance sector is looking for a Microsoft Business Intelligence Expert to support the design, development, and optimization of BI solutions dedicated to real estate management steering.

These decision-making solutions must allow for the supervision of real estate activities, both strategically and operationally, while facilitating communication, information sharing, and collaboration with the various business units.

The environment relies on Microsoft BI technologies, particularly Power BI, SQL Server, and SSIS, as well as Oracle databases.

The objective is to guarantee the reliability, consistency, and accessibility of data and steering indicators, while exploiting the online collaboration possibilities offered by Power BI.

Detailed missions

Technical Stack

Technology

Expected Skills

Power BI

Design, development, deployment, and sharing of decision-making dashboards

SQL Server

Data exploitation and Microsoft decision-making environment

SSIS

Data integration and understanding of flows and processes

Oracle

Data exploitation and analysis

Data Warehouse

Analysis, design, and understanding of data models

Business Intelligence

Decision-making solutions, reporting, indicators, and business rules

• Analysis and understanding of the existing decision-making system
• Analyze the existing BI architecture, in terms of both functional and technical aspects.
• Understand the data models, data loading flows, and existing processes.
• Identify and analyze steering indicators and associated business rules.
• Grasp the specificities of data related to real estate management.
• Detect any discrepancies, inconsistencies, or limitations of existing solutions.
• Design and development of BI solutions
• Participate in the analysis and design of Data Warehouses.
• Translate business needs into suitable, reliable, and easily usable decision-making solutions.
• Design, develop, and deploy Business Intelligence solutions.
• Utilize SQL Server, Oracle, and SSIS environments for data processing and integration.
• Contribute to the design and development of Power BI dashboards.
• Ensure the consistency of data, indicators, and business rules within the proposed solutions.
• Reporting and steering of real estate activities
• Support the implementation of dashboards for strategic and operational monitoring of real estate management.
• Facilitate access to decision-making information for the various business units.
• Utilize Power BI's online sharing and collaboration features.
• Ensure the relevance, reliability, and clarity of the indicators provided to users.
• Collaboration with business and technical teams
• Collect, analyze, structure, and qualify the needs of business teams.
• Act as the interface between functional and technical stakeholders.
• Identify discrepancies between expressed needs and existing solutions.
• Propose relevant BI solutions adapted to usage.
• Ensure regular communication and quality reporting on the work carried out.
• Work with a high level of autonomy, analysis, and synthesis.

Project details

• Start: flexible
• Remote: hybrid
• Location: 92300 Levallois-Perret, France, FR
• Rate: 78-78 EUR/h
• Languages: French