Technical Solution Architect

Job Description

Define and govern the end-to-end technical architecture for the monitoring solution. Translate SOW requirements into an integrated design covering SSAS DMVs, Extended Events, ALETL logs, SQL Server telemetry storage, time-series analysis, thresholds, Power BI reporting, security, deployment, and operational support.

Provide technical leadership across Data Architecture, SQL Engineering, SSAS Monitoring, Power BI, and QA workstreams. Establish engineering standards, review technical deliverables, resolve cross-workstream dependencies, and ensure consistent implementation of monitoring metrics, baselines, thresholds, RAG status, historical trends, auditability, restartability, and security. Support technical discovery, testing, deployment, production validation, documentation, knowledge transfer, and operational handover.

Key Responsibilities

• Define the end-to-end solution architecture for collecting, processing, storing, and visualising monitoring data.

• Design integration across SSAS DMVs, SSAS Extended Events, dbo.ALETL_Log,



SQL Server, SQL Agent, Git, DACPAC, and Power BI.

• Define the architectural approach for raw, staging, curated, configuration, dimension, fact, snapshot, audit, exception, and serving layers.

• Ensure the solution supports time-series capture, datetime filtering, historical trending, baseline comparison, threshold evaluation, RAG status, and capacity analysis.

• Define non-functional requirements covering performance, scalability, security, availability, auditability, restartability, retention, supportability, and recovery.

• Define technical patterns for scheduling, watermarking, duplicate prevention, exception handling, protected reruns, operational logging, and failure recovery.

• Translate SOW requirements into implementable technical work packages and acceptance criteria.

• Lead technical discovery and validate the availability, quality, and suitability of SSAS, ALETL, SQL Server, and

📌 Data Architect Sr. Advisor (Bengaluru)
🏢 NTT DATA Services
📍 Bengaluru