Description
Description:
Our client is actively searching a SQL Server BI developer to join its data integration team. The Data Integration team is managing the integration flows with external partners or with packages, as well as preparing data for reporting & analytics. Architecture, design & implementation are managed within the team.
Responsibilities:
Design, development & support on SQL server solutions:
- Application/operational relational databases based on SQL Server 2014 or higher including SSIS/SSAS Tabular.
- BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 or higher including SSIS/SSAS/PBI/DAX.
- Support on user requirements gathering & analysis, functional & technical analysis of specific requirements when related to SQL server ETL or BI.
Technical 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
- Experience on Power BI
- Experience as BI analyst on SQL Server based technologies
- Experience on projects with different technology stacks, integration aspects (with packages or external solutions) & infrastructure aspects
- Experience as technical designer on SQL Server solutions projects (BI and/or operational DB applications)
- Experience in dashboard & scorecard (with SQL server)
- Experience within Insurance or financial or risk domain
- Experience on Microsoft Azure Data Platform
- Experience on DAX
- Good knowledge and hands on experience in SQL Server: SQL Server 2014 and SQL 2017 (tables, views, triggers, unions, joins, complex queries, T-SQL & stored procedure programming.
- Good knowledge and hands on experience in ETL (SSIS)
- Knowledge of BI reporting: OLAP SSAS tabular design & implementation & overall framework
- Knowledge of Power BI
- General Knowledge on SQL server working
- 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 & hands on Performance tuning & index management
- Functional & technical analysis on database solutions
- Understanding of Best Practices for SQL server Database, data warehousing, ETL & BI solutions across the Enterprise
- Database modelling via modelling tools such as Erwin or Visio
- Ability to interact with Business Owners and gather Business Requirements
- Ability to translate Business Requirements into functional & technical Requirements.