Senior BI DEVELOPER
Your Day-to-Day
- Design, develop and maintain ETL processes using SQL Server Integration Services (SSIS).
- Develop and optimize SSIS packages for data extraction, transformation and loading.
- Implement incremental and full data loading mechanisms.
- Develop and maintain complex T-SQL stored procedures, views, functions and queries.
- Optimize SQL queries, execution plans and indexing strategies.
- Ensure data integrity, consistency and traceability across reporting environments.
- Implement data quality controls and reconciliation processes.
- Investigate and resolve data integration issues and production incidents.
- Monitor batch executions and identify performance bottlenecks.
- Improve error handling, logging and recovery mechanisms.
- Translate functional requirements into technical solutions.
- Integrate new data sources and adapt existing ETL processes.
- Participate in code reviews, technical discussions and continuous improvement.
- Collaborate with Business Analysts, Developers and upstream data provider teams.
Your Profile
- 7–12 years of experience as a Developer / BI Developer.
- Strong hands-on expertise in Microsoft SQL Server and T-SQL.
- Advanced expertise in SSIS, including package design, development, debugging and optimization.
- Strong understanding of ETL architecture, data integration patterns and batch processing.
- Experience with SQL Server performance optimization and troubleshooting.
- Strong knowledge of relational database design and data modelling.
- Experience with incremental loading, historical data management and data quality controls.
- Experience with Visual Studio / SQL Server Data Tools (SSDT).
- Good understanding of Azure SQL Database and SQL Server Agent / batch orchestration.
- Experience with Git / Azure DevOps and CI/CD practices.
- French: fluent/professional level required.
- English: professional level required.
- Experience in Asset Management / Investment Management is a strong advantage.
Technical Environment
Mandatory:
- Microsoft SQL Server
- SQL Server Integration Services (SSIS)
- T-SQL
- ETL / Data Integration
- Relational databases
- Visual Studio / SSDT
Good to have:
- Azure
- Azure SQL Database
- Azure Data Factory
- Git / Azure DevOps
- SQL Server Agent
- C# / .NET
- PowerShell
Job Category: Power BI Developper
Job Type: Consulting
Job Location: Paris