SQL Server Resource

Job Description:

Responsibilities:

•              Full responsibility with supervision of new development tasks to enable future functionality of current data warehouse and reports in newer technology for above projects

•              Organizing technical and end user testing for final deployment to different technical environments with Andreas Mehlberg

•              Creating and maintaining technical and end user documentation if needed

Technical Skill:

Microsoft Reporting Services 2012 plus 2019/2022 (Mandatory)

•              SQL Server Data Tools and Report Designer/Manager

•              Able to create reports over different data sources (relational, multidimensional)

Microsoft Analysis Services 2012 plus 2019/2022 (Mandatory)

•              SQL Server Data Tools and Dimension/Cube Designer

•              Able to create different types of hierarchies and relationships

•              Able to create OLAP cubes with MDX calculations and different designs

•              Able to apply different security models

•              Able to deploy to different SQL Server environments

Microsoft Integration Services 2012 plus 2019/2022 (Mandatory)

•              SQL Server Data Tools and SSIS package design

•              Able to create control and data flows

•              Able to apply different package deployment models

Microsoft SQL Server 2012 database administration plus 2019/2022 (Mandatory)

Strong T-SQL language (querying and programming) (Mandatory)

•              Able to create/maintain SQL Server procedures, indexes, constraints, partitions, triggers, CTEs, temporary tables and more

Microsoft Power BI (Preferable)

•              Able to create data models, power queries, DAX and visualizations

Data modeling (Mandatory)

•              Star schema/Kimball

•              Normalization and denormalization

•              Multiple fact tables

•              Multiple date tables

Source Control solution (Not Mandatory)

•              Able to deploy software