Senior BI DEVELOPER
Il y a 2 jours
Paris, Île-de-France
Advisory Key
Temps plein
Gratuit avec email ou Google
Enregistrez cette offre et organisez votre recherche
Créez un compte gratuit pour enregistrer des offres d'emploi, créer des alertes et revenir à cette liste depuis votre tableau de bord.
Gratuit avec email ou Google
En continuant, vous acceptez nos Conditions d’utilisation & Politique de confidentialité.
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