Job Title: Microsoft BI Administrator
Key Skills: MBI
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
