Primary Skills

SQL (Advanced Level)

SSAS (SQL Server Analysis Services) Multidimensional and/or Tabular Model

MDX / DAX (solid querying capabilities)

Data Modeling (Star Schema, Snowflake Schema)

Secondary Skills

ETL processes (SSIS or similar tools)

Power BI / Reporting tools

Azure Data Services (optional but a plus)

Role & Responsibilities

Design, develop, and deploy SSAS models (both tabular and multidimensional).

Write and optimize MDX/DAX queries for complex business logic.

Work closely with business analysts and stakeholders to translate requirements into robust data models.

Design and implement ETL pipelines for data integration.

Build reporting datasets and support BI teams in developing insightful dashboards (Power BI preferred).

Optimize existing cubes and data models for performance and scalability.

Ensure data quality, consistency, and governance standards.

Top Skill Set





SSAS (Tabular + Multidimensional modeling)

Strong MDX and/or DAX query writing

SQL Advanced level for data extraction and transformations

Data Modeling concepts (Fact/Dimension, Slowly Changing Dimensions, etc.)

ETL Tools (SSIS preferred)

Power BI or similar BI tools

Understanding of OLAP & OLTP concepts

Performance Tuning (SSAS/SQL)

Skills: analytical skills,etl processes (ssis or similar tools),collaboration,multidimensional expressions (mdx),power bi / reporting tools,sql (advanced level),sql proficiency,dax,ssas (multidimensional and tabular model),etl,data modeling (star schema, snowflake schema),communication,azure data services,mdx,data modeling,ssas,data visualization

📌 Data Engineer – SSAS, SQL, DAX (Gurugram)
🏢 Sketch Lighting
📍 Gurugram