Attractive Job Opening for Power BI Admin in

**Key Responsibilities**

**Key responsibilities for this role are**:

- 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
- 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
- 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 bank’s 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