Job Description:

Key Responsibilities

* Conduct a structured assessment of all 106 SSAS tables: identify redundant tables and columns, inefficient source queries, heavy calculations, and partition strategy gaps.

* Audit the full ETL chain (stored procedures on the read replica DW load SSAS re-ETL) and map transformation duplication and dependencies.

* Diagnose and permanently resolve daily SSAS processing failures (memory pressure, timeouts, locking, connectivity, error handling) using Extended Events, SQL Server Profiler traces, msmdsrv logs, and DMVs.

* Redesign the SSAS refresh strategy: implement partitioning and incremental processing to replace the current full daily refresh, targeting a processing window under 30 minutes.

* Optimise SSAS memory usage and model design (column/table pruning, data type and encoding optimisation, relationship and calculation tuning, aggregation strategy, query/storage mode evaluation).

* Refactor and consolidate transformation logic into a single,



auditable pipeline; eliminate re-ETL inside SSAS where possible by pushing transformations to the DW layer.

* Redesign the DW load pattern (currently daily full snapshot filtered to current date) toward incremental/delta loads where feasible.

* Perform SQL Server database and query performance optimisation: stored procedure tuning, indexing, statistics, execution plan analysis.

* Implement robust error handling, retry logic, data validation, reconciliation checks, and automated monitoring/alerting for the daily processing chain.

* Work with the client's architects, analysts, and business stakeholders; operate independently against a fixed 2-month timeline.

* Deliver updated architecture documentation, an operational runbook for the SSAS process, and monitoring recommendations; complete structured knowledge transfer before engagement close.

Required Technical Stack

The candidate must have solid hands-on experience with:

SQL Server Analysis Services (SSAS) deep

📌 Senior Data Engineer (Chennai)
🏢 TrueTech Solutions
📍 Chennai