MSBI Lead

Location: Pune, India

 
background-blue-simplify-3.jpg
 

Role

The role of MSBI Lead will primarily be involved in SQL Server Development including TSQL, stored procedures, SQL CLR, troubleshooting and performance tuning. The role will also be required to work with developers to ensure performing designs, identifying bottlenecks and recommending better ways of designing and implementing complex solutions.

Responsibilities

  • Communicate with the business teams and clients for requirements
  • Estimate, plan and schedule deliveries
  • Troubleshoot production issues with minimal support
  • Manage deployments and releases
  • Source code configuration and management
  • Report accurate status to all stakeholders

Requirements

  • Expertise in SQL Server Development including TSQL, stored procedures, SQL CLR, troubleshooting & performance tuning
  • Expertise in knowledge SQL Server best practices
  • Experience with SQL Server 2008/2012 in a production environment
  • Ability to work with developers to ensure performing designs, identifying bottlenecks and recommending better ways of designing and implementing complex solutions
  • Superior database design and architecture skills from an OLTP perspective (as well as a data warehousing perspective would be plus)
  • Expertise in SSRS Report Deploy Using Script / Report Manager
  • Expertise in SSRS Configuration Manager
  • Expertise in SSRS Report Manager
  • Expertise in Configuring the Data Sources & Security Configuration
  • Expertise in SSIS Catalog
  • Expertise in SSIS Project Deployment Methodology
  • Expertise in SQL Server Agents (Creating a Job & Monitoring the Jobs)
  • Basic Knowledge on SQL Server Database monitoring & maintenance
  • Experience in PowerShell scripting using .net and SQL components
  • Experience in SQL source control & versioning.
  • Experience in Team foundation server/SVN would be a plus.
  • Very articulate with both strong oral and written communication skills
  • Exceptional problem-solving, troubleshooting and organizational navigation skills

Technical Competencies

  • Experience in BI tools like SSRS or SSIS
  • Microsoft Word applications/ add-ins
  • JIRA and SVN
  • Project management

If you have any questions, please direct your inquiries to careers@simplifyhealthcare.com

*All personal information submitted by you as part of this job application will be used by us in accordance with our Privacy Policy.