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 (Noida)
🏢 Sketch Lighting
📍 Noida