Description
Proteus Europe is searching for a SQL Server developer to join its integration team. The IS Integration team is managing the integration flows mainly with external partners or with packages. Architecture, design and implementation are managed within the team.Our Client :-
Our client is a large player in the insurance industry, based in Brussels, Belgium.
Your New role :-
Design, development and support on SQL server solutions:
o Application/operational relational databases based on SQL Server 2014 or higher including SSIS/SSRS.
o BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 or higher including SSIS/SSRS.
- Support on user requirements gathering and analysis, functional and technical analysis of specific requirements when related to SQL server ETL or BI.
Your Skills and experience :-
Essential Skills :-
-Experience as ETL developer on SQL server platform
-Experience as a SQL server database developer (tables, views, triggers, unions, joins, complex queries, stored procedures)
-Experience as BI developer on SQL Server based technologies
Good knowledge and hands on experience in SQL Server
2008 R2 or SQL Server 2012 or SQL Server 2014 (tables, views, triggers, unions, joins, complex queries, T-SQL and stored procedure programming.
-Good knowledge and hands on experience in ETL (SSIS)
-Good knowledge and hands on experience in reporting with SSRS.
- General Knowledge on SQL server working
- Knowledge .NET C# and traditional data access techniques such as ADO.NET
Functional and technical analysis on database solutions
- Understanding of Best Practices for SQL server Database, datawarehousing, ETL and BI solutions across the Enterprise
-Database modelling via modelling tools such as Erwin or Visio
Desirable Skills :-
-Experience as BI analyst on SQL Server based technologies
-Experience on projects with different technology stacks,integration aspects (with packages or external solutions) and infrastructure aspects
-Experience as technical designer on SQL Server solutions projects (BI and/or operational DB applications)
-Experience in dashboard and scorecard (with SQL server)
-Experience on .NET applications development
-Experience within Insurance or financial or risk domain
Knowledge of BI reporting: OLAP design and implementation
(SSAS) and overall framework (MS office pivot table, power pivot, etc.)
- Knowledge of Power BI
Fluency with appropriate tools including SQL Management Studio, Profiler, Performance Monitor and other SQL Server management tools or related tooling as the MS Office suite.
- Knowledge and hands on Performance tuning and index management
Ability to interact with Business Owners and gather
Business Requirements
Ability to translate Business Requirements into functional and
technical Requirements.
Proteus Europe operates in partnership with our candidates by
building strong and lasting relationships at all levels.
If you apply for this role, we will:
- Contact you within one week to discuss your current
situation and suitability for this role.
- Keep searching for other suitable positions should this role not
be right for you.
- Keep you informed at every stage of the recruitment process.
- Actively follow up with our client on your behalf to gain useful
feedback throughout the process.
If you are looking for a new role, but this role isn't quite right for
you, please contact us in confidence for a discussion about
how we can help you.