Our client is an information technology services firm that has a rich history of providing comprehensive technology services and solutions for five decades.

As a pioneer in IT services, we’ve partnered with some of the biggest global corporations across many industries. Our history was built on a foundation of partnerships with global brands like McDonald’s, Microsoft, CIT Group, Johnson & Johnson, Herbalife, Sony Pictures Entertainment, and many others. Whether it’s providing dedicated support centers, staffing quality teams, or delivering business service solutions, clients can always count on us.

Job Title: SrBusiness Intelligence Developer (BI Developer) [5-10 Years]
Department: Reporting and Analytics
Work Timings: 1:30 PM to 10:30 PM IST

Position Summary: The BI Developer is responsible for supporting the business areas and clients by developing business intelligence solutions leveraging the Microsoft technology platform (SQL Server, SSRS, SSAS, SSIS and Excel BI tools).

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Develop complex SQL stored procedures/views as required
• Create variety of complex reports using SQL Server Reporting Services, including but not limited to drill down, drill through, tabular, matrix, dashboard, multi parameter reports, etc.
• Analyze data to provide recommendations to AVP of group on issues and improvements
• Provide advice and guidance on database good practices
• Provide input on systems architecture as required.
• Identify areas and processes where performance can be improved.
• Make and justify recommendations for improvement.
• Continuously tune and optimize SQL queries. Ensure that code and other deliverables adhere to company standards.
• On-call status is a requirement of the position.
• Work on special projects as needed.

Qualifications:Any Engg/ MCA

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Special skills/abilities/competencies required:
1. Working experience of SQL Server 2008
2. Excellent data analysis skills using SQL
3. Working experience of Dynamic SQL
4. Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
5. Working experience of SQL Server Reporting Services
6. Working experience of SQL Server Analysis Services
7. Working experience of SQL Server Integration Services is a plus
8. Strong analytical skills and a strategic thinker
9. Understanding of Mortgage servicing including loss mitigation, collections, fc/bk, default reporting and general loan servicing
10. Excellent working knowledge of Excel
11. Excellent communication skills (verbal, written, interpersonal and large group)
12. Excellent interpersonal and listening skills
13. Strong interpersonal/relationship building skills
14. Problem solving and decision making ability
15. Strong organizational skills and ability to work with details
16. Ability to work well independently and with a team