Required skills
- Microsoft Fabric
- Lakehouse
- Data Warehouse
- Data Factory
- OneLake
- Fabric Notebooks
- PySpark
- SQL Server
- T-SQL
- Python
- REST API
Languages: French
Job description
Our client is looking for a Data Engineer/BI Engineer to migrate their historical data warehouse from Microsoft SQL Server to Microsoft Fabric. The role involves redesigning data flows, ERP interfaces, and reporting, while also supporting the evolution of the Data Architecture towards the Cloud.
Project overview
Context
As part of the transformation of its decision-making platform, our client wishes to migrate its historical data warehouse based on Microsoft SQL Server to Microsoft Fabric. The consultant will join the Data team to participate in the redesign of data feeds, ERP interfaces, and decision-making reporting, while supporting the evolution of the Data Architecture towards the Cloud.
Main missions
Migration of the data warehouse to Microsoft Fabric
Development of Cegid XRP Ultimate ERP interfaces
Data Engineering Development
API Development
Reporting and Data Visualization
Business Relations
Technical environment
Data Platform
Development
Integration
Reporting
Methodologies
Profile sought
Technical skills
Expected qualities
Work environment
Skills priority🔴 Ultra important (disqualifying criteria)
🟠 Important
🟢 Appreciated
- Participate in the modernization of the SQL Server data warehouse to Microsoft Fabric.
- Design and implement data architectures in Lakehouse and Warehouse environments.
- Migrate and optimize existing processes to Fabric components.
- Ensure compliance of developments with architecture standards and Data governance best practices.
- Redesign ERP interfaces in their Cloud version.
- Develop data exchange flows with the ERP via Web Services and APIs exposed by Cegid XRP Ultimate.
- Ensure integration, testing, and security of data exchanges.
- Develop and maintain PySpark notebooks in Microsoft Fabric.
- Design efficient and industrialized data integration pipelines.
- Optimize transformation processes and loading performance.
- Participate in the automation of processes and their supervision.
- Design and maintain REST APIs in Python.
- Ensure data availability to subsidiaries and consuming applications.
- Participate in the security and documentation of exposed services.
- Produce and maintain Power BI dashboards.
- Participate in the evolution of existing SSRS reports.
- Ensure the quality, consistency, and performance of reporting.
- Participate in requirements gathering workshops.
- Analyze functional needs and propose suitable technical solutions.
- Participate in progress meetings and service monitoring instances.
- Write technical and functional documentation.
- Microsoft Fabric
- Lakehouse
- Data Warehouse
- Data Factory
- OneLake
- Python
- PySpark
- SQL Server
- T-SQL
- REST API
- JSON
- Web Services
- Cegid XRP Ultimate
- Power BI
- SQL Server Reporting Services (SSRS)
- Agile / Scrum
- Git
- Azure DevOps
- Minimum 5 years in Data Engineering, BI, or data integration.
- Significant experience with Microsoft Data Platform environments.
- Experience migrating to Microsoft Fabric is a major asset.
- Excellent command of SQL Server and SQL.
- Good command of Python.
- Experience in PySpark development.
- Knowledge of Data Lake and Data Warehouse architectures.
- Experience in REST API design.
- Mastery of Power BI.
- SSRS knowledge appreciated.
- Knowledge of Cegid XRP Ultimate strongly appreciated.
- Autonomy.
- Analytical and synthesis skills.
- Ability to work with business and technical stakeholders.
- Proactive.
- Rigor in documentation and quality of developments.
- Warehouse
- Fabric Notebooks
- Notebook development
- Data transformations
- Spark processing optimization
- Advanced T-SQL
- Stored procedures
- Business modeling
- SQL Server data warehouse migration
- Data integration
- Data Warehouse / Data Lake architecture
- Cloud Data Platform migration
- SSRS (SQL Server Reporting Services)
Project details
- Start: ASAP
- Duration: 1 an renouvelable
- Remote: hybrid
- Location: La Défense, Île-de-France, FR
- Languages: French
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on free-work.com