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).
Salary
: AED 6,000 – 8,000
Experience
: 5 – 10 Years
Joining Date
: ASAP
Job Location
: Abu Dhabi – UAE
Industry Type
: Software
Function
: Reporting & Analytics
Reporting To
: Manager
Job Type
: Full Time
Job Description
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 / Desired Profile
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:
Working experience of SQL Server 2008
Excellent data analysis skills using SQL
Working experience of Dynamic SQL
Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
Working experience of SQL Server Reporting Services
Working experience of SQL Server Analysis Services
Working experience of SQL Server Integration Services is a plus
Strong analytical skills and a strategic thinker
Understanding of Mortgage servicing including loss mitigation, collections, fc/bk, default reporting and general loan servicing
Excellent working knowledge of Excel
Excellent communication skills (verbal, written, interpersonal and large group)
Excellent interpersonal and listening skills
Strong interpersonal/relationship building skills
Problem solving and decision making ability
Strong organizational skills and ability to work with details
Ability to work well independently and with a team
