Data Engineer SSAS, SQL, DAX (Bengaluru)

• Data Engineer SSAS, SQL, DAX (Bengaluru)
• Company: Sketch Lighting
• Job Location: Bengaluru, Karnataka, India
• Employment Type: Full-time
• Primary Skills
• SQL (Advanced Level)
• SSAS (SQL Server Analysis Services) Multidimensional and/or Tabular Model
• MDX / DAX (strong 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)
• Solid 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 .