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
Technical & Functional Skills
Technical Skills
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
Functional Skills
Finance & Risk management domain knowledge
Should have worked in large scale data warehouse & on premise Power BI, Qlik based visualisation
Other Critical Skills
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