Systems Integration Advisor

About the role

Design and build the SQL Server data foundation for the monitoring solution, converting raw SSAS/ALETL telemetry into traceable, historised, queryable and Power BI-ready information.

What you'll do

• Perform source-to-metric mapping for ALETL logs, RunContext, SSAS DMVs and Extended Event outputs
• Design logical and physical data models covering raw, staging, curated, dimension, fact, snapshot, configuration, audit, exception and serving layers
• Define fact grain, keys, conformed dimensions, SCD/history patterns, indexing and retention design
• Develop advanced T-SQL procedures, views and transformations for monitoring and observability data
• Correlate processing events using available identifiers and RunContext information without relying only on timestamps

What you need

• 8–14 yrs of experience
• SQL
• Git
• Power BI
• Data structures
• SQL Server
• Data modelling
• Any graduate

Good to have

• Unit testing
• Reconciliation