Business Intelligence Support Analyst

Job Title:Business Intelligence Support Analyst
Shift Timing: 8:00 PM -5:30 AM IST
Location: Pune, Bangalore, Chennai, Noida, Hyderabad
Notice Period: max 30 days joiners

Business Intelligence Support Analyst
Job Summary:
We are seeking a skilled Business Intelligence Support Analyst to provide technical support and maintenance for applications built on Microsoft technologies. The ideal candidate will have hands-on experience with Microsoft SQL Server, SSRS, SSAS and SSIS. This role involves troubleshooting, performance optimization, and collaborating with development teams to ensure seamless application functionality.

Key Responsibilities:
Application Support & Maintenance:
o Provide Level 2/3 support for business-critical applications, ensuring minimal downtime.
o Diagnose, troubleshoot, and resolve application issues promptly.
o Monitor application performance and implement fixes or enhancements as needed.
Integration & Development Support:
o Support Business Intelligence application integrations and manage message flows, orchestrations, and pipelines.
o Assist in maintaining and enhancing Business Intelligence applications using SQL Server (2019), SSRS (2016, 2019), SSAS (2016, 2019) and SSIS.
o Collaborate with developers to deploy patches, updates, and new features.
Database & Reporting:
o Manage and optimize SQL Server databases, including stored procedures and triggers.
o Design and maintain SSRS/SSAS/SSIS reporting for business intelligence and operational needs.
Documentation & Compliance:
o Maintain accurate documentation for application configurations, troubleshooting steps, and standard operating procedures.
o Ensure compliance with security and governance standards.
Continuous Improvement:
o Identify opportunities for AI, automation and process optimization.
o Stay updated with emerging technologies and recommend improvements.

Required Skills & Qualifications:
Strong experience in Microsoft SQL Server development.
Strong experience in Business Intelligence development using Microsoft SSRS, SSAS and SSIS.
Experience with AI coding and automation tools.
Excellent problem-solving and communication skills.

Preferred Qualifications:
Experience with DevOps, CI/CD pipelines, and cloud deployments.
Knowledge of ITIL processes and service management best practices.
Exposure to performance tuning and security hardening for applications.

Education:
Bachelor's degree in Computer Science, Information Technology, or related field.