EY Senior Consultant - TMT - RAS - Delhi in Delhi, India

Title: Senior Consultant - TMT - RAS - Delhi

Location: IN-Delhi

Job Number: DEL00261

Purpose of your role

Cyber Security & Technology Risk is creating Data Warehouse (SDW) focussing on the import and aggregation of data from various IT Security and Information Security applications. The SDW provides a central store for security and risk related data,

Supporting dynamic generations of reports, which will be used at varying levels of the business and management reporting plus lower level reporting to enable remediation, compliance and operational support. Role is required to work on the database aspects of the warehouse.

Key Responsibilities

• Interpret data import and output requirements and design/implement/maintain an appropriate data model (identify facts and dimensions)

• ‘On-board’ new data sources into database

• Manage DB access privileges

Qualifications:

Experience and Qualifications Required

Above 6 Years of progressive working knowledge of database and BI technologies

• In-depth knowledge of TSQL

• Experience of performance tuning and optimising SQL Server installations, including TSQL, stored procedures, indexing and end-to-end architecture

• Extensive SQL Server experience in a development environment responsible for design, build and configuration

• Design and implement star and snowflake schemas

• Knowledge of Kimball database modelling methodologies

• Data Warehouse experience using SSIS

• Ability to read and understand SQL Server query plans

• Experience implementing and administrating SQL Server 2012 and later versions, including knowledge of best practices

Advantageous skills

• SQL Server MCSE or MCITP certification

• Report writing skills using SSRS and Power BI

• PowerShell