Data Engineer - SSAS, SQL, DAX

Sketch Lighting; New Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Sketch Lighting seeks a BI Developer to design and optimize SSAS models (tabular and multidimensional) and to translate business requirements into scalable data models. You will implement MDX/DAX queries, manage ETL pipelines, and support Power BI dashboards for stakeholders.

The role emphasizes data quality, governance, and collaboration with analysts to deliver insightful BI solutions across the organization.

Qualifications

• SSAS multidimensional and tabular modeling expertise.
• MDX/DAX proficient querying for complex business logic.
• SQL proficiency for data extraction and transformation.
• Data modeling concepts including fact/dimension and slowly changing dimensions.
• ETL pipelines using SSIS or similar tools.
• Power BI or equivalent BI tools for reporting.
• Understanding of OLAP and OLTP concepts.
• Performance tuning for SSAS and SQL queries.

Responsibilities

• Design, develop, and deploy SSAS models (tabular and multidimensional).
• Write and optimize MDX/DAX queries for complex business logic.
• Translate requirements into robust data models with stakeholders.
• Design and implement ETL pipelines for data integration.
• Build reporting datasets and support BI teams to create dashboards (Power BI).
• Optimize cubes and data models for performance and scalability.
• Ensure data quality, consistency, and governance standards.

Skills

SSAS Tabular/Multidimensional

MDX/DAX queries

SQL Advanced

Data Modeling (Star/Snowflake)

ETL with SSIS

Power BI

OLAP/OLTP concepts

Performance Tuning (SSAS/SQL)

Data Governance

Collaboration

Tools

SSIS

Azure Data Services

Job description

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)
• 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