Roles & Responsibilities

• Lead Server Administration activities for SSAS (SQL Server Analysis Services) & SSRS (SQL Server Reporting Services) for On-Premise implementation
• Build PowerShell scripts required for processing data in SSAS & SSRS reports
• Analyse and trouble-shoot SSAS, SSRS and In-Memory related production issues by collaborating with other technical, vendor and business teams; Drive performance tuning
• Resolve connectivity issues of MBI solution with underlying Teradata based Data Marts & Enterprise Data Warehouse
• Handle and maintain BAU deployed applications to ensure stability, reliability, security, performance and SLA monitoring in SIT, UAT and production environment
• Liaise with the end-user and technical solution team to implement solutions that align with the organization's business objectives.
• Lead initiatives for improving data refresh processing from SSAS to Teradata using In-Memory Models
• Create frameworks, technical features which helps in faster operationalisation of Reporting solutions
• Independently install, customise and integrate software packages and programs
• Manage the technical delivery within timeline and with quality
• Carry out POCs involving new data technologies
• Ensure end-user satisfaction and meeting service level agreement
• Create technical documents such as solution design, program specifications for target solutions
• Maintain and recommend software improvements to ensure a platform centric management of software applications
• Work on delivering Change Request and Project implementation for Microsoft PBI solutions
• Involve in UAT, user training, pre-implementation preparation and post-implementation support activities
• Maintain and support MBI environment
• Ability to train users effectively to use the reporting tool, to build, customize & schedule reports

• 6+ years of experience in implementing SSAS administration and SSRS development
• Expertise in On-Premise environment for SSAS & SSRS Server Administration, PowerShell scripting
• Expertise in designing modular Control-M jobs for refreshing SSAS In-Memory Models
• Expertise in performance optimization for SSAS Tabular models using Direct Query and In-Memory Models
• Experience in optimizing SSAS design by assessing DAX queries hitting Teradata based Data Warehouse & Data Mart
• Expertise in Windows / NT and SQL Server Administration
• Experience in monitoring SSAS & SQL Server statistics
• Expertise in SSAS design, derived measures, SSRS reports & Data Modeling
• Knowledge of different code standards for SSAS, SSRS & PowerShell scripting; skills in leveraging reusable code components
• Experience in creating dashboards, volume reports, operating summaries, and presentations and graphs
• Hands on experience other BI Tools (Qlik) and Big Data tool stacks
• Knowledge in Data modelling, working with calculations, leveraging the Set Analysis
• Ensure incorporation of best practices and lessons learnt from prior projects

• Finance & Risk management domain knowledge
• Should have worked in large scale data warehouse & on premise Power BI, Qlik based visualisation

• Strong analytical, interpersonal & communication skill - - ability to convey technical information to non-technical audience
• Fast Learner, enjoy analytical and data modelling work and proactive in providing solutions
• Good interpersonal and communication skills with attention to details
• Be forward looking and agile to adapt to changing banks needs and dynamic working environment
• Identify ideas to improve system performance and impact availability
• Embrace tackling and resolving complex technical design issues
• Possess strong problem solving and decision-making skills while exercising good judgment
• Ability to work on multiple projects at a time
• Be able to work under pressure and manage deadlines or unexpected changes in expectations or requirements
• Ability to work in a team distributed across multiple locations

Qualification / Certifications

Degree in Computer Science or related discipline

Certification from Windows / NT server administration, SQL Server Administration

Certification in PowerShell scripting

Tell employers what skills you have

UAT
Teradata
Data Modeling
Powershell
Agile
Scripting
Administration
Service Level
SQL
SQL Server
Windows
Performance Tuning
SSRS
Analysis Services
Technical Design