SQL Server (SQL Developer and data modeler)

SQL Server (SQL Developer and data modeler)

Bangalore

Contract

Description:

POSITION OVERVIEW : Data Engineer (SSAS Monitoring)

POSITION GENERAL DUTIES AND TASKS :

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

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

VDart: Digital Consulting & Staffing Solutions

VDart is a leading digital consulting and staffing company founded in 2007 and headquartered in Alpharetta, Georgia. VDart is one of the top staffing companies in USA & also provides technology solutions, supporting businesses in their digital transformation journey. Digital consulting services, Digital consulting agency

Core Services:

• Digital consulting and transformation solutions
• Comprehensive staffing services (contract, temporary, permanent placements)
• Talent management and workforce solutions
• Technology implementation services

Key Industries: VDart primarily serves industries such as automotive and mobility, banking and finance, healthcare and life sciences, and energy and utilities. VDart - Products, Competitors, Financials, Employees, Headquarters Locations

Notable Partnership: VDart Digital has been a consistently strong supplier for Toyota since 2017 Digital Transformation Consulting & Strategy Services | VDart Digital, demonstrating their capability in large-scale digital transformation projects.

With over 17 years of experience, VDart combines staffing expertise with technology solutions to help organizations modernize their operations and build skilled workforce capabilities across multiple sectors.