MS Power BI Admin Advisor

Soft tech Career Info system Pvt. Ltd
  • Bangalore
  • 10-12 lakh
  • 6-9 years
  • Views
  • 08 Nov 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

As MS Power BI Administrator, you will be responsible for day-to- day administration of non-production and

production DELL Data Warehouse BI environments. You will work closely with Support and Delivery Teams to

analyze and provide resolutions in a complex Production environment. You will be responsible for installation,

upgrade, configuration, maintenance and monitoring of the Power BI systems, environment and tools. You will also

extend support to Business, Development, Support and other stakeholders.

Role Responsibilities:

? Responsible for administration and engineering support of production Power BI data warehouse environments

and related tools/interfaces/utilities. 

? Upgrading, installing and applying service packs/critical fixes in various environments like Development, Test

and Production environment.

? Administration, Configuration, Maintenance and Support of non-production and production environments.

? Troubleshooting, Monitoring Logs, System resources, connectivity to Source and Target, fail-over etc

? Work with Business, Delivery and Support teams to analyze production issues in a critical, high pressure

situation.

? Identify and act on improvements opportunities.

? Provide inputs in setting governance and standards related to all aspects of the Environments.

? Work with the Team to analyze operational data, identify potential issues and proactively initiate resolution

strategies with other application and IT support team

? Participate in on-call rotation as needed

? Carry out regular maintenance of all servers like server upgrades w.r.t OS, Capacity (RAM, CPU) etc

? Should have experience in infrastructure capacity buy back initiatives on regular basis.

? Should have a good knowledge on Data Warehouse/OLAP knowledge.

? Should maintain and develop documentation related to above applications whenever required.

? Expected to work as a part of Engineering and L3 Support for the above applications



Requirements:

? 6-9 IT Experience

? Good knowledge/expertise on MS-BI technology – SSAS, SSRS, SSIS

? Experience on MS Power BI a must

? Experience in Setting up Power BI infrastructure (cluster/Standalone implementation)

? Experience with Power BI and Power BI configuration and onsite integration

? Experience with Power BI Desktop.

? MS SharePoint Integration, configuration and management.

? SharePoint Power BI component deployment and configuration.

? Experience in setting up SSO implementation

? Experience with Tabular OLAP, design, deployment and optimisation and sizing

? Managing BI content – user creation/management, setting up security

? Hands on – PowerPivot, Power Query, Q and A, Excel Pivots/Charts/grid and Power View.

? Strong understanding of data warehouse design concepts, principles and database structures

? Extensive experience developing queries, reports, and forms in database programs

? Must have knowledge & experience on MSAS Administration & Release Mgmt

? Must have good knowledge on SQL Server 2008 and above.

Preferences

-          Bachelor's degree in Computer science or IT-related field

Dell - Internal Use - Confidential

-          Prior experience with DBMS, SQL Server, SSAS, MSAS.


Competencies/Skill sets for this job

Strategies Optimisation Deployment Documentation

Job Posted By

O.P. Chawla
Director