SQL Server SSIS Developer

Project overview

The consultant will be responsible for designing, developing, maintaining, and optimizing data integration processes and SQL-based solutions that feed client reporting applications and platforms.

The position requires solid operational expertise in Microsoft SQL Server, T-SQL, and SQL Server Integration Services (SSIS), with a particular focus on data reliability, processing performance, and solution maintainability.

The consultant will work closely with the IT team responsible for client reporting, business analysts, and other IT teams.

Main Tasks and Responsibilities

ETL Development and Data Integration

SQL Server Development and Optimization

Data Quality and Production Support

Functional Evolution and Collaboration

Candidate Profile

Required Technical Skills

Work Environment

Development Environment and Tools

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS).
• Develop and evolve SSIS packages for extracting, transforming, and loading data from multiple source systems.
• Implement incremental and full load mechanisms.
• Manage data dependencies, execution sequences, error handling, and recovery processes.
• Improve the performance, reliability, and maintainability of ETL processes.
• Implement monitoring, logging, and control mechanisms for data integration processes.
• Design, develop, and maintain stored procedures, views, functions, and complex T-SQL queries.
• Develop and optimize data transformation and integration logic.
• Contribute to the design and evolution of SQL Server data structures.
• Analyze and optimize SQL query performance, execution plans, and indexing strategies.
• Implement efficient data loading, historization management, and reconciliation mechanisms.
• Ensure data integrity, consistency, and traceability within the reporting environment.
• Implement data quality controls and reconciliation processes.
• Analyze and resolve issues related to data integration and production incidents.
• Monitor the daily execution of batch processes and identify bottlenecks or slowdowns.
• Improve error handling, logging, and restart capabilities for processes.
• Participate in testing, validation, and production deployments.
• Maintain technical documentation and development standards.
• Translate functional requirements into technical specifications and development solutions.
• Contribute to the evolution of existing data processing solutions for client reporting.
• Integrate new data sources and adapt existing ETL processes to evolving business needs.
• Collaborate with business analysts, developers, and teams responsible for source data systems.
• Participate in code reviews, technical exchanges, and continuous improvement initiatives.
• Microsoft SQL Server and ETL: mandatory skills.
• SQL Server Integration Services (SSIS): advanced expertise in designing, developing, debugging, and optimizing packages.
• SQL Server / T-SQL: solid expertise in stored procedures, complex queries, functions, and performance optimization.
• Excellent understanding of ETL architecture, data integration patterns, and batch processing.
• Experience with incremental loads, data history management, and data quality controls.
• Experience in performance tuning and diagnosing SQL Server issues.
• Good command of relational database design and data modeling.
• Visual Studio / SQL Server Data Tools (SSDT).
• Git / Azure DevOps: source code management and CI/CD practices.
• Azure SQL Database: good understanding.
• SQL Server Agent and batch process orchestration: good understanding.
• C# / .NET: appreciated.
• Azure Data Factory: appreciated.
• PowerShell: appreciated.
• Experience in Asset Management or Investment Management is a significant advantage.

Project details

• Start: ASAP
• Duration: 1 an renouvelable
• Remote: hybrid
• Location: Paris, Île-de-France, FR
• Rate: 63-71 EUR/h
• Languages: French