Data Engineer - SSAS, SQL, DAX

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