The Data Engineer, Microsoft BI Developer & Administrator, is a member of the Data Analytics Technology team. This role will be responsible for the end-to-end software development and support for all work related to projects, quarterly change requests, L3 production fixes. This includes software product implementation and administration, application design, development, implementation, testing and support. You will be expected to work on Finance & Risk Analytics domain.
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, Excel Add In 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 / Hadoop 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.
- 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
The right candidate should possess:
- Min. 6+ years of experience in implementing SSAS & SSRS development & SSAS administration for On-Premise version of Microsoft Power BI
- Good knowledge of Power BI Server Architecture, expertise in PowerShell scripting
- Expertise in designing modular scheduling jobs (e.g. using Control-M) 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 - 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
- Have Finance & Risk management domain knowledge
- Worked in large scale data warehouse & on premise Power BI, Qlik based visualisation
