Description
The objective of the job:
- Define a SQL Server AG framework for BI: development standards, metadata management, logging
- Integrate all non-functional requirements to gather from the DWH team and infra team.
- Study of the migration from SAS storage to SQL Server: define the approach, technical migration follow-up and take part to it.
- Provide architecture, design & support on new or existing SQL Server solutions: BI solutions (analysis/reporting/dashboarding) based on SQL Server 2014 & 2017 including SSIS/SSAS/Power BI/DAX.
- Dashboard, KPI & metrics.
- Provide Microsoft database & BI technology expertise (SQL server, etc.) across IT.
- Provide guidance on SQL Server development (best practices, architecture guidelines, etc.)
- Support & coaching to SQL server developers
Business experience required:
- 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 as technical architect on SQL Server solutions projects (BI and/or operational DB applications)
- Experience in DWH concepts and run