Description

You will manage data warehouse development and reporting tasks using modern SQL Server technologies.

Responsibilities

• Develop new functionality for current data warehouses and reports using updated technology stacks.
• Organize technical and end-user testing for deployment across different environments.
• Create and maintain technical and end-user documentation.
• Deploy software using source control solutions.

Required Skills

• 5+ years of experience in SQL Server environments.
• Microsoft Reporting Services 2012 and 2019/2022 including SQL Server Data Tools and Report Designer/Manager.
• Microsoft Analysis Services 2012 and 2019/2022 with experience in Dimension/Cube Designer and OLAP cubes.
• Advanced MDX calculations, hierarchy creation, and security model application.
• Microsoft Integration Services (SSIS) 2012 and 2019/2022 for package design, control flows, and data flows.
• Microsoft SQL Server 2012 and 2019/2022 database administration.
• Strong T-SQL programming including procedures, indexes, constraints, partitions, triggers, CTEs, and temporary tables.
• Data modeling expertise using Star schema, Kimball methodology, normalization, denormalization, and multiple fact/date tables.
• Ability to create reports over relational and multidimensional data sources.

Preferred Skills

• Microsoft Power BI including data models, power queries, DAX, and visualizations.

Key Skills

Education

Any Gradute