SQL Server (SQL Developer and data modeler)

POSITION OVERVIEW : Data Engineer (SSAS Monitoring) / SQL Server (SQL Developer and data modeler)

POSITION GENERAL DUTIES AND TASKS :

Must have : SSAS, start schema and good data modeling experince

Job Description

Design and implement a scalable, time-series SQL Server data model for SSAS monitoring. Translate SSAS health, processing, workload, dimension growth, DMV, Extended Events, threshold, and derived metric requirements into appropriate tables, facts, snapshots, configurations, and reporting views. Develop advanced T-SQL procedures, transformations, event correlation, incremental loads, audit controls, exception handling, restart ability, and performance optimization. Ensure accurate historical trending, datetime filtering, data lineage, reconciliation, and Power BI integration. Maintain all database objects using SSDT and Git, produce validated DACPAC deployment packages, and support testing, controlled deployment, rollback, production validation, technical documentation, and knowledge transfer to ICBCS support teams after deployment.

Key Responsibilities

• Perform source-to-metric traceability and define metric lineage.
• Define subject areas, dataset grains, entities, relationships, and conformed dimensions.
• Design logical and physical models covering raw, staging, curated, dimension, fact, configuration, and serving layers.
• Design snapshots, effective dating, SCD history, indexing, and partitioning.
• Implement the SSDT database project, schemas, tables, facts, dimensions, snapshots, configuration objects, and serving views.
• Develop ALETL log parsing, event correlation, stored procedures, and SQL Agent processes.
• Implement configurable threshold, baseline, collection, and routing structures.
• Perform developer unit testing for schemas, data flows, SCD processing, facts, snapshots, configuration, views, indexes, and DACPAC deployment.

Skill Set

• Strong conceptual, logical, and physical data-modelling experience
• Dimensional, event, snapshot, and time-series modelling
• Advanced SQL Server and T-SQL development