Atos

SRQ124335 - Experienced SSRS Report Builder (MDX and DAX)

Work location:
Eindhoven
Starting date:
07.01.2019
Ending date:
06.04.2019
Hours per week:
38

Experienced SSRS Report Builder (MDX and DAX)

The department of Project Management is responsible for the implementation of strategic, high-impact, Marketing & Sales Projects with a strong IT component. DAF has a strong Information Technology Division that is able to support Project Teams with a diverse of expertise, required for successful project execution.


At Paccar Parts, we’ve developed FOCUS - a set of opportunity reports for our dealers to monitor and analyze their customer workshop and counter sales. We provide the DAF dealer network with an easy to use analysis tool to quickly identify sales opportunities on both customer, product group and article level.

FOCUS is supported by a Data Warehouse. Its architecture consists out of a SQL 2016 instance with a number of tabular cubes. The tabular model is the basis for the FOCUS reporting system. In a previous version a multidimensional cube was used which is now replaced by tabular. This to provide our dealers with a better performing solution. A set of 24 opportunity reports needs to be rebuilt from MDX to DAX and are SQL Server Reporting Services reports.

We are looking for a report builder who is capable of rebuilding these advanced, high quality opportunity reports for our dealers. The report builder is responsible for:

Rebuilding the SSRS opportunity reports from MDX to DAX
Working on existing tabular model to ensure that it supports the best report response performance

As existing reports are built in MDX (based on multidimensional cube) and the new ones with DAX (based on tabular model), experience with both is required.

Knowledge: Extensive experience with used technologies: SQL Server Analysis Services 2016 (Tabular Models and Multidimensional Cubes), SQL Server Reporting Services.
DAX has no secrets to you, knowledge of MDX is required
Capability to understand, describe and analyze complex business processes
High analytical skills and able to propose alternative solutions
You are enthusiastic, proactive and perseverant

Development environment (including workstation) will be available

< Go back to the overview of all orders