MSBI Developer with SSIS/SSRS

MSBI Developer with SSIS/SSRS

Elait | Chennai, TN, IN

Posted a month ago

Apply Now

Description

MSBI developer

Minimum of 6+ years of experience in developing Business Intelligence Solutions


Minimum of 4+ years of experience in delivering scalable and performant OLAP solutions using providers like Microsoft SSAS (Multidimensional and Tabular) or OLAP platforms like Kyvos.

Responsibilities:

  • Ensuring production of high-quality BI reporting solutions to agreed schedules and following the agreed team standards and processes.
  • Building a variety of SSAS tabular and dimensional cubes, given a requirement, identify the dimension/measure group relationship that should be selected.
  • Implement design patterns for representing business facts and dimensions (many-to-many relationships)
  • Dimension design to support multiple related measure groups (many related fact tables), handle degenerate dimensions in a cube, identify the attributes for dimensions, identify the measures, aggregation behaviour for the measures, build hierarchies, define granularity of dimension relationships.
  • Select appropriate aggregation functions, format measures, design the measure group for the correct granularity
  • Implement non-additive or semi-additive measures in a cube, define measures, perspectives, translations, implement reference dimensions, many to-many relationships, role-playing relationships
  • Using MDX as a query language, write statements that return the required result, implement a custom MDX solutions for various business scenarios.
  • Define key performance indicators (KPIs), calculated members, relative measures (growth, YoY, same period last year etc), percentage of total using MDX.
  • Build named sets, add Time Intelligence, implement ranking and percentile etc
  • Cube database management covering aggregations, partitions, storage modes, proactive caching etc.
  • Cube performance tuning and consequences of design decisions, analyse and optimize performances of an MDX/DAX query for huge data sets, calculations.
  • Define processing of databases, cubes, and dimensions for multidimensional models

Mandatory skills and experience

  • Experience in an enterprise environment with massive datasets and event-based systems in a fast-paced environment with self-managing teams.
  • Ability to work in a fast-paced environment while maintaining a strong eye for detail
  • Excellent SSAS cube development experience and advanced MDX skills
  • Cube administration, performance tuning and troubleshooting experience.
  • Dimensional Modelling
  • SQL/T-SQL Development
  • Big data ecosystem
  • Programming languages such as Python, C# .Net. Shell scripting.

Good to have:

  • Google Cloud Platform experience
  • Teradata datawarehouse experience.