Required skills
- Talend
- Oracle SQL
- DB2 SQL
- ETL Development
- Data Warehousing
- SQL Query Optimization
- Technical Specification Writing
- Data Quality Management
Languages: French
Job description
Experienced BI Consultant needed for a leading insurance brokerage and risk management company to join a structured team for data platform maintenance, optimization, and evolution. The role involves ETL development, SQL optimization, Data Warehouse management, and platform enhancement.
Project overview
Context
As part of strengthening its decision-making department, a reference player in insurance brokerage and risk management — a major player in insurance brokerage (Top 10 in France — independent family group of over 1,600 employees) — is looking for an experienced BI consultant. You will join a structured team to support the maintenance, optimization, and evolution of a high-volume data platform.
Main Missions
Technical Environment
Working Conditions
- ETL Development: design, develop, and deploy data integration processes using Talend.
- Optimization & SQL: write and optimize complex SQL queries in a multi-database environment (Oracle / DB2).
- Data Warehouse Management: ensure the evolutionary and corrective maintenance of data warehouses.
- Quality & Performance: ensure the reliability of data flows, improve data quality, and optimize processing times.
- Design & Costing: write technical specifications and contribute to workload estimations (costing).
- Platform Evolution: actively participate in the transformation and continuous improvement projects of the BI foundation.
- ETL: Talend
- Databases & Languages: Oracle SQL (expert level required), DB2 SQL
- Operating Systems: IBMi (AS400), Windows, Unix
- Tools: SQL Developer, AI-assisted development tools (Claude, GitHub Copilot)
- Location: Mérignac (33) — Company Campus (on-site restaurant, gym, green spaces)
- Modalities: Hybrid — on-site presence required 3 days per week minimum
- Contract Type: Long-term assignment (Freelance / Payroll management)
- Start Date: As soon as possible
Project details
- Start: flexible
- Remote: hybrid
- Location: 33700 Mérignac, France, FR
- Languages: French
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on collective.work