Start searching
Back to Jobs
Recently postedFull timeTechnology

Senior BI DEVELOPER - Advisory Key

Advisory KeyParis🇫🇷France

Quick overview

SeniorityMid Senior
Employment typeFull Time
Work modeHybrid
LocationParis, France
SQLT-SQLGitETLC#.NETPowerShellAzureSQL ServerCI/CDAzure DevOpsAzure Data FactoryVisual Studio

Job description

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

Similar jobs

Apply